Check if Blank, If so, Check the Next Cell

Watterboy,

Attached is an exammple workbook based on the criteria you provided. In Column A is the Value, Column B is the subtraction. Row 1 is headers, so data starts on row 2. Because there is no subtraction happening for the first value, cell B2 is blank. The subtraction formula starts in cell B3:
=IF(OR(A3={"","~"}),"Null",A3-LOOKUP(2,1/(ISNUMBER($A$2:A2)),$A$2:A2))

And is copied down. Is something like that what you were looking for?

Originally Posted by tigeravatar

Watterboy,

Attached is an exammple workbook based on the criteria you provided. In Column A is the Value, Column B is the subtraction. Row 1 is headers, so data starts on row 2. Because there is no subtraction happening for the first value, cell B2 is blank. The subtraction formula starts in cell B3:
=IF(OR(A3={"","~"}),"Null",A3-LOOKUP(2,1/(ISNUMBER($A$2:A2)),$A$2:A2))

And is copied down. Is something like that what you were looking for?

This seems to be exactly what im looking for! That is some awesome code work. Could you possibly explain how you used the LOOKUP command? I understand everything else that you did in the code, but Ive never used the LOOKUP command and I'm not understanding how it works or how you used it.

Your method is far more elegant and effective than how I did it. I used a series of IF statements that performed checks. It was only effective up to 5 cells.

Thanks again!