+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    03-13-2013
    Location
    ft lauderdale, Fl
    MS-Off Ver
    Excel 2010
    Posts
    2

    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.

    Thank you for your help!

    Curtis

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,573

    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. #3
    Registered User
    Join Date
    03-13-2013
    Location
    ft lauderdale, Fl
    MS-Off Ver
    Excel 2010
    Posts
    2

    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,

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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