IF statement for a column

C

cpopham

I am using the following if statement:


Code
-------------------

=IF(AND(ISBLANK(E5),ISBLANK(F5)),"",E5+F5)

-------------------


I want to paste that formula for the entire column, which I think
have done correctly and the cell references change the wale they ar
suppose to, BUT instead of being blank the way they should be, the
come up and say #VALUE. Now when I enter numbers in the referenc
columns the addition works correctly, but why is the #VALUE coming up?

Thanks, Cheste
 
N

Niek Otten

ISBLANK returns TRUE if there is nothing in the cell. If there is a formula
which returns blank, the cell is not blank and ISBLANK returns FALSE. The
same for a space..
Maybe you should use =""
 
Top