Unit Commission Before (and including) Threshold Units Sold Threshold Unit Commision 7 Use these cells in your formula: 2000$1.50$1.25After Threshold 9 For the first 2000 units sold during the year, pay a commission of $1.50 per unit. 10 11 After 2000 units are sold, switch to a commission of $1.25 per unit. 12 13 Use Excel formulas (no VBA) to calculate the commission for each month 15 16 17 18 Sales 19 Commission Feb Jan 227 Mar Ma Apr 606 Jun 176 Jul 368 Se Nov 594 510 503 485 403 148 980 21 Correct Answers 765.00 03.75 23 24 Notes: 25 - See if you can do this with no helper cells! - Try to use one formula that you enter in B19 and copy across