+ Reply to Thread
Results 1 to 3 of 3

Two sequential percentage discounts in the same formula

  1. #1
    Registered User
    Join Date
    07-04-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    24

    Two sequential percentage discounts in the same formula

    I need to take a discount off of a previously applied discount. For example:

    I buy something for $50, then take 10% off,the formula I have for that is: (50-(50*.1))

    That's pretty simple. However, I need to take another discount off of that result, and that's the part where I get confused.

    When doing it on the calculator, the result is $40.50. I can't simply add the two discounts because that would be 20% off which equals $40.00, so I'm trying to figure out how to write this formula so that the 2nd discount takes into account the result of the first discount.

    Any ideas?

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Two sequential percentage discounts in the same formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Formula: copy to clipboard
    Please Login or Register  to view this content.


    First discount = 10% second discount = 10%
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    07-04-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    24

    Re: Two sequential percentage discounts in the same formula

    Awesome! Thanks for this,works great in my formula now!

+ 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. varying percentage discounts formula
    By elenarivera1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-29-2013, 01:29 PM
  2. Excel 2007 : Formula for calculating % discounts
    By Irajen in forum Excel General
    Replies: 6
    Last Post: 04-14-2010, 02:13 PM
  3. Need help creating formula to calculate discounts
    By Kwirky in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-29-2010, 11:43 PM
  4. Using formula's to calculate discounts
    By carl290666 in forum Excel General
    Replies: 10
    Last Post: 10-27-2009, 11:19 AM
  5. How do I create a formula for multiple levels of discounts?
    By bearkm02 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-12-2006, 05:15 PM

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