IF statement for a column

[cpopham]

I am using the following if statement:

Please Login or Register  to view this content.

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

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

--
Kind regards,

Niek Otten

"cpopham" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Domenic]

Try...

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

Hope this helps!

In article <[email protected]>,
cpopham <[email protected]> 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