How to Use the IF Formula in Excel, Part 2

As amazing as the IF formula is alone, it really comes into its own when used in groups. In our last post, we talked about how to apply discounts to customer quotes based on a set of criteria being met. This week we’ll introduce you to nested IF functions. Nested IF formulas help you calculate more complex discounts, such as multiple rates for multiple tiers of purchasing.

Problem:

IF(the number of units is over 1000, check to see IF(the number is over 5000, give the customer a 6% discount, otherwise give the customer a 3% discount), if the number of units is not over 1000 the customer receives no discount).

Fred Pryor Seminars_Excel if formula part 2 figure 1

=IF(D2>1000, IF(D2>5000, 0.06, 0.03), 0)

  • D2 is the cell that shows the number of units sold.
  • If D2 is greater than 1000, the formula checks to see if D2 is also greater than 5000
  • 0.06 is the discount (6%) received if D2 is greater than 5000, otherwise, 0.03 is the discount (3%) received for D2 that exceeds 1000
  • 0 is the discount received if D2 is not greater than 1000

The IF formula gives you a powerful tool for adding true/false logic to your data that will help speed decision-making (such as discounts!) and save you time on otherwise repetitive tasks.

Local Seminars Related to this Topic:

Microsoft® Excel® Basics

LIVE ONLINE SEMINARS

May. 11

Central Time Zone

May. 13

Eastern Time Zone

May. 18

Central Time Zone

May. 20

Pacific Time Zone

May. 24

Eastern Time Zone

May. 26

Central Time Zone

Jun. 2

Central Time Zone

Jun. 8

Eastern Time Zone

Jun. 10

Central Time Zone

Jun. 14

Central Time Zone

Jun. 16

Pacific Time Zone

Jun. 22

Central Time Zone

Jun. 24

Eastern Time Zone

Jun. 28

Central Time Zone

Jul. 7

Eastern Time Zone

Jul. 8

Central Time Zone

Jul. 12

Central Time Zone

Jul. 14

Pacific Time Zone

Jul. 15

Eastern Time Zone

Jul. 20

Eastern Time Zone

Jul. 20

Pacific Time Zone

Jul. 21

Central Time Zone

Jul. 26

Pacific Time Zone

Jul. 27

Central Time Zone

Aug. 4

Pacific Time Zone

Aug. 5

Central Time Zone

Aug. 9

Central Time Zone

Aug. 10

Eastern Time Zone

Aug. 11

Central Time Zone

Aug. 17

Eastern Time Zone

Aug. 19

Central Time Zone

Aug. 23

Central Time Zone

Aug. 25

Central Time Zone

Aug. 26

Pacific Time Zone

Aug. 30

Central Time Zone

Aug. 31

Eastern Time Zone

Microsoft® Excel®: Beyond the Basics

LIVE ONLINE SEMINARS

May. 12

Central Time Zone

May. 14

Eastern Time Zone

May. 19

Central Time Zone

May. 21

Pacific Time Zone

May. 25

Eastern Time Zone

May. 27

Central Time Zone

Jun. 3

Central Time Zone

Jun. 9

Eastern Time Zone

Jun. 11

Central Time Zone

Jun. 15

Central Time Zone

Jun. 17

Pacific Time Zone

Jun. 23

Central Time Zone

Jun. 25

Eastern Time Zone

Jun. 29

Central Time Zone

Jul. 8

Eastern Time Zone

Jul. 9

Central Time Zone

Jul. 13

Central Time Zone

Jul. 15

Pacific Time Zone

Jul. 16

Eastern Time Zone

Jul. 21

Eastern Time Zone

Jul. 21

Pacific Time Zone

Jul. 22

Central Time Zone

Jul. 27

Pacific Time Zone

Jul. 28

Central Time Zone

Aug. 5

Pacific Time Zone

Aug. 6

Central Time Zone

Aug. 10

Central Time Zone

Aug. 11

Eastern Time Zone

Aug. 12

Central Time Zone

Aug. 18

Eastern Time Zone

Aug. 20

Central Time Zone

Aug. 24

Central Time Zone

Aug. 26

Central Time Zone

Aug. 27

Pacific Time Zone

Aug. 31

Central Time Zone

Sep. 1

Central Time Zone

Advanced Microsoft® Excel®-Macros, PivotTables, Charts and More

LIVE ONLINE SEMINARS

May. 14

Central Time Zone

May. 19

Eastern Time Zone

May. 25

Central Time Zone

Aug. 3

Central Time Zone

Aug. 4

Eastern Time Zone

Aug. 12

Central Time Zone

Aug. 17

Central Time Zone

Aug. 23

Central Time Zone

Sep. 1

Pacific Time Zone

Related Formulas Articles

Leave a Reply

Your email address will not be published. Required fields are marked *