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!