Question: How do you find the first IF Function and Second IF Function on Excel. What is the formula used? 2012 2013 2014 2015 Sales Commissions:

How do you find the first IF Function and Second IF Function on Excel. What is the formula used?

How do you find the first IF Function and Second IF Function

2012 2013 2014 2015 Sales Commissions: Sales in Units Unit Sales Price 1500 1200 2250 1200 4100 1200 1800 1200 Commission % less than first Break point Commission % less than 2nd Break point Commission over 2nd Break point 5% 8% 11% 5% 3% 11% 5% 8% 11% 5% 3% 11% First Break Point in Units Second Break Point in Units 2,000 4,000 2,000 4,000 2,000 4,000 2,000 4,000 First IF Function Total Sales Commissions 108,000 168,000 349,200 129,600 Second IF Function Total Sales Comissions 96,000 168,000 349,200 124,800

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 Databases Questions!