I wish to use an or condition in the if statement like:
if Value=3 or Value=4 or Value=5 then 'Y'
How do I convert it into an if statement?
' If ' Function has 3 Parts
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.
I tried this. But it is not working
I had done a small syntax error. It works now. Thanks
Retrieving data ...