Using or condition in if statement

[#1]

Hi All,

I wish to use an or condition in the if statement like:

if Value=3 or Value=4 or Value=5 then 'Y'

else 'N'.

How do I convert it into an if statement?

Thanks,

Asma

[#2 · Accepted solution]

Hi Asma,

' If ' Function has 3 Parts

1- Conditon,

2- IF Condition Holds True

4. If Condition doesn't hold Trye / ELSE

Use can try in your case; ( Value considered as a Field name)

IF(Value='3' or Value='4' or Value='5', 'Y'', 'N')

Hope it helps.

Cheers !

[#3]

I tried this. But it is not working

[#4]

I had done a small syntax error. It works now. Thanks