Home > IT Answers > adding rounded numbers in Excel
Ronda
5 pts.
 adding rounded numbers in Excel
Microsoft Excel 2010, Excel 2010 functions
How do you add rounded numbers and get the addition of the rounded number shown not the actual number

 

.125 displayed as .13

.125 displayed as .13

.125 displayed as .13

I want to use the auto sum of .13+.13+.13  and have the cell display .39 NOT .38

ASKED: Feb 9, 2012  6:00 PM GMT
UPDATED: February 27, 2012  9:05:48 PM GMT
RELATED QUESTIONS
Ronda
5 pts.
Answer Wiki:
Last Wiki Answer Submitted:  Feb 9, 2012  6:00 PM (GMT)  by  Ronda   5 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

you will probably need to do a hidden column that contains the rounded values and display its sum instead

BigKat
 5,535 pts.