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

    I have been given the figures in columns A &B which tallies with my formula except row 5 which has been given a 100% which is correct please.

    Regards

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

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Hi Brad - Did you intend to include an example?

    Tim

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

    Sorry about that now attached,

    Regards

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

  4. #4
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Quote Originally Posted by braddy60 View Post
    Hi

    except row 5 which has been given a 100% which is correct please.

    Regards

    Braddy
    Hi Braddy - What is meant by given a 100% ?

    Will this formula work for you in all of Column D?
    =IF(ISERR(B2/A2-1),"N/A",B2/A2-1)



    Tim

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

    I was given these figures in hard copy and was trying to see if they are correct, ie the average number of burgalaries has increase by 100% from 2.7 to 5.3

    Regards

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

  6. #6
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Braddy,

    Disclaimer: I'm no mathematician!

    That said try: =IF(A5>B5,(B5-A5)/ABS(A5),ABS(A5-B5)/ABS(A5))

    I entered this one and got the correct answer: 96.30% 100% would = 5.4 {2.7 *2}.
    I also dragged this formula up and down w/o appreciable changes in values.

    The difference is in always dividing by the same column {A} for either increases or decreases.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  7. #7
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Hi Braddy - The 2 formulas mentioned in previous posts above, produce essentially similar results. The differences between these 2 formulas are highlighted in pic below.

    [attachment=89561:crime levels.jpg]

    Hope that helps.
    Attached Images Attached Images

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

    Many thanks it was row 5 that concerned me, with your formula it is now correct @ 96.30% whereas mine resulted in 49.06%.

    Thanks to all who replied.


    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
  •