How to Use IF in Formulas in Excel 2010


show more Using IF provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Using IF

Sometimes you want the value that's displayed in a cell to depend on a condition that's happening somewhere else. This is where you use a conditional statement and it's a statement that you can test. The way it works is that you output one result if that statement is true, and you output a different result if that statement is false. To do this, you use the IF function. The IF function gets three arguments. The first argument is a statement that you test. For example, you might say the content of Cell C6 > 500.

But when you make that statement or when you have that condition, well, there are two possibilities. Either it's true or it's false. So the IF function will output one value if that statement is true and it'll output another value if that statement is false. So, the general syntax of the IF function is say =IF and then you make the statement. Then you have the value of true and then you have the value of false. You notice that these three arguments are separa...

Using IF
Video duration: 4m 49s 6h 21m Beginner

Viewers:

Using IF provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...