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