How do you determine if a field is blank in a logical expression.

V

Van

I am trying to utilize a logical expression to yield this result:

If the field is blank return a value of no, if there is anything at all in
the field return the value of yes. Basically, I am pulling data out of a
database for a checklist. The user only cares if there is or is not data in
that field. So I am trying to convert the data to a YES and a blank field to
a NO. I would greatly appreciate any assistance. Thanks.
 
D

Dave Peterson

Maybe...

=if(a1="","no","yes")


I am trying to utilize a logical expression to yield this result:

If the field is blank return a value of no, if there is anything at all in
the field return the value of yes. Basically, I am pulling data out of a
database for a checklist. The user only cares if there is or is not data in
that field. So I am trying to convert the data to a YES and a blank field to
a NO. I would greatly appreciate any assistance. Thanks.
Click to expand...
 
J

Jim May

If cell A1 were totally blank, then in cell B1 the formula =ISBLANK(A1)
would yeild TRUE -- If there were something in A1 B1 would yeild FALSE.
HTH
 
Top