IS Blank help needed

rvd48

Registered User.
Local time
Today, 19:44
Joined
Feb 2, 2004
Messages
123
hi, i have attached a excel worksheet for calrity of my formula problem.

When cells B1 and B2 are empty i want the formula (cell D5) to return a True answer, similarly when cells B1 and B2 have data in them i also want it to return a True answer. otherwise return a False answer.

=IF(AND(ISBLANK(B1),ISBLANK(B2)),"true","False")

thats how far i've got with the formula. any help would be very appreciated.
btw this formula will feed into another.

thanks
 

Attachments

This works,

=IF(AND(ISBLANK(B1),ISBLANK(B2)),"TRUE",IF(OR(ISBLANK(B1),ISBLANK(B2)),"FALSE","TRUE"))
 

Users who are viewing this thread

Back
Top Bottom