How to use the if statement

[Anonymous]

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

[giakoum · Accepted solution]

if(exprssion 1 = 2.7, 'Normal', if(expression 1 = 1.7, "Good", if(expression 1 = 3.7, "Bad", "NA")))

[alexandros17]

Here it is

If(value < 2, 'Good',

     if(value >=2 and value <3, 'Normal' ,' Bad')

)

Hope it helps

[its_anandrjs]

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

[PrashantSangle]

Hi,

Try this,

If(exprssion_1< 2, 'Good', if( exprssion_1<3, 'Normal' ,' Bad')) as Result

Regards,

PS