Correction: It's not missing a {. But it didn't work
either. It's entering "TEXT" only when cell3
reads "Cincinnatti"...
OK, it seems to be OK here. But I think I have have been following your
spec. exactly as stated, i.e.you should see TRUE if one or both of the
following is true:
cell3 is "Cincinatti"
cell1 is not null and cell2 is not null
and blankotherwise
If what you meant is
"if either cell1is not null,or cell2 is not null, or cell3 is Cincinatti,
print TRUE"
you could try
{ IF { =or(or({ COMPARE "{ cell1 }" <> "" },
{ COMPARE "{ cell2 }" <> "" }),
{ COMPARE "{ cell3 }" = "Cincinatti" }) } = 1 "TEXT" "" }

Signature
Peter Jamieson
> Correction: It's not missing a {. But it didn't work
> either. It's entering "TEXT" only when cell3
[quoted text clipped - 25 lines]
> >>
> >.