IF statement for a column
 

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 I
have done correctly and the cell references change the wale they are
suppose to, BUT instead of being blank the way they should be, they
come up and say #VALUE. Now when I enter numbers in the reference
columns the addition works correctly, but why is the #VALUE coming up?

Thanks, Chester


--
cpopham
------------------------------------------------------------------------
cpopham's Profile: http://www.excelforum.com/member.php...o&userid=20012
View this thread: http://www.excelforum.com/showthread...hreadid=489834

IF statement for a column
 

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 =""

--
Kind regards,

Niek Otten

"cpopham" wrote in
message ...

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 I
have done correctly and the cell references change the wale they are
suppose to, BUT instead of being blank the way they should be, they
come up and say #VALUE. Now when I enter numbers in the reference
columns the addition works correctly, but why is the #VALUE coming up?

Thanks, Chester


--
cpopham
------------------------------------------------------------------------
cpopham's Profile:
http://www.excelforum.com/member.php...o&userid=20012
View this thread: http://www.excelforum.com/showthread...hreadid=489834

IF statement for a column
 

Try...

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

Hope this helps!

In article ,
cpopham wrote:

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 I
have done correctly and the cell references change the wale they are
suppose to, BUT instead of being blank the way they should be, they
come up and say #VALUE. Now when I enter numbers in the reference
columns the addition works correctly, but why is the #VALUE coming up?

Thanks, Chester