Question: How do I create an IF Function in excel to calculate the commission amounts and How do I create the IF Function to calculate the

How do I create an IF Function in excel to calculate the commission amounts and How do I create the IF Function to calculate the bonus
Sales Rep Comm Code 1st Quarter SalesCommission Bonus
Kimsey, C.J.(Code 2)$120,674
Toven, Steve (Code 1)$85,784
Claxton, Marie (Code 1)$48,943
Post, Jackie (Code 1)$80,452
Jackson, Elizabeth (Code 2)$125,739
Millington, Jeff (Code 1)$82,649
Code 1 Commission Rate 10%
Code 2 Commission Rate 12%
Sales Level for Bonus $85,000
Bonus Commission Rate 2%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!