+ Reply to Thread
Results 1 to 3 of 3

Calculating the percent off the percent

  1. #1
    Registered User
    Join Date
    04-22-2019
    Location
    United States
    MS-Off Ver
    2016
    Posts
    6

    Question Calculating the percent off the percent

    I'm trying to calculate a formula that is the option of a percentage off a percentage. My numbers are:
    Item price: $500
    Vendor Discount: 20%
    Client Discount: 20%
    Output should read (500*20%)=400 THEN (400*20%)=320

    Is this possible to do all in 1 formula or do I need to just put in separate cells and hide? Also, will it be a problem in the calculation if there is no vendor discount?

    Thank you so much. I've been trying to figure this out for too long.

  2. #2
    Spammer
    Join Date
    01-08-2015
    Location
    Cali, Colombia
    MS-Off Ver
    365
    Posts
    302

    Re: Calculating the percent off the percent

    Hi, helpmeplease2019!

    This is not an excel problem... just Mathematics...

    If you have
    [A1] : Item Price
    [A2] : Vendor Discount
    [A3] : Client Discount

    You could try:
    =A1*(1-A2)*(1-A3)

    Blessings!

  3. #3
    Registered User
    Join Date
    04-22-2019
    Location
    United States
    MS-Off Ver
    2016
    Posts
    6

    Re: Calculating the percent off the percent

    Oh man. You're right. Thank you so much! I was making it more difficult than I needed.

+ 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] Commission Percent based on Gross Margin Percent Formula
    By canselmi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2019, 07:05 PM
  2. Commission Percent based on Gross Margin Percent Formula
    By canselmi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2019, 01:10 PM
  3. [SOLVED] Percent calculating
    By AaruJaan in forum Excel General
    Replies: 4
    Last Post: 01-31-2017, 12:59 PM
  4. Formula or function to find percent of a percent in a population
    By maldron in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-25-2013, 08:26 PM
  5. How to Times a percent, and be able to change percent.
    By ILCentral in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2012, 11:55 AM
  6. Graph Actual Percent with Suggested Percent
    By jaytaylor in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-05-2010, 07:09 AM
  7. Replies: 2
    Last Post: 09-15-2005, 02:05 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