Hi, thanks in advance for your help with a very simple problem for a new Excel user.
Let's say a new amount is $100 and $100 was a X% increase from the former amount, what formula would I use to calculate the former amount? Conversely, if $100 is a X% decrease from the former amount, what formula would I use to calculate the former amount?
In addition to the formula, I would appreciate knowing the two equations as well. Thanks again, I'm a writer and math is not my strong suit.
Posted to wrong thread.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
OK< thanks anyway. Hopefully someone else con help.
Try:
Formula:
Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Thanks Mate! I'll try this when I get home.
You're welcome.
A2 has the percentage, B2 has the value.
Hi, this just isn't working for me. Perhaps I could be sent the equations and I'll figure it out from there.
Thanks!
The formula IS the equation. Value divided by (100 plus the percentage increase) times 100 …
Value/(100+%increase)*100
The value is the amount AFTER the increase so you divide by 100+increase and multiply that by 100.
Maybe I should clarify. I know that 9.09 *1.1 equals 10 however if I only knew the % increase (10%) and the final amount (10) and I don't know (9.09) what calculation would I use. to find (9.09)?
Maybe the actual equation that you would write on paper and I'll take it from there.
Thanks!
Last edited by lwood1; 01-29-2023 at 12:19 PM.
On paper? Not sure I can explain it a different way.
OK, I've got it now. Thank you very much for your patience.
You're welcome.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks