I have 1,250 in cell H9, and 10% in cell H17
I have the formula =$H$9*$H$17 in cell D19
When I look at the results in D19, which is formatted to display a percentage, I see 12500.00%
When I use the calculator to check the math, I see that 1,250 * 0.1 is 125.
I know I have a structural error in my formula, but for the life of me, I do not see it.
Can someone help with this brain bump?
The result is correct, but it’s not usual to do it this way.
1250 is 100% equal to 125000%. 10% of 1250 is thus 12500%.
Removed tag math on your behalf
Thank you!
There is no error. Percentage formatting only shifts the “unit”: instead of displaying number in multiples of 1, they are displayed in multiple of 0.01.
10% = 0.10 = 0.10 / 0.01 %
1,250 = 1,250.00 = 125,000 %
1,250 × 10% = 125 = 125.00 = 125.00/0.01 % = 12,500 %
If you want to display it as 125, don’t use a % formatting code.
To show the community your question has been answered, click the ✓ next to the correct answer, and “upvote” by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!
In case you need clarification, edit your question (not an answer which is reserved for solutions) or comment the relevant answer.
Thanks. I was going bonkers for a bit. I will merely bring what I need to 125.0% by having the result divided by 100.
Is your result really supposed to be a percentage, or do you intend to arrive at some amount (money, weight, count, etc.)?
I am looking to show a percentage.
Great!
That is also what @ml9104’s “unusual” remark was about, I guess.
This type of target result is unusual, but not unheard of. I just thought it pertinent to double check. You know what you need, so you are good.