answersLogoWhite

0


Best Answer

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

βˆ™ 13y ago
This answer is:
User Avatar

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
Related questions

How can you show the MS Excel ruler bar?

There is no ruler bar in MS Excel. That is an MS Word function.


What are the primary functions of Word Excel and Powerpoint?

The primary function of Word is to create documents, Power point is to create slides. Excel can be used for calculations and tables.


What is the step function of Microsoft Excel?

There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.


Is the zoom function in Excel same as Word?

They allow you to zoom in or out of a worksheet or document, so they are essentially the same.


A formula prewritten by excel is called?

Function


Does the uplookvert function in Excel exist?

There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.


In excel 2013 where are the various function categories stored on the Ribbon?

In Excel Where are the various function categories stored on the Ribbon?


What is the function of percentage in micro-soft Excel?

functions of excel


An If function within an if function in Excel is called what?

A nested if.


How does the trig function ACOS work in Excel?

In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000


How do you make a box plot in Excel?

Excel does not have a native BOXPLOT function, but you can replicate the function by following the instructions in the related links.


What is a function reference in Excel?

A function can reference cells or named ranges in the function.