Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to use the "If" statement with 3 possibilities in one expression?
Result expression 1 is a value (f.e. "2.7")
I've made 3 categories
"Good" if value < 2
"Normal" if value >=2 and ❤️
"Bad" if value >=3
How to make a new expression which shows me the value
"Normal" when exprssion 1 = 2.7
or which shows me
"Good" if expression 1 = 1.7
or shows me
"Bad" if expression 1 = 3.7
if(exprssion 1 = 2.7, 'Normal', if(expression 1 = 1.7, "Good", if(expression 1 = 3.7, "Bad", "NA")))
if(exprssion 1 = 2.7, 'Normal', if(expression 1 = 1.7, "Good", if(expression 1 = 3.7, "Bad", "NA")))
Here it is
If(value < 2, 'Good',
if(value >=2 and value <3, 'Normal' ,' Bad')
)
Hope it helps
Write like below
If(exprssion_1 = 2.7, 'Normal',
If(exprssion_1 = 1.7, 'Good',
If(exprssion_1 = 3.7,'Bad'))) as Result_expression
Hope this helps
Thanks & Regards
Hi,
Try this,
If(exprssion_1< 2, 'Good', if( exprssion_1<3, 'Normal' ,' Bad')) as Result
Regards,
PS