Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2004

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Patricia - 30 Jul 2004 17:24 GMT
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 - 30 Jul 2004 20:18 GMT
How about

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

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

Peter Jamieson

> 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.
Patricia - 03 Aug 2004 20:48 GMT
The formula is missing a { somewhere...

>-----Original Message-----
>How about
[quoted text clipped - 10 lines]
>
>.
Patricia - 03 Aug 2004 21:02 GMT
Correction: It's not missing a {. But it didn't work
either. It's entering "TEXT" only when cell3
reads "Cincinnatti"...

>-----Original Message-----
>The formula is missing a { somewhere...
[quoted text clipped - 21 lines]
>>
>.
Peter Jamieson - 03 Aug 2004 21:58 GMT
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]
> >>
> >.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.