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!