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.
-75%
-95.24%
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!
That's a 46 and 2/3% increase.
34/49 = 0.6939 = 69.39% (to 2 dp) So the percentage decrease is 100 - 69.39 = 30.61%
-75%
-95.24%
60% decrease.
2
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!
2/3 gone
Identify the percent of change as an increase or a decrease.120 meals to 52 meals
That's a 46 and 2/3% increase.
........................................................._ The decrease is 100/150, 2/3, or 66.6% decrease (a horizontal line above a number or series of numbers indicates endlessness)
$2.50
34/49 = 0.6939 = 69.39% (to 2 dp) So the percentage decrease is 100 - 69.39 = 30.61%
40/50 = .8 1-.8 = .2 The percent decrease from 50 to 40 is 20.