Friday, July 20, 2012

How to Calculate Percentage Increases in Excel 2007


1. Type 'Beginning Number' in cell A1, and then type your beginning number in cell B1. For example, type '50' in cell B1.
2. Type 'Ending Number' in cell A2, and then type your ending number in cell B2. In the example, type '100' in cell B2.
3. Type 'Percent Increase' in cell A3.
4. Type '=((B2-B1)/B1)' in cell B3. In the example, your result will be 1, or 100%.

Blogger news