May 04 2020 02:27 AM
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”)))))
May 04 2020 02:34 AM
@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
May 04 2020 02:46 AM
May 04 2020 03:07 AM
@hv_onesto , you are welcome