# convert percentage in excel

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

Not open for further replies.

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

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.

File size:
274.6 KB
Views:
12

Joined:
Mar 27, 2008
Messages:
6,608
First Name:
Hans

3. ### 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

Joined:
Jul 19, 2018
Messages:
7

Hi Jack,

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

File size:
183.5 KB
Views:
4
5. ### 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,

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

Noted, Thank you....

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

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,

As Seen On