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" wrote:

Try something like this:
in B1: =IF(ISBLANK(A1),"",SUM(A1:A2))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"redheadnitemare" wrote:
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.