If Statements and Sales Commissions Calculations Part Two

Wayne Winston November 22, 2017

← Back to Course Content

In this video we use VLOOKUP, MATCH, INDEX, And IF functions to model a complex sales incentive plan.

These are the before and after files needed to follow along to this video:

SALES INCENTIVE START

SALES INCENTIVE FINISH

Excel With Wayne is an online Microsoft Excel Training Course taught by Dr. Wayne Winston. Dr. Winston is the world’s foremost Microsoft Excel Expert that teaches at some of the world’s largest organizations including Microsoft and government organizations such as the Navy and Army.

If Statements and Sales Commissions Calculations Part Two

Wayne Winston November 22, 2017

CONTACT INFO