test on empty cell

Leif Hygrell · Apr 6, 2004

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 · Apr 6, 2004

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

Jason Morin · Apr 6, 2004

Use a zero text string in place of BLANK.

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

HTH
Jason
Atlanta, GA

Leif · Apr 6, 2004

Vielen Dank, Fraank

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

test on empty cell

Leif Hygrell

Frank Kabel

Jason Morin

Leif