If Formula with 8 Examples
If Formula in Excel with 8 Examples. The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. In its simplest form, the IF function says:
IF(Something is True, then do something, otherwise do something else)
So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
In this video you will learn 8 ways of using the IF formula in Excel with examples.
1.Use IF Formula in Excel for Beginners
2.Use IF Formula in Excel with 3 conditions
3.Use IF Formula in Excel to get a text based answer like “You are Awesome” if a condition is met.
4.Use IF Formula in Excel where in 2 formulas are being used as Conditions
5.Use IF Formula in Excel wherein you put a formula in the IF Formula
6.Use IF Formula in Excel wherein you put 2 formulas in the IF formula
7.Use Multiple IF Commands in a formula in Excel
8.Use IF Formula in combination with AND, OR formula in Excel
To watch more videos and download the files visit http://www.myelesson.org
To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788