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!