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 between two values in Excel, you can use the following formula:

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

Here's how to apply this formula to your data:

Assuming the "2012" values are in column A and the "2011" values are in column B, you can enter the formula in column C, starting from row 2.

In cell C2, enter the formula: = (A2 - B2) / ABS(B2) * 100

Then, click and drag the fill handle of cell C2 down to fill the formula for the rest of the data.

This formula will calculate the percentage increase or decrease between the values in columns A and B.

Please note that if you have any cell contains a negative value or zero in the denominator (B2), the formula will return an error. To avoid this, you can use the ABS function as shown above, which will take the absolute value of the denominator.

To calculate the percentage increase or decrease between two values in Excel, you can use the formula:

```excel
=((B2-A2)/ABS(A2))*100
```
Here, `A2` represents the value from 2012 and `B2` represents the value from 2011.

To apply this formula to the entire column, follow these steps:

1. In cell C2, enter the formula `=((B2-A2)/ABS(A2))*100`.
2. Press Enter to calculate the percentage increase or decrease for that specific row.
3. Click on cell C2 to select it.
4. Double-click on the small green square at the bottom right corner of the selected cell and drag it down to apply the formula to the entire column.
5. Excel will automatically adjust the cell references accordingly for each row.
6. You will now have the percentage increase or decrease calculated for each row in column C.

The formula takes the difference between the 2011 and 2012 values, divides it by the absolute value of the 2012 value (to handle negative values), and then multiplies it by 100 to express the result as a percentage.