Excel column sum, part 2
 

OK, I appreciate your speedy response. However, help!
Please add these for me and then give me the formula. I'm working iwth
paryoll and the 1 cent off is driving me crazy.
64.58, 15.10, 126.00, 24.91
this should equal - 230.59
the way the formula is now the total is 230.60.
It's driving me nuts.
thank you,
kandyr

Excel column sum, part 2
 

Use the ROUND function to round your values to 2 decimal places.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"kandyr" wrote in message
...
OK, I appreciate your speedy response. However, help!
Please add these for me and then give me the formula. I'm
working iwth
paryoll and the 1 cent off is driving me crazy.
64.58, 15.10, 126.00, 24.91
this should equal - 230.59
the way the formula is now the total is 230.60.
It's driving me nuts.
thank you,
kandyr

Excel column sum, part 2
 

See http://www.mcgimpsey.com/excel/pennyoff.html

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"kandyr" wrote in message
...
OK, I appreciate your speedy response. However, help!
Please add these for me and then give me the formula. I'm working iwth
paryoll and the 1 cent off is driving me crazy.
64.58, 15.10, 126.00, 24.91
this should equal - 230.59
the way the formula is now the total is 230.60.
It's driving me nuts.
thank you,
kandyr