blank cell verses using zero

[redheadnitemare]

I need for a formula to recognize a blank cell and do nothing however when i
put a zero in the blank cell I need the formula to work, right now it is
looking at the blank cell and zero as the same and preforming the formula.
any suggestions.

 

[Max]

Try something like this:
in B1: =IF(ISBLANK(A1),"",SUM(A1:A2))

 

[redheadnitemare]

Thank you, i used ISNUMBER and got it to work..you dont by chance know how to
make a column rotate over one column when certain conditions are meet?

 

[Max]

No prob. Don't have anything to offer you on your other posting.