+ Reply to Thread
Results 1 to 4 of 4

Excel Formula to find % discount, giving as input the Full Price and the Net Price.

  1. #1
    Registered User
    Join Date
    01-19-2021
    Location
    Italy
    MS-Off Ver
    MS Office 365
    Posts
    2

    Excel Formula to find % discount, giving as input the Full Price and the Net Price.

    Hello,

    I need help please for an automatic/ semi automatic % finder.
    I Need to find which % of discount is a Net price, from a Full price.
    We have 5 possible groups:
    A. Under 49.99%
    B. From 50% to 50+5%
    C. from 50+5+1% to 50+5+5% (to 50+10%)
    D from 50+10% to 50+10+5% (to 50+15%)
    E. from 50+15+1% to 50+15+5 and higher.

    Considering the upper rules, I want to ask if it's possible to find from the input of full and net price, to exactly which % it's =?
    I attach my actual Excel Formula and some examples, please view it to understand better.

    So, a % discount finder considering the logic of the discount groups.
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Excel Formula to find % discount, giving as input the Full Price and the Net Price.

    Hi, and welcome to the forum

    It's not clear, at least to me, which are all the input cells and which are the results cells.

    Please add manual examples of results that you expect given specific inputs. Create several examples which cover all permuations and expplaoin what rules yuo have applied to get the results.

    Essentially what we need to see is what you start with, no more no less, and what you end up with
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    01-19-2021
    Location
    Italy
    MS-Off Ver
    MS Office 365
    Posts
    2

    Re: Excel Formula to find % discount, giving as input the Full Price and the Net Price.

    Hello and thank you.

    I know like info only Full price (B9) and Net price (C9).
    I need to discover the discount % (D9).

    You can already check my formula from D9, but I call it "Basic formula", because I need it to be smart and to tell me to which discount it's =, considering the rules.

    Examples:
    So it will not be a 55% discount like now, in D9, but I want it to tell me it's a 50+10%.
    Or that it's not a 55.9%, but a 50+10+2%...

    Is it possible?

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,425

    Re: Excel Formula to find % discount, giving as input the Full Price and the Net Price.

    This proposal, modeled in the attached file, employs the values and formulas in rows 27:28 as helpers which have been copied to L8:AM9 and which may be hidden for aesthetic purposes.
    The formula which populates cell K9 is: =INDEX(L8:AM8,IFNA(MATCH(SUM(I9,AGGREGATE(15,6,ABS(L9:AM9-I9),1)),L9:AM9,0),MATCH(I9-AGGREGATE(15,6,ABS(L9:AM9-I9),1),L9:AM9,0)))
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Replies: 6
    Last Post: 04-25-2020, 09:24 AM
  2. Replies: 4
    Last Post: 03-02-2020, 11:35 PM
  3. Replies: 16
    Last Post: 07-24-2018, 03:19 PM
  4. List price and Discount Manipulator to Get the Target Net price
    By xoblox in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2016, 03:52 PM
  5. Price Per Unit in a Table for a Fixed Incremental Price Discount
    By natkoy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2016, 03:51 AM
  6. Replies: 6
    Last Post: 10-12-2005, 03:05 PM
  7. [SOLVED] formula for - price times discount times tax = final price
    By anton in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-12-2005, 09: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