Forum Discussion
IF statement with multiple conditions
Hi, I need help with syntax to construct this statement: If [date]>0, AND measure1="one" or measure1="two" or measure1="three", then "no", else "yes". In other words, if the 1st condition is...
That worked perfectly! Thank you very much! As I suspected, my statement was needlessly complicated.
Hello Anonymous . Give this a try.
IF ( [Date] > 0 && ( [Measure1] = "One" || [Measure1] = "Two" || [Measure1] = "Three"), "no", "yes")
&& = AND
|| = OR
That worked perfectly! Thank you very much! As I suspected, my statement was needlessly complicated.