Increase or decrease a number by a percentage

From Microsoft Office Excel 2003

previous page next page

Create a blank workbook or worksheet.
Select the example in the Help topic. Do not select the row or column headers.

Selecting an example from Help
Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

1

2

A	B
Number	Percent Increase
23	3%
Formula	Description (Result)
=A2*(1+5%)	Increases number in A2 by 5% (24.15)
=A2*(1+B2)	Increase number in A2 by the percent value in B2: 3% (23.69)
=A2*(1-B2)	Decrease number in A2 by the percent value in B2: 3% (22.31)

Note When you use a number followed by a percent sign (%), the number is interpreted as a hundredth of its value. For example, 5% is interpreted as .05.

previous page start next page