IF-then-else with OR

[Oona8]

I want to be able to see "YES" when "Field1" = "Value1" or "Value2" or "Value"3 etc.. and "NO" when field1 = "Value4" or "Value5"
I suppose it's an IF THEN ELSE formula but how to deal with the "or" ? I read somewhere that it had to be avoided and to use IN instead. Does anybody know what I should do?

Thanks in advance!

Oona

 

[dgillz]

Try this

if {field1} in ["value1","value2","value3"] then "yes" else
if {field1} in ["value4",value5"] then "no" else "maybe"

The "maybe" is there just in case a field failed the first 2 tests. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[mbarron]

If field 1 can be something other than value1 thru value5 use:

if {field1} in ["value1","value2","value3"] then "Yes" else
if {field1} in ["value4","value5"] then "No" else
""

If it can be only one of the 5 values you can use:

if {field1} in ["value1","value2","value3"] then "Yes" else
"No"

Mike

 

[Oona8]

thanks a lot it works perfectly now!

Cheers