View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
INeedID INeedID is offline
external usenet poster
 
Posts: 2
Default Use a formula to define row number

Thank you for your help!

"David Biddulph" wrote:

=INDIRECT("A"&D2^2-1)
--
David Biddulph

"INeedID" wrote in message
...
I would like to define the row number in a formula using a formula.

For example A(D2^2-1) would equal the value in cell A8 when D2 is equal to
3.

Thank you.