From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using IF

Using IF - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

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 separated with commas…

Contents