Results 1 to 6 of 6

Thread: Teired rates

  1. #1

    Question Teired rates



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi

    Just need some help with a formula. We sell 150 units at 0.25 cents then after 150 the price is reduced to 0.10 cents. We can get excel (2013) to calculate 150 at 25 but cannot get a formula to calculate unit price of 10 after 150.

    Many thanks
    Last edited by NBVC; 2014-08-25 at 12:48 PM. Reason: Title revision

  2. #2
    Try this, assuming the number of units is in A2

    =SUMPRODUCT(--(A2>{0;150}),--(A2-{0;150}),{0.25;-0.15})

  3. #3
    In this case, because you only have two variable rates, this might be simpler

    =A2*0.1+MIN(A2,150)*0.15

  4. #4
    Or even

    =MIN(A2,150)*0.25 +MAX(0,A2-150)*0.1


  5. #5
    Hi

    Thanks for your help Bob it worked much appreciated.


  6. #6
    Which did you go for?

Posting Permissions

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