Thread: [Solved] What formula should I use to calculate commission?
View Single Post
 
Old 02-20-2011, 02:51 PM
grs grs is offline Windows XP Office 2000
Novice
  
Join Date: Feb 2011
Posts: 3
grs is on a distinguished road
Default What formula should I use to calculate commission?
I would like my spreadsheet to calculate the commission costs on a product.

Up to 25000 commission is charged at a rate of 1.5% then at .75% after that.

Lets say cell A1 has 56300 I would like cell A3 to display the total commission rate on the number is cell A1.

What formula should I use to generate this result?
Reply With Quote