1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

convert percentage in excel

Discussion in 'Business Applications' started by jassy6939, Jul 19, 2018.

Thread Status:
Not open for further replies.
Advertisement
  1. jassy6939

    jassy6939 Thread Starter

    Joined:
    Jul 19, 2018
    Messages:
    7
    Dear All,

    Please help me if anyone can.

    In my excel column no O17 amount is 16937 when I convert in 1000 format it just comes 17 and column no N17 amount is 71800 when it convert to 1000 format it comes 71.8. In column O18 I just enter equation
    =(O17*4)/N17-1 the figure which I got is 94320% but actual it must be -5%. I don't know what reason amount showing wrongly. Please help me if someone knows the reason:). I attach my excel sheet.
     

    Attached Files:

  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Your file contains links to the original file, cannot help with invalid links
     
  3. Chawbacon

    Chawbacon

    Joined:
    Jul 9, 2018
    Messages:
    540
    First Name:
    Jack
    Hello Jassy,

    Based upon your desired outcome of -.05%. It appears that you are missing a pair of parenthesis.

    Try the following: =((O17*4)/N17)-1

    Good Luck
     
  4. jassy6939

    jassy6939 Thread Starter

    Joined:
    Jul 19, 2018
    Messages:
    7

    Hi Jack,

    Thanks for your reply. When I tried the same it's showing same result
     

    Attached Files:

  5. Chawbacon

    Chawbacon

    Joined:
    Jul 9, 2018
    Messages:
    540
    First Name:
    Jack
    Hello again Jassy,

    The formula I provided forces Excel to perform the desired math function without possibility of ambiguity. Therefore the root cause will be probably be associated with your linked data. Excel calculates on the stored data and not the displayed data. An additional possibility would be a formatting issue with the current sheet or with the linked data. Custom formatting within Excel can cause some strange outputs, especially when rounding is involved.

    As Hans stated above, without data referring to invalid links, a resolution will be primarily guess work.

    The best of luck,
     
  6. jassy6939

    jassy6939 Thread Starter

    Joined:
    Jul 19, 2018
    Messages:
    7
    Dear Jack,

    Noted, Thank you....
     
  7. jassy6939

    jassy6939 Thread Starter

    Joined:
    Jul 19, 2018
    Messages:
    7
    Dear Jack,

    In my excel column no O17 amount is 16937 when I convert in 1000 format it just comes 17 and column no N17 amount is 71800 when it convert to 1000 format it comes 71.8. In column O18 I just enter equation
    =(O17*4)/N17-1 the figure which I got is 94320%.

    Now I understand how excel consider my equation. Excel consider in my equation =(O17*4)/N17-1 instead of taking (17*4)/71.8-1 excel consider (16937*4)/71.8-1=94320%. Do you have any solution for this??:)
     
  8. Chawbacon

    Chawbacon

    Joined:
    Jul 9, 2018
    Messages:
    540
    First Name:
    Jack
    Hi Jassy,

    So the root cause here seems to be that the O17 cell is not converting to 1000 format.
    Personally, I would adjust the formula to force the value conversion to 1000 format (similar to database programming... run computations on the final form value and not within the database). ;)

    (((16937*.001)*4)/71.8)-1

    Make sure you test this with other data sets to ensure data change compatibility!

    I hope this helps,
     
  9. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - convert percentage excel
  1. admiral83
    Replies:
    2
    Views:
    721
  2. aacm
    Replies:
    2
    Views:
    362
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1213177

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice