+ Reply to Thread
Results 1 to 3 of 3

Help with Excel Formula to determine the price based on number of transactions

  1. #1
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Smile Help with Excel Formula to determine the price based on number of transactions

    Hi All,

    Hope you are doing well!.. I am trying to determine the price for the input table which has the industry and the average monthly number of transactions..The reference table1 classifies the pricing tiers based on the number of transactions...The general rule is tier A is priced at 30 and tier B is priced at 95% of price of Tier A and Tier C is priced at 95% of tier B and so on..Can you please help me with this ..Attached the sample excel table with the input and the output tables..


    Thanks,
    Arun
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,475

    Re: Help with Excel Formula to determine the price based on number of transactions

    I'm sure you could have worked this out from the answer I gave you in your previous thread. Put this in cell C2 of the Output sheet:

    =30*POWER(0.95,MATCH(B2,Input!$H$2:$H$7)-1)

    then copy down as required.

    Hope this helps.

    Pete

    P.S. If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

    You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

  3. #3
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Re: Help with Excel Formula to determine the price based on number of transactions

    Thank you so much @ Pete_UK!..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help with Excel Formula to find the price based on industry and number of transactions
    By chandramouliarun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2022, 05:03 PM
  2. [SOLVED] Formula to determine price based on quantity used
    By Stasha in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-18-2022, 12:00 PM
  3. [SOLVED] Formula to Determine Tiered Price Levels
    By Ceciliayunita in forum Excel General
    Replies: 5
    Last Post: 02-19-2019, 07:04 AM
  4. How to write formula to determine Price
    By korsen in forum Excel General
    Replies: 4
    Last Post: 05-11-2018, 05:13 PM
  5. [SOLVED] determine a rate from a range of values based on a weekly fuel price
    By djgoody9 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-29-2013, 12:48 PM
  6. [SOLVED] Formula to determine number of Standard Deviations based on % of population
    By Paul D. Simon in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-15-2005, 11:05 AM

Tags for this Thread

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