Excel formulas question?
I'm trying to figure a formula and need some help. I need to decrease a number by a percentage, then increase it by another percentage.
Example: $4,500 decreased by 5% and then increased by 2%. Any help is appreciated!
Update:Thank you for your help, that's exactly what I was looking for!
More Questions From This User See All
![BHH [Bustin' Ho's Heads]](https://q2a.es/img/profile/B/BHHccBustinccx27ccHoccx27cscHeadsc.jpg)
Answers & Comments
Verified answer
mata is right.
you can put your number in a cell and use cell references in your formula
A1 = 4500
A2 you can copy&paste this formula
=(A1*0.95)*1.02
mata showed you how the calculations work, if you have to show your calculation
in B1 copy&paste this formula to show the 5% decrease
=A1*0.95
then in C1 copy&paste this formula to show the 2% increase
=B1*1.02
then you can change cell A1 and the formula will auto-calculate
you can also put the %'s in different cells, and reference the chosen cell...just in case you want to change the percentages later on.
good luck
decrease x by y%: x*(1-y/100)
increase x by y%: x*(1+y/100)
so, in your case:
4500*0.95*1.02