Pinterest Pixel

IF Function: Introduction

What does it do? It returns a value that you set if a condition is met, and... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

IF Function: Introduction | MyExcelOnline IF Function: Introduction | MyExcelOnline

What does it do?

It returns a value that you set if a condition is met, and a value if it is not met

Formula breakdown:

=IF(Logical Test,Value if True,Value if False)

What it means:

=IF(The condition to be checked, Value to be shown if the condition is met, Value to be shown if condition is not met)


The IF function is probably one of the most used Excel functions because it is easy to understand and very flexible when you apply it to real life situations.

Here I will show you a couple of ways that you can use the IF function to get you up and going.

Download excel workbookIf.xlsx

We want to show a Bonus value if sales are bigger than $3000, and No Bonus is shown if this condition is not met. Afterwards let’s try computing the 10% bonus!

STEP 1: We need to enter the IF function in a blank cell:
=IF(
IF Function: Introduction

 

See also  How to use the ISERROR function in Excel

STEP 2: The IF arguments:

Logical_test

What is your condition?

Sales Rep has sold more than 3000 dollars.
=IF(D15>3000,
IF Function: Introduction

Value_if_true

What value should be displayed if the condition is true?

We want “Bonus” to be displayed
=IF(D15>3000, "Bonus",
IF Function: Introduction

Value_if_false

What value should be displayed if the condition is false?

We want “No Bonus” to be displayed
=IF(D15>3000, "Bonus", "No Bonus")
IF Function: Introduction

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

IF Function: Introduction

STEP 3: Let us now aim to give the 10% Bonus!

The IF arguments:

Logical_test

What is your condition?

Sales Rep has sold more than 3000 dollars.
=IF(D15>3000,
IF Function: Introduction

 

Value_if_true

What value should be displayed if the condition is true?

We want give a 10% bonus based on sales
=IF(D15>3000, D15*10%,
IF Function: Introduction

Value_if_false

What value should be displayed if the condition is false?

See also  MONTH Formula in Excel

Then no bonus amount should be given, type in 0
=IF(D15>3000, D15*10%, 0)
IF Function: Introduction

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

IF Function: Introduction

You now have all of results!

 

 

If you like this Excel tip, please share it
IF Function: Introduction | MyExcelOnline IF Function: Introduction | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...