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

    Percentage of the difference (Excel 97)

    Hi

    I have had a mental block cell E7 contains 90 cell F7 contains 131 I need to caluculate I need to caluculate the percentage difference between the two.
    I have to decide if F7 is more than 15% > E7

    Many Thanks

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

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Percentage of the difference (Excel 97)

    Try:
    =F7>(E7*1.15)
    which will return either true or false.
    Regards,
    Rory

    Microsoft MVP - Excel

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

    Re: Percentage of the difference (Excel 97)

    Hi Rory

    Thanks for your prompt reply

    Most Grateful

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

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Percentage of the difference (Excel 97)

    Hi,
    =(F7-E7)/F7 will work out to 31.3%, meaning that 131 is 31.3% greater than 90!
    Regards,
    Rudi

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

    Re: Percentage of the difference (Excel 97)

    Hi Rudi

    Many thanks for that

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

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Percentage of the difference (Excel 97)

    Hi Rudi,
    That should read:
    =(F7-E7)/E7
    which works out around 45%. Difference between the two is 41 which is a little less than half of 90.
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Percentage of the difference (Excel 97)

    GeeWhiz, treading such a fine line. Rory i had my doubts, but the more I think of it the more I think you are correct!
    Braddy, i do apologize for the incorrect data. Strangely, I fussed with this tiny problem, but I concent to Rory's answer!!!
    Regards,
    Rudi

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Percentage of the difference (Excel 97)

    FWIW this can be stated as

    =F7/E7-1

    and the formula for Braddy's original question could be stated as

    =F7/E7>1.15

    For a bad typist like me, it saves time! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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