Rounding Question
There isn't a universally right way to do this. For instance what about:
49.512%
49.512%
0.978%
-------
100.00%
will round/display (to the nearest percent) as
50%
50%
1%
----
101%
or perhaps
49%
49%
1%
----
99%
What would *your* preferred answer be in that case? Can you describe, in
words, an algorithm that XL should use to make the choice?
In article ,
Curt J wrote:
Hi Mike, thanks for responding to my post.
I actually am using formatting to show the percentage to show zero decimal
places. I also tried the round function and that didn't work either.
"Mike H" wrote:
Hi,
Because you are using round the values are being changed. Format the
percentage cell to show zero decimal places instead of using round and your
sum will be correct.
Remember rounding and its variants change the value of a cell compared to
formatting which changes the way you see the value.
Mike
"Curt J" wrote:
In my spreadsheet I have 6 cells that always sum to equal 100%. I am
having
troubles showing the values as whole numbers that will always will equal
100%. For example I ran into the following problem:
50.585%
48.903%
00.512%
00.000%
00.000%
00.000%
total = 100%
My spreadsheet shows:
51%
49%
1%
0%
0%
0%
Total equals 101%
How do I get it to show:
51%
49%
0%
0%
0%
0%
Total Equals 100%
Thanks,
Curt J
|