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.

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

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.
>