IF versus IFS function in Excel 2016

Рет қаралды 18,679

6 жыл бұрын

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 -
www.udemy.com/master-business...
_________________
SUBSCRIBE NOW!
/ @excelrush
Click this link to learn more awesome functions in Excel
• Learn Excel's Tricks
Click this link to learn how to manage your personal finance using Excel
• Personal Finance
Logo Music - "Blonde" by Nctrnm

Пікірлер: 14

@rizalfatoni4075 2 жыл бұрын

The video is short yet clearly explains the difference. Thank you very much!

@nainiharicherry1392 4 жыл бұрын

Explained simple and awesome man

@angelclarke1942 2 жыл бұрын

I have office 2016 plus but i notice i dont see the IFS function

@SenthilKumar-hi4oc 2 жыл бұрын

super . thank you

@FrancisDCosta 5 жыл бұрын

How can I embed a (price) calculator in Excel on my website for customers to check by inputting data from drop down list I can provide.

@xslmnl05 16 күн бұрын

When I write formula in fx there is no error,but whenever i write it in cell, it goes wrong

@theabhishekshaww Жыл бұрын

what is the meaning of S in Sumifs. I mean I want to know the fullform of S is used after Sumif(s). I hope you got it. Please help I am unable to get this answer.

@Excelrush Жыл бұрын

Plural of Sumif

@theabhishekshaww Жыл бұрын

@@Excelrush Ok I got it. Is there any fullform of this S?