Nested IF

Copper Contributor

I'm sure I'm missing something obvious here, but why am I getting only C, D and E's here and doesn't it work for A, B and F?

 

IF(EE3<=100;”A”;IF(EE3<=200;”B”;IF(EE3<=300;"C";IF(EE3<=400;"D";IF(EE3<=500;"E";”F”)))))

 

3 Replies

@hv_onesto 

In the formula C, D and E are in straight quotes as it shall be, other letters are in curved quotes which is wrong.

In general it works

image.png

That's it!
Thanks a lot.

@hv_onesto , you are welcome