What is the purpose of the if function in word excel?

Answer 1

The purpose of the IF function is to put one of two values in a cell based upon a condition.

There are four parts to the IF function.

=IF(Condition, ValueIfTrue, ValueIfFalse)

1. The function name
2. The condition to test (must evaluate to either TRUE or FALSE)
3. The value to put in the cell if the condition evaluates to TRUE
4. The value to put in the cell if the condition evaluates to FALSE

Note that the value returned can be either text, a number, a formula, or a reference to another cell or cells. Text must be in quotes.

In plain English the function says, If the condition is True, put the value of ValueIfTrue in the cell, otherwise put the value of ValueIfFalse in the cell.

Let's look at an easy-to-understand example.

Column A contains student names. Column B contains student grades. In column C we will add a formula that will tell if the student passed or failed.

Here's the formula we would use: =IF(B2<50,"Failed", "Passed")

If the grade in cell B2 is less than 50, put the word Failed in cell C2, otherwise put the word Passed in cell C2.