View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default 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