Issue with representing a 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.

One way:

=IF(ISBLANK(A1),"no","yes")

In article <AC18A7E1-CFB7-4EFA-ACB6-AAF6BB572AF5@microsoft.com>,
Van <Van@discussions.microsoft.com> 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.