Step based commission formula

Originally Posted by Kevin UK

HaHa don't you love this site. Double posts again!!!!

I deleted one.....

I don't think a LOOKUP approach will work - If I understand correctly then commsion is 60% of the first 10,000 and then 70% of everything after, so if total sales is 20,000 then you don't pay commision at 70% on the whole amount - you pay 10,000 @ 60% and 10,000 @ 70% hence an answer of 13,000........that's what my suggested formula does