L
luckyt22
I am trying to Round a group of numbers and then add up thei
values...any ideas??? FOR EXAMPLE...i have the following numbers...
100,324.51
53,213.76
34,527.33
344,869.50
18,803.66
241,406.10
2,299.88
38,171.09
183,350.12
71,334.89
66,924.06
472,549.11
166,470.45
215,908.16
34,572.53
52,408.16
251,905.22
59,723.59
20,782.59
131,984.95
334,036.00
3,638.02
30,650.25
314,257.83
46,297.56
*3,290,409.32 * <= They need to add up to this
Now if you actually did add all those numbesr up it would come ou
right...except those values actually are a lot longer than just
digits after the decimal...so sometimes when i sum those up...i am of
.01 or.02 give or take...so what i want to do in the total cell i
round all the numbers to 2 decimal places and and those values up...i
this possible?
Thanks!
To
values...any ideas??? FOR EXAMPLE...i have the following numbers...
100,324.51
53,213.76
34,527.33
344,869.50
18,803.66
241,406.10
2,299.88
38,171.09
183,350.12
71,334.89
66,924.06
472,549.11
166,470.45
215,908.16
34,572.53
52,408.16
251,905.22
59,723.59
20,782.59
131,984.95
334,036.00
3,638.02
30,650.25
314,257.83
46,297.56
*3,290,409.32 * <= They need to add up to this
Now if you actually did add all those numbesr up it would come ou
right...except those values actually are a lot longer than just
digits after the decimal...so sometimes when i sum those up...i am of
.01 or.02 give or take...so what i want to do in the total cell i
round all the numbers to 2 decimal places and and those values up...i
this possible?
Thanks!
To