# changing a value of a cell when it reaches a certain number.

1. ## changing a value of a cell when it reaches a certain number.

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.

Curtis

2. ## Re: changing a value of a cell when it reaches a certain number.

Put the actual number sold in, say, S2, then you could have this formula to work out the commission:

= S2 * IF(S2<12,10,15)

Hope this helps.

Pete

3. ## Re: changing a value of a cell when it reaches a certain number.

Thank You Pete !!! That is exactly what I was trying to do.

Curtis,

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1