Consulting

Results 1 to 2 of 2

Thread: Inverse Percentage

  1. #1

    Inverse Percentage

    Need help getting inverse percentage from two cells. I have C2/B2 where b2=100 and c2=95 which would give me 105.26% I just want the 5% not the 105 can anyone help. If I reverse them I get 95% so again how can I reverse and get 5%. With b2 and c2 constantly changing. I would like to have help with this function. I have tried multiple ways but I am not having any luck with conventional math functions as I know excel works differently. Any help would be much appreciated. Thanks

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    =b2-c2
    =100 - 95 = 5

    c2/b2 = 0.95 or 95%

    =1 - c2/b2
    =1 - 95/100 = 0.05 or 5%

Posting Permissions

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