Home »  Software »  Office Suite Software

How Do I Use the “IF” Function in Microsoft® Excel®

May 08, 2013  |  Difficulty: Easy

how to use the “IF” function in Microsoft® Excel®

There are many functions in Microsoft® Excel®, from basic mathematics to more extended logical or text functions. One very handy function is “IF”, which is used in logical formulas groups. This is one of the basic functions. It is usually the first one taught when you start learning any programming language.

This function is used in formulas to test whether a certain condition is true or false. Below is an example of using the “IF” function in Microsoft® Excel®.

Using the “IF” function in Excel® (example):

Imagine you need to know if the sum of two cells is a higher number than 100. If yes, the “IF” function writes “YES” in a designated cell. If not, the function writes “NO” in the same cell.

  1. Launch Microsoft® Excel® 2010 and switch to the “Formulas” tab.
  2. Select the cell we want to see the result in (e.g. A3)
  3. In the ribbon go “Logical > IF“.
  4. Into the “Logical_test“ field, write “(A1+A2)>100“.
    note: A1“ and A2“ are names of cells.
  5. Into “Value_if_true” field write “YES”.
  6. Into “Value_if_false” field write “NO”.
  7. Click on the “OK” button.

Now you can test if it works, write two numbers to each cell we want to check for count (in our case “A1” and “A2” cells).

Software:

Most Popular Articles:

What Is the Best Backup Software for Me

Internet Security Solutions Detect Legitimate Soft

How Do I Block Internet Intruders from Spying

How Do I Choose a Data Backup Software

How Do I Install a FREE Spyware and Adware Blocker

Related Articles:

add background graphics to Excel

How Do I Change the Worksheet Background in Excel®

import the data from a “*.mdb” file into the Excel®

How Do I Import Microsoft Access® Data into Excel®

data filtering option to the column in Excel® 2010

How Do I Set a Filter for Columns in Excel®

how to set the password protection on your document in the Microsoft® Excel®

How Do I Password Protect Excel® Files

how to enhance your next presentation by  creating a pictograph

How Do I Create a Pictograph in Excel® 2010

×
Help Us Spread the Word!

Love us on Facebook to stay updated.

Stay aware and get our best content on health, celebrity, travel, living, career and the technologies that will change the world.