Monday, February 18, 2013

How to Calculate Daily Percentage Change in Excel 2007


1. Type 'Beginning of Day' in cell A1, 'End of Day' in cell B1 and 'Percent Change' in cell C1 in Excel 2007.
2. Type the day's beginning value in cell A2. For example, if a stock's price is $40 at the start the day, type '40.'
3. Type the day's ending value in cell B2. In the example, assume the stock closed at $45. In this case, type '45' in cell B2.
4. Type '=(B2-A2)/A2)' in cell C2. In the example, you get the result '0.125.'
5. Select the 'Home' tab, and click the 'Number' box.
6. Select 'Percentage' under 'Category.'
7. Choose the amount of decimal places you want your percentage to have, and click 'OK.'

Blogger news