Excel and how it Rounds

[tenchie]

I am running a spreadsheet - that I am keeping track of the perecent of data - I have codes set up so as I enter the reason (code) it automatically updates - works like a charm - however, today I notice that my figures do not total 100 percent (they have up to this point) and I'm sure it has something to do with how the columns are configured to round?


Can anyone help?


thanks very much

[pre]

Code	Total	Percent of Total
1	1	14%
2	1	14%
3	0	0%
4	0	0%
5	1	14%
6	4	57%
7	99%

[/pre]

 

[Luke M]

Can you post the formulas you are using? Or are you using a PivotTable? Otherwise we are guessing blind. IF this was a PivotTable, here's how it should be looking:

[pre]

Code       	Score   % of Total
1	        1	14.29%
2	        1	14.29%
3	        0	0.00%
4       	0	0.00%
5       	1	14.29%
6       	4	57.14%
Grand Total	7	100.00%

[/pre]
Note that you need the decimal portion of each number to get the last 1%.