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 |

6/29/2005 7:25:30 PM

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 |

7/1/2005 4:59:44 PM