Forum Discussion
When will the next Excel AMA occur in 2019?
I need to ask the product managers about Excel. I want to know why Excel multiplies numbers by 100 to calculate percentages? Example, I have 15.00 but when I apply percentage formatting it ...
Hi,
In fact, Excel doesn't multiply the number by 100, it's just changing the format of it.
The integer 1 is represented in the percent format in 100%.
So when you format this number 15 (which is fifteen integers) as Percent the result is 1500%. that's correct!
Each 1 in 15 = 100%
15 = 1500%
To check that, see the result of this formula:
=15=1500%
The result is TRUE.
If you want to apply the percent format without going back and edit the cell, you need to have this number instead of 15.00:
0.15
0.15 is a decimal number which is a fraction of 1 integer.
Hope that helps