Need help calculating commission based on the excel file I am attaching. The determination of the appropriate commission requires more complicated logic than the base pay. It is recommended that you add a column for “Commission Sales” where you create a formula using the VLOOKUP function to determine how much sales the associate requires for commission (# of hours multiplied by Hourly Sales in the lookup table – this will give you the amount of sales that is required to earn commission). Once you have calculated this, the commission formula must determine if a commission is to be paid, the applicable commission rate, the portion of sales on which to base the commission. Since the commission formula involves several lookups and decisions, you realize that nesting the IF and VLOOKUP functions is required.
Solved by B. B. in 18 mins