IF Function Formulas: 10 Examples!

This video tutorial demonstrates IF function formula and what it can do with the uses of 10 examples. Microsoft Excel IF function is one of the most popular and useful function. It allows to evaluate certain condition and returns one value if TRUE and another value if FALSE.

In simple language, it is an instruction that checks any condition, if the condition is TRUE then it returns predefined value and if FALSE, it returns different predefined value. Also, function only returns one value out of “Value if TRUE” and “Value If FALSE”. Both values cannot be returned at the same time.

We have covered following topics in this tutorial:

1) Find out the status of "Target Achieved"
2) Return result for scores above 75 = "Pass", and below or equal to 75 = "Fail"
3) Calculate reps incentive 3% of Sales Revenue if sales revenue above $40,000 else 1.5%
4) IF function to calculate balance target if not achieved
5) In case last 2 arguments are skipped
6) Find out the "Classes type" whether it is on Weekend or Weekdays
7) Find out the entry type whether cell contains "Text value" or Number value"
8) Calculate % target achieved if target is not blank
9) Criterion for incentive qualification (Achieved target above 100% and Sales Revenue over $18,000)
10) Criterion for incentive qualification (Achieved target above 100% or Sales Revenue over $18,000)


Visit us for daily doses of Excel Tips & Tricks at http://www.exceltip.com/

In case of any simple or complicated "Excel" query, you can ask to our experts for instant solution at http://www.excelforum.com/