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

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:

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!