0
Multiply your value by 0.98 or by 98%, which in effect reduces it by 2%. So if the value was in cell A3, in another cell you could have either of these two formulas:
=A3*0.98
=A3*98%
If you have a lot of cells to do, there is another way. Put 0.98 into a blank cell. Then copy it and select the cells that you want to convert into 98% of their original values. Right click on the mouse and on the shortcut menu that appears, pick Paste Special. It will bring up a large dialog box. In the middle section of it, under Operation, click the radio button beside Multiply and then click OK. All the values will be multiplied by 98.
See the Related Question below for other ways of using percent formulas.
Still curious? Ask our experts.
Chat with our AI personalities
Beau
Judy
MaxineAdd your answer:
Earn +20 pts
What is the percent decrease from 42 to 2?
-95.24%
What is the percent decrease from 8 to 2?
-75%
What is a Percent of Decrease in math?
The percent of decrease means "what is the percentage decrease from a larger number to a smaller number?" For example: What is the percentage decrease from 90 to 72? Solution: (90 - 72) / 90 = % 18 / 90 = 1 / 5 = .2 = 20% Check: 90 * .2 = 18 90 - 18 = 72 = true!
What is the percent decrease in 45 to 66?
That's a 46 and 2/3% increase.
What is the percent of decrease from 49cm to 34cm?
34/49 = 0.6939 = 69.39% (to 2 dp) So the percentage decrease is 100 - 69.39 = 30.61%
