1. Registered User
Join Date
Oct 2007
Posts
127

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?

2. Registered User
Join Date
Dec 2004
Posts
37

## ABS(Number)

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

3. Registered User
Join Date
Oct 2007
Posts
127
micheal,

cheers mate you a STAR!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•