f



Excel Cell Math

Is there a way to do the following:  =1400/B3-1  Where B3-1 will return
the value of the cell directly above it.

Thanks

Bill

0
Stout
6/29/2005 7:25:30 PM
comp.apps.spreadsheets 1327 articles. 0 followers. Post Follow

1 Replies
650 Views

Similar Articles

[PageSpeed] 50

Stout wrote...
>Is there a way to do the following:  =1400/B3-1  Where B3-1 will return
>the value of the cell directly above it.

In a generic location, =1400/INDIRECT("R[-1]C",0) . On the other hand,
if you were entering this formula in, say, X99, why not =1400/X98 ?

0
Harlan
7/1/2005 4:59:44 PM
Reply: