How to use the IFS function in Excel

Learn how to use the IFS function in Microsoft Excel. This tutorial demonstrates how to use Excel IFS with an easy to follow example. This is a new Excel function that is available in Office 365 and Excel 2019 and replaces the old method of nesting multiple IF functions in a formula. You can enter up to 127 conditions. We also show you a workaround that allows you to enter an ELSE condition in the IFS function.

IFS Function (and sample data):

Excel Functions/Formulas:

Excel Tutorials:

Don't forget to subscribe to our channel for more great Excel tutorials!

or follow us on:

[vicvic]

Thank you. Explained in a very clear way with useful hint about using TRUE inside this formula. :)

[darya]

Thank you!! This helped me with my problem.

[MiiShareDS]

Thanks you for this video, it's so good for me because I am finding for it.

[lorenzocernecca]

Great video. I can confirm that IFS is a new formula available from Excel 2019 and is not found in Excel 2016

[PragyaMishra-nduh]

Thank youso much, very well explained

[jaddfigaro]

What's the difference between IFS() and IF(OR()) ?