C
Cheryl Schuberth
I'm creating an IF statement to add up cells dependent on
whether a cell is blank or not and I can't seem to get
Excel to differentiate between a zero and a null cell
value. I'm using this to handle original versus revised
forecast values where column A is original and column B
are the revised values which may be blank if there is no
revision.
The IF statement looks like this: =IF(B1>=0,B1,A1).
If the revision is from $50,000 to $0.00, for example, or
if there is no revision and that cell is blank, the
formula returns the same results.
Can anyone provide any direction on this?
whether a cell is blank or not and I can't seem to get
Excel to differentiate between a zero and a null cell
value. I'm using this to handle original versus revised
forecast values where column A is original and column B
are the revised values which may be blank if there is no
revision.
The IF statement looks like this: =IF(B1>=0,B1,A1).
If the revision is from $50,000 to $0.00, for example, or
if there is no revision and that cell is blank, the
formula returns the same results.
Can anyone provide any direction on this?