I know that formula to work out the Percentage Difference. But I the results are not formatted correctly.

| New Value – Old Value |
_____________________ x 100%

| Old Value |


450 – 781
________ x 100

781

=SUM(I29-I23)/I23*100

=SUM(781-450)/450*100

The result I get is -42

I how do I format the cell so it shows as an Absolute number and with a percentage sign?

Thank in advance

akhlaq,

to get the absolute number use the following formula

=ABS((I29-I23)/I23)

Then right click in the cell and set the cell format to percentage.

You will notice from the formula that I have removed the *100 since the formatting as a percentage will do that bit of the sum for you.

Hope this helps

micheal,

cheers mate you a STAR!