How to select preceeding cell in a formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
Click to expand...

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
 
Hi Dennis,

assuming you will do it on the D column

on cell D1 type 1
on cell D2 use the formula =d1+1

and copy it down

HTH
Regards from Brazil
Marcelo

"Dennis" escreveu:
 
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
 
Back
Top