Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    127

    Unanswered: Percentage Difference

    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

  2. #2
    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. #3
    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
  •