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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding up to a multiple of 12 1
If statement to compare time cell to a time 9
Copy condtional formatting in XL2007 for Windows 1
Excel IF statement problem 3
simple If but not for me 3
Multiple IF Statement 2
Problem with Copying a Simple formula 3
IF Function -- Return Null Value Help 2

Top