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 WORKBOOK

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 formula

 

STEP 2: The IF arguments:

Logical_test

What is your condition?

Sales Rep has sold more than 3000 dollars.

=IF(D15>3000,

IF formula

Value_if_true

What value should be displayed if the condition is true?

We want “Bonus” to be displayed

=IF(D15>3000, “Bonus”,

IF formula

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 formula

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

IF formula

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 formula

 

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 formula

Value_if_false

What value should be displayed if the condition is false?

Then no bonus amount should be given, type in 0

=IF(D15>3000, D15*10%, 0)

IF formula

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

IF formula

You now have all of results!

 

How to Use the If Formula in Excel

IF_Intro

HELPFUL RESOURCE:

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

SUMIF Function: One Criteria & Sum Range The SUMIF function can also be used to apply the criteria to one range and sum the corresponding values in a different range. So if you have a list of Sales Reps in one list and their Sales in another list and want to Sum the sales of only one of the Sales Reps, then the SUMIF...
SUMIF Function: Introduction   What does it do? Sums the values in a range that meet a criteria that you specify Formula breakdown: =SUMIF(Range or Cells, Criteria, ) What it means: =SUMIF(Evaluate this Range/Cells, With this Criteria, ) The SUMIF function is used widely amon...
MATCH Function Intro   What does it do? It returns the position of an item in a range Formula breakdown: =MATCH(lookup_value, lookup_array, ) What it means: =MATCH(lookup this value, from this list or range of cells, return me the Exact Match) The MATCH function in Ex...
Excel Subtotal Function – Filtered or Visible Valu... What does it do? It returns a Subtotal in a list or database Formula breakdown: =SUBTOTAL(function_num, ref1) What it means: =SUBTOTAL(function number 1-11 includes manually-hidden rows & 101-111 excludes them, your list or range of data) ***Go to the bottom...