formula Fuction IF

[supiansyarif]

formula fungsi IF
Dear all ,
I have data
0 - 32.5 =A
32.5 - 60 =B
60 - 100 =C
>100 = D
why formula IF


thanks, Supian

 

[AliGW]

Try this:

=LOOKUP(A1,{0,32.5,60,100},{"A","B","C","D"})

 

[supiansyarif]

Try this:

=LOOKUP(A1,{0,32.5,60,100},{"A","B","C","D"})

Thanks,AliGW

 

[AliGW]

You're welcome!