View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jon Quixley
 
Posts: n/a
Default How to select preceeding cell in a formula?


Dennis,

I hope that this is no more difficult than it seems:

If you have the number 50 in cell B3 and write the formula that follows
in cell B4: =b3+1, the result should be 51. If you then copy this
formula into cell b5, the answer should be 52 and so on.

Is this what you're after?

Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=554190