Pinterest Pixel

IF Function Combined With The AND Function

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 Combined With The AND Function | MyExcelOnline IF Function Combined With The AND Function | 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(AND(Logical Test),Value if True,Value if False)

What it means:

=IF((Sales are bigger than $3000 & in the North region),“Bonus”,“No Bonus”)


When combining (or nesting) the AND function with the IF function, it allows you to add more than one condition to your formula, something that is not possible with the IF function by itself.

So you can show the results of Sales Reps that have made more than $3,000 of sales AND who are part of the North region, as explained below…

Download excel workbookIf_And.xlsx

We want to show a Bonus value if sales are bigger than $3000 and comes from the North region, and No Bonus is shown if this condition is not met.

STEP 1: We need to enter the IF function in a blank cell:
=IF(
IF Function Combined With The AND Function

 

STEP 2: The IF arguments:

Logical_test

What is your condition?

Sales Rep has sold more than 3000 dollars and comes from the North Region. Let us use the AND function to accomplish this.
=IF(AND(D15>3000, C15="North"),
IF Function Combined With The AND Function

Value_if_true

What value should be displayed if the condition is true?

We want “Bonus” to be displayed
=IF(AND(D15>3000, C15="North"), "Bonus",
IF Function Combined With The AND Function

Value_if_false

What value should be displayed if the condition is not met?

We want “No Bonus” to be displayed
=IF(AND(D15>3000, C15="North"), "Bonus", "No Bonus")
IF Function Combined With The AND Function

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

IF Function Combined With The AND Function

You now have all of results!

IF Function Combined With The AND Function

 

If you like this Excel tip, please share it
IF Function Combined With The AND Function | MyExcelOnline IF Function Combined With The AND Function | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  The Ultimate Guide on How to Sum a Column in Excel

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...