How to use the If function in excel with three criteria, in other words, how to use if function with several different conditions.

If you already know how to make if function in excel, make the If function with many criteria is gonna be easier for you.

Because you already know the logic process behind it, and you know how this Excel formula works.

To make the If function works with more than one or two criteria, we need to create a nested function or nested formula in excel.

Nested IF functions, meaning one IF function inside of another, allows you to test multiple criteria and increases the number of possible outcomes. In short, it means you can do a if function within a if function.

If function is one the most used Excel functions.

I hope this practical Excel example and real world exercise can help you.

#JopaExcel #Dashboard #HowtoExcel