one Percentage increase / decrease formula in excel that full all the conditions that are mentioned below

2012 2011
1 0 0
2 0 500
3 500 0
4 500 1000
5 1000 500
6 500 (1000)
7 (1000) 500
8 (500) (1000)
9 (1000) (500)

Dear its urgent

To calculate the percentage increase or decrease in Excel, you can use the following formula:

=((New Value - Old Value) / ABS(Old Value)) * 100

Where:
- "New Value" refers to the value after the change.
- "Old Value" refers to the original value.

Here's how you can apply this formula to your example:

1. Open Microsoft Excel and enter your data in columns A and B. Let's assume you have entered "2012" in column A and "2011" in column B.
2. In cell C1, enter the formula: =((B1-A1)/ABS(A1))*100.
3. Copy the formula from cell C1 and paste it down to cell C9 to apply the formula to the entire range of data.

By doing this, you will calculate the percentage increase or decrease between each pair of values in columns A and B. The result will be displayed in column C.