How to Excel IF Formula | Simple to Advanced | Multiple Criteria, Nested IF, AND, OR functions...

In this Excel tutorial video, we gonna learn how to use one of the most important Excel functions. The IF Function in Excel.

I'm gonna talk about many different ways to use if function.

When to use the Excel IF function, When to use a Nested IF formula, Excel IF THEN formula, Excel IF formula with AND condition, Nested Excel IF formula, Excel IF formula with OR condition, Excel IF formula with threshold, Excel IF formula with symbols for result, Wrap-Up of different uses of Excel IF function.

First, we'll see how to use the simple version of the IF function. Then, I gonna cover a more complex use, that is, using the if formula with greater than or less than check marks.

IF Formula together with AND logical test to decide outcome if more than one condition is met.

Nested IF formula (an IF inside another IF) to check for multiple criteria.

IF formula with OR function (to check if "either" condition is met and then decide the outcome).

We also take a look at using formulas (other calculations) inside the IF function and finally, how to use symbols as the result of the IF formula.

If your IF formula isn't working, maybe it's a common mistakes, you can adjust the "else" argument.

That's the last argument inside the IF function.

Make sure you haven't forgotten to specify what should happen "if" the condition isn't met.

In case you have more than one condition, here's the place to add the second "if" statement.

An IF formula inside another IF formula is called a nested if function.

#JopaExcel #Dashboard #HowtoExcel