Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, IFS functions)

Описание: Learn how to use Excel's IF Function in your reports.

IF is the most used logical function in Excel. For multiple criteria, we can use Nested IF or IFS(2019 & above). This video explains IF, IFS and nested IF with multiple examples.

Chapters
0:00 When to use the Excel IF function
0:37 Excel IF function
4:00 Nested Excel IF formula
9:20 Nested IF complex Example
12:54 IFS function for 2019 & above users

Watch this video to know how to use Office 365 for free.
   • How to Use Microsoft Office 365 for Free  

Please like my video and subscribe to my channel for more such videos. Please share your feedback/queries in the comment section below.

We cover a few examples in this tutorial including:
1. Simple IF function (also with greater than or less than checks).
2. IF Formula together with AND logical test to decide outcome if more than one condition is met.
3. Nested IF formula (an IF inside another IF) to check for multiple criteria.
4. IF formula with OR function (to check if "either" condition is met and then decide the outcome).
5. We also take a look at using formulas (other calculations) inside the IF function and finally:
6. How to use symbols as the result of the IF formula

Your IF formula isn't working? One of the main mistakes is 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.

learn excel in hindi,logical functions in excel,if formula,if formula in hindi,nested if function excel,multiple if function excel,if function,excel if function,excel if and function,excel if function in hindi,if logical function,excel 2010,excel 2016,office 365,functions,formulas,excel if formula,ifs formula,and,if,excel formulas and functions,excel online course,excel formulas

#msexcel #IF #IFS #nestedIF