Cell reference to current cell minus 1

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

Guest

I am having trouble finding out how to do this! I need to reference a
formula to previous cells (rather than to specific cells). I need my formula
to look at the 3 previous cells in the same row and do an IF statement based
on those cell contents. Currently I have:
=IF(B16+C16+D16=0,A15*0.2,0)
but this will always look at the B/C/D16 rather than the 3 cells before the
current one that I need it too. Help!
 
On Wed, 9 Nov 2005 16:37:42 -0800, "Jared Mortlock" <Jared
I am having trouble finding out how to do this! I need to reference a
formula to previous cells (rather than to specific cells). I need my formula
to look at the 3 previous cells in the same row and do an IF statement based
on those cell contents. Currently I have:
=IF(B16+C16+D16=0,A15*0.2,0)
but this will always look at the B/C/D16 rather than the 3 cells before the
current one that I need it too. Help!
Click to expand...

If your formula is in, for example, E16, and you drag/copy it down, the cell
references will adjust automatically.

Read in HELP about Cell and Range references, and the difference between
absolute and relative references.


--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a formula containing the INDIRECT function 7
CF for over/under mean unit 1
copy cells 1
Wrapping to include data from next row 1
Data entered from list automatically enters number in another cell 4
Payment calculation 1
sum everything but errors 5
Using IF function then Autofill-increments down a reference cell 2

Back
Top