Sorry in advance if im not wording things correctly. I am making a spread sheet to use for payroll. My employees get a certain amount of commission if they sell a certain amount of items and a different amount if they sell more.
Sold 6 * 10.00 = $60.00 (items 1-11 get paid 10.00 each)
Sold 14 * 15.00 = $210.00 (items 12 and up paid 15.00 each)
Is there a way to make a formula that when I enter 1-11 it calculates 10.00 each and when I enter 12 and up it calculates 15.00 an item?
The way I do it now is I use 2 columns, 1 for 1-11 and the other for 12 and up. I am trying to make it 1 column that I can enter either 1-11 and it Multiplies by 10.00 and 12 and greater it multiplies it by 15.00.
Thank you for your help!
Curtis
Bookmarks