+ Reply to Thread
Results 1 to 2 of 2

Formula to price product by quantity variation

  1. #1
    Registered User
    Join Date
    05-18-2011
    Location
    Irinve
    MS-Off Ver
    Excel 2007
    Posts
    1

    Formula to price product by quantity variation

    I want a formula to provide pricing for the following:
    -The base price is $240,000, which includes up to 250 (this number is sockets, in case you are wondering)
    -if the number is from 251 to 400 I need to subract that number from 250 and then multiply by $680. Then I need to add $240,000
    -if the number is from 401 to 600 I need to subract that number from 250 and then multiply by $540. Then I need to add $240,000
    -Lastly, if the number is over 600 I need to subract that number from 250 and then multiply by $400. Then I need to add $240,000

    Here are some examples results:
    -If there were less than 251 sockets the price would be $240,000.
    -If there were 300 sockets the price would be $274,000 (((300-250)*$680)+$240,000)
    -if there were 700 sockets the price would be $420,000 (((700-250)*$400)+$240,000)

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Formula to price product by quantity variation

    Try

    =240000+((A1-250)*lookup(A1,{0,251,401,601},{0,680,540,400}))

    where A1 holds the socket value

+ 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