I am trying to write a formula to calculate commissions.
Employees collect 60% of sales up to a $25,000 threshold.
After the $25,000 has been paid they collect 100%
I am having a hard time getting Excel to calculate the sale at the point they cross the threshold and still accuratly calculate...