variables in cell references in formulas

  • Thread starter Thread starter gedalia
  • Start date Start date
G

gedalia

Help!

How do I format and/or write the equation by which Excel
2000 will calculate and input the result into any cell in
column 3 of my worksheet as follows?

Background: If "x" is a variable representing any
particular row number in Column 3, I want Excel to
calculate and input the result of the following formula in
any row "x" of column 3 of my worksheet:

= [Numeric value entered in cell at
Column 2, Row "x"] minus [Numeric value entered in cell at
Column 2, Row "x-1"]

So, for example, if the formula happens to be located in
the cell at column 3, row 5; then "x" = row "5"; and I
want Excel to calculate the difference between the number
I've already entered into the cell at column 2, row 5 and
the number entered into the cell at column 2, row 4.

Or, if the formula is at Column 2, Row 23, then "x" =23,
so I want Excel to calculate the difference between the
number I've already entered into the cell at column 2, row
23 and the number entered into the cell at column 2, row
22.

And so on.

so, as I continue to enter new numeric data into Column 2,
Row 24, Row 25, Row 26, and so on.the results of my
formula will automatically be entered into Column 3, Row
25, Row 26, and so on.

I know this must be easy to an intermediate or advanced
user of Excel 2000, or successive versions, but I am a
novice and do not know how to better describe my query in
precise Excel terminology, so forgive me.

Thanks,
Gedalia
3/11/2004
 
Hi
try entering the following formula in C5
=B5-B4

copy this formula for all your rows
 
If the data, say, in B starts in B2, in C3 enter & copy down as far as you
expect data in B:

=IF(ISNUMBER(B3),B3-B2,"")

....
Background: If "x" is a variable representing any
particular row number in Column 3, I want Excel to
calculate and input the result of the following formula in
any row "x" of column 3 of my worksheet:

= [Numeric value entered in cell at
Column 2, Row "x"] minus [Numeric value entered in cell at
Column 2, Row "x-1"]
Click to expand...
[...]
 
Back
Top