test on empty cell

[Leif Hygrell]

Hi,
In as sheet a certain calculation is to take place and it is not allowed to
have blanks.
I want to make a formula like =IF(AND(A1<>BLANK,B1<>BLANK),C1+D1,"False")
Is there a way to do this?

Regards

Leif

 

[Frank Kabel]

Hi
try
=IF(AND(ISBLANK(A1),ISBLANK(B1)),"False",C1+D1)

 

[Jason Morin]

Use a zero text string in place of BLANK.

....AND(A1<>"",B1<>"")...

HTH
Jason
Atlanta, GA

 

[Leif]

Vielen Dank, Fraank

Hi
try
=IF(AND(ISBLANK(A1),ISBLANK(B1)),"False",C1+D1)