Correct syntax for or() functions within formula fields

[Jason]

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]

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]

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!