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

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.

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

Maybe...

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



Van wrote:

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.

--

Dave Peterson

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

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

"Van" wrote:

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.