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
|