On 2017-10-25 13:15, Suzanna Reiff wrote:
I want to construct a document.
Spreadsheet document?
It has fiver columns : 1. base number 2. I need to subtract '71' from the number in column 1. then :
So you need to set column B to contain what is in Column A and subtract 71?
I am really curious what your application is... So you need to do something like "=A1 - 71" in to cell B1.
3. I need to divide the result of columns 1 and 2 by "5'
Do you mean that column C must contain (A1 - 71) / 5, and you need to pull the value from column B?
4 I need to divide the result of columns 1 and 2 by "8" 5. I need to divide the result of columns 1 and 2 by "11' Suzanna Reiff suzannare...@aol.com
Is this for a class, or do you simply need to create some data for your own personal use?
Are you trying to use regular formulas, or an array formula?
