You must have used IF function in Excel and also used nested IF, which is IF under IF. If you have to apply 5 conditional statements with different value if true's, that is different outputs, you will need to put 5 IF under IF statements.
Excel 2016 has a new function which is =IFS which simplifies the way we write a nested IF formula.
--------------------------
** After this video, to learn in-depth about Pivot tables and charts, Enroll for an Online course conducted by me on Master Business Reporting with Pivot tables and charts in Excel
Also, as you are a special Viewer/ Subscriber,
we would like to give out a special discount just for you,
so click here -
[ Ссылка ]
_________________
SUBSCRIBE NOW!
[ Ссылка ]
Click this link to learn more awesome functions in Excel
[ Ссылка ]
Click this link to learn how to manage your personal finance using Excel
[ Ссылка ]
Logo Music - "Blonde" by Nctrnm
![](https://s2.save4k.ru/pic/dz1fLUhzz5c/maxresdefault.jpg)