+ Reply to Thread
Results 1 to 3 of 3

Formulate discount based on total amount

  1. #1
    Registered User
    Join Date
    06-03-2022
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office 365
    Posts
    3

    Formulate discount based on total amount

    Hi Everyone!

    I am new here but would love some help!

    The "Target ARR" number in L14 is my target number that I need the "Total ARR" in L12 to equal to based on the calculations from the items right above it. The discount for all products (A-F) would need to be the same for all products. The total from that plus the "Entitlement" number is B11 need to equal the Total ARR.


    Is there a way to sort of reverse engineer the formula if you have the starting number to calculate the discount needed? If it cant include the Entitlements number in B12 that isn't a big deal. That number is usually static anyway.

    Any help would be greatly appreciated. I have been fumbling around with this for weeks. The file should be attached.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Formulate discount based on total amount

    N3 =SUM(J3:J8)

    N4=L14-B11

    N5=(1-(N4/N3))*100%

    K3=$N$5 and drag down.

    See the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Formulate discount based on total amount

    Thanks for the rep.

    Glad I could help.

    Thanks for marking the question solved.

+ 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] Group wise total amount & net total amount in listbox using vba
    By sbvaram in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-20-2021, 02:53 AM
  2. Replies: 2
    Last Post: 07-09-2019, 03:16 AM
  3. [SOLVED] Different discount for different products amount
    By AugustsD in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-30-2015, 07:28 AM
  4. how to work out rate based on total time and total amount
    By lisaathers in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2013, 06:44 AM
  5. Total Discount value based on multiple criteria
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2013, 07:31 AM
  6. How do I discount by % not amount
    By GaryPip in forum Excel General
    Replies: 18
    Last Post: 12-03-2009, 09:02 PM
  7. Discount based on amount?
    By seaniexxx in forum Excel General
    Replies: 2
    Last Post: 02-06-2009, 06:14 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