Excel formulas question?

May 2021 2 126 Report

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!

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