Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell reference to current cell minus 1
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! |
#2
|
|||
|
|||
Cell reference to current cell minus 1
=OFFSET(C8,-342,)
looks at C5 -- Regards, Peo Sjoblom (No private emails please) "Jared Mortlock" <Jared wrote in message ... 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! |
#3
|
|||
|
|||
Cell reference to current cell minus 1
|
#4
|
|||
|
|||
Cell reference to current cell minus 1
Thanks heaps. Got it now using =OFFSET(E21,0,-2).
"Peo Sjoblom" wrote: =OFFSET(C8,-342,) looks at C5 -- Regards, Peo Sjoblom (No private emails please) "Jared Mortlock" <Jared wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return cell reference of lookup value | Excel Worksheet Functions | |||
Name Box cell reference | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
name of another worksheet in cell for reference | Excel Worksheet Functions | |||
cell reference show cell name (ie. D45) and not cell value | Excel Worksheet Functions |