Forum Discussion
How can I nest functions using equation editor?
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 ...
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()
Device and OS platform: Mac/macOS Big Sur 11.2.3
Excel product name and version number: 16.49 with a Microsoft 365 subscription
