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

P

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

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

Patricia

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

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