if 1 and 2 are not null OR 3 reads "abc"

[Patricia]

I found a similar case to this, but I have one less cell
than that. Can you help me?

IF CELL 1 AND CELL 2 ARE NOT NULL, OR CELL 3 EQUALS
Cincinnatti, ENTER "TEXT". Otherwise leave blank.

 

[Peter Jamieson]

How about

{ IF { =or(and({ COMPARE "{ cell1 }" <> "" },{ COMPARE "{ cell2 }" <>
"" }),{ COMPARE "{ cell3 }" = "Cincinatti" }) } = 1 "TEXT" "" }

(or { MERGEFIELD cell1 } etc.if cell1 etc.are merge fields.

 

[Patricia]

The formula is missing a { somewhere...

-----Original Message-----
How about

{ IF { =or(and({ COMPARE "{ cell1 }" <> "" },{

 

[Patricia]

Correction: It's not missing a {. But it didn't work
either. It's entering "TEXT" only when cell3
reads "Cincinnatti"...

 

[Peter Jamieson]

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" "" }