Nested IF

%3CLINGO-SUB%20id%3D%22lingo-sub-1357240%22%20slang%3D%22en-US%22%3ENested%20IF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1357240%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20sure%20I'm%20missing%20something%20obvious%20here%2C%20but%20why%20am%20I%20getting%20only%20C%2C%20D%20and%20E's%20here%20and%20doesn't%20it%20work%20for%20A%2C%20B%20and%20F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3EIF(EE3%26lt%3B%3D100%3B%E2%80%9DA%E2%80%9D%3BIF(EE3%26lt%3B%3D200%3B%E2%80%9DB%E2%80%9D%3BIF(EE3%26lt%3B%3D300%3B%22C%22%3BIF(EE3%26lt%3B%3D400%3B%22D%22%3BIF(EE3%26lt%3B%3D500%3B%22E%22%3B%E2%80%9DF%E2%80%9D)))))%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1357240%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1357257%22%20slang%3D%22en-US%22%3ERe%3A%20Nested%20IF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1357257%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F562931%22%20target%3D%22_blank%22%3E%40hv_onesto%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20the%20formula%20C%2C%20D%20and%20E%20are%20in%20straight%20quotes%20as%20it%20shall%20be%2C%20other%20letters%20are%20in%20curved%20quotes%20which%20is%20wrong.%3C%2FP%3E%0A%3CP%3EIn%20general%20it%20works%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20545px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F188662i3F166F3174737CB5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1357283%22%20slang%3D%22en-US%22%3ERe%3A%20Nested%20IF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1357283%22%20slang%3D%22en-US%22%3EThat's%20it!%3CBR%20%2F%3EThanks%20a%20lot.%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

@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

Highlighted
That's it!
Thanks a lot.
Highlighted

@hv_onesto , you are welcome