Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Percentage calculation in Excel (https://www.askmehelpdesk.com/showthread.php?t=401873)

  • Oct 2, 2009, 04:53 AM
    MrKevin81
    Percentage calculation in Excel
    I need to work out the amount of settlement discount taken by a customer:

    I have the payment amount and the percentage.

    How do I calculate the original invoice amount?

    Here is what I have:

    Payment amount: 6113.25
    Percentage discount: 2.5%

    I have used the goal seek function to work out that the original invoice amount is 6270.00

    Can someone please help me to create a formula for this?
    I need to calculate a lot of these and the goal seek option is very time consuming.

    Thank you!
  • Oct 2, 2009, 06:30 AM
    Perito

    OriginalAmount * (1-(PercentDiscount)/100) = PaymentAmount

    or

    OriginalAmount = PaymentAmount / (1-PercentDiscount/100)
  • Oct 2, 2009, 06:32 AM
    donf

    The easiest way I can think of is to simply divide $6113.25 by 0.975 to get the original balance of $ 6270(rounded up).

    The .975 is the difference between 100% minus 2.5 %.

    Since the amount $6113.35 represents 97.5% of the total balance.
  • Oct 2, 2009, 06:43 AM
    MrKevin81
    Quote:

    Originally Posted by Perito View Post
    OriginalAmount = PaymentAmount / (1-PercentDiscount/100)

    This one worked! Thank you very much!

  • All times are GMT -7. The time now is 01:29 PM.