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 / June 2004

Tip: Looking for answers? Try searching our database.

Correct syntax for or() functions within formula fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jason - 09 Jun 2004 18:17 GMT
What is the proper syntax for using the or() function within a formula field?  I want to use a simple if-then-else formula using the or function with a merge field result.  But, I can't figure out the proper syntax for th or function.  For example, if the result of a mergefield equals one of several true reponses, then true statement else fale statement.  Any help?  Thank you!
Greg - 09 Jun 2004 19:31 GMT
Jason,

The Or function will evaluate X and Y and return True "1"
if either or both X and Y is true.  Let's say you have
Mergefield "A1."

{=or({=(A1=10)},{=(A1=25)})} will return "1" if A1 = 10 OR
if A1 = 25.  Otherwise the field returns False "0"

You mention that your mergefield may have "several" true
responses.  A nested IF field may suit your needs better.

Example:
{IF A1 = 10"True"{IF A1 = 25"True"{IF A1 =
50"True""False"}}}

Here the result is "True" IF A1 is 10,25 or 50.  Otherwise
the result is "False"
>-----Original Message-----
>What is the proper syntax for using the or() function within a formula field?  I want to use a simple if-then-
else formula using the or function with a merge field
result.  But, I can't figure out the proper syntax for th
or function.  For example, if the result of a mergefield
equals one of several true reponses, then true statement
else fale statement.  Any help?  Thank you!
>.
macropod - 12 Jun 2004 23:52 GMT
Hi Jason,

For detailed discussion on the use of IF, AND and OR statements in fields,
see:
http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=365442
(url all one line)

Cheers

> What is the proper syntax for using the or() function within a formula field?  I want to use a simple if-then-else formula using the or function
with a merge field result.  But, I can't figure out the proper syntax for th
or function.  For example, if the result of a mergefield equals one of
several true reponses, then true statement else fale statement.  Any help?
Thank you!
 
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.