| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 | |||
Hybrid Mode
