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

Nel post
*Dennis* ha scritto:

I need to replicate a formula down a column, where each cell is the
value of the preceeding cell (directly above it) + 1. I have no idea
how to do this, being new to Excel. Any ideas would be really helpful.

Thanks!


In A3 put:

=A2+1 and copy down...


--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Ciao

Franz Verga from Italy