SOLVED

How can I nest functions using equation editor?

%3CLINGO-SUB%20id%3D%22lingo-sub-2444916%22%20slang%3D%22en-US%22%3EHow%20can%20I%20nest%20functions%20using%20equation%20editor%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2444916%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20use%20nested%20%3CEM%3EIF%20%3C%2FEM%3Efunctions%20to%20show%20the%20level%20of%20the%20employees.%20However%2C%20I%20don't%20know%20how%20to%20edit%20the%20%3CEM%3ENESTED%20%3C%2FEM%3Efunctions%20in%20the%20equation%20editor.%3C%2FP%3E%3CP%3EMore%20accurately%2C%20I%20want%20to%20edit%20nest%20%3CEM%3EIF%20%3C%2FEM%3Efunction%20in%20the%20''Value_if_false%22%20input%20box.%20However%2C%20I%20don't%20want%20to%20directly%20type%20%3CEM%3E%3Dif(...)%2C%3C%2FEM%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22The%20problem%20I%20am%20facing.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F288468i9F4FF1226712BEBB%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22The%20problem%20I%20am%20facing.png%22%20alt%3D%22The%20problem%20I%20am%20facing.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20hope%20that%20Excel%20will%20pop%20up%20a%20new%26nbsp%3Bequation%20editor%20window%20so%20I%20can%20input%20the%20parameter%20of%20the%20%3CEM%3Enested%20IF%26nbsp%3B%3C%2FEM%3Efunction.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22What%20I%20want%20to%20....png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F288469i7E414B4384775FF2%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22What%20I%20want%20to%20....png%22%20alt%3D%22What%20I%20want%20to%20....png%22%20%2F%3E%3C%2FSPAN%3EEagerly%20waiting%20for%20replies.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2444916%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2444935%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20nest%20functions%20using%20equation%20editor%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2444935%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EDevice%20and%20OS%20platform%3A%3C%2FSTRONG%3E%20Mac%2FmacOS%20Big%20Sur%2011.2.3%3C%2FP%3E%3CP%3E%3CSTRONG%3EExcel%20product%20name%20and%20version%20number%3A%20%3C%2FSTRONG%3E16.49%20with%20a%20Microsoft%20365%20subscription%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2444978%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20nest%20functions%20using%20equation%20editor%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2444978%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F349444%22%20target%3D%22_blank%22%3E%40YYAppleFan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfraid%20that's%20the%20only%20way.%20However%2C%20you%20may%20use%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DLOOKUP(D2%2C%20%7B0%2C60%2C100%2C150%2C200%7D%2C%20%7B0%2C10000%2C15000%2C25000%2C50000%7D)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Einstead%20if%20nested%20IF()%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2446841%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20nest%20functions%20using%20equation%20editor%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2446841%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThanks%20for%20your%20help.%20Your%20method%20is%20of%20high%20efficiency.%3C%2FP%3E%3CP%3ENow%20I%20found%20%3CEM%3EIFS%3C%2FEM%3E%20function%20is%20much%20easier%20to%20use%20than%20the%20nested%20%3CEM%3EIF%3C%2FEM%3E%20functions.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I want to use nested IF functions to show the level of the employees. However, I don't know how to edit the NESTED functions in the equation editor.

More accurately, I want to edit nest IF function in the ''Value_if_false" input box. However, I don't want to directly type =if(...),The problem I am facing.png

I hope that Excel will pop up a new equation editor window so I can input the parameter of the nested IF function.

What I want to ....pngEagerly waiting for replies.

4 Replies

Device and OS platform: Mac/macOS Big Sur 11.2.3

Excel product name and version number: 16.49 with a Microsoft 365 subscription

 

best response confirmed by YYAppleFan (Occasional Contributor)
Solution

@YYAppleFan 

Afraid that's the only way. However, you may use

=LOOKUP(D2, {0,60,100,150,200}, {0,10000,15000,25000,50000})

instead if nested IF()

@Sergei Baklan Thanks for your help. Your method is of high efficiency.

Now I found IFS function is much easier to use than the nested IF functions.

@YYAppleFan 

In general yes. Two simple rules

- IFS() stops working on first condition met and ignores the rest;

- if no one condition met it returns #N/A error, thus it's always better to add TRUE condition at the end to return more informative result, e.g. =IFS(0,5, TRUE, "nothing met")