Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Percentages (Excel 2002)

    Hi

    I am always having trouble with percentage formulas.

    I would be grateful if someone could fill in the 3 example in the attached spreadsheet.

    Thanks in advance

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Percentages (Excel 2002)

    <P ID="edit" class=small>(Edited by sdckapr on 02-Dec-04 16:14. Added to PS)</P>In G4:
    =(F4-E4)/E4

    Copy G4 to G5:G6.

    Format them as Percentage

    Change is:
    (New -Original) / Original
    or
    New/Original - 1

    Steve
    PS:
    I am not sure what you mean by "percentage difference".
    8 is 32% larger than 6.06
    5 is 17% smaller than 6.06 (note value calc is negative)
    7 is 16% larger than 6.06

    If you really want to calculate the "difference" it is 8-6.06 = 1.94
    Also if you really want to calculate the "percentage drop" you should use
    =-(F4-E4)/E4
    =(E4-F4)/E4

    This will give a pos number if the new number is smaller and a negative number if the new number is larger (though I find this dbl negative confusing and prefer to stick with % change)

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Percentages (Excel 2002)

    Hi Steve

    Thanks for your prompt reply , I think I was confusing difference with increase , what i am trying to do is compare an old cost with a new cost to find how much is has increased or decreased percentage wise .

    Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Percentages (Excel 2002)

    Hi Steve

    I take your point I will stick with the origional formula that you gave me.

    Thanks again

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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