answersLogoWhite

0

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.

User Avatar

Wiki User

14y ago

Still curious? Ask our experts.

Chat with our AI personalities

ReneRene
Change my mind. I dare you.
Chat with Rene
SteveSteve
Knowledge is a journey, you know? We'll get there.
Chat with Steve
TaigaTaiga
Every great hero faces trials, and you—yes, YOU—are no exception!
Chat with Taiga

Add your answer:

Earn +20 pts
Q: What is the purpose of the if function in word excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp