software

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

Use the ROUND function to round your values to 2 decimal places.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;kandyrquot; gt; wrote in message
...
gt; OK, I appreciate your speedy response. However, help!
gt; Please add these for me and then give me the formula. I'm
gt; working iwth
gt; paryoll and the 1 cent off is driving me crazy.
gt; 64.58, 15.10, 126.00, 24.91
gt; this should equal - 230.59
gt; the way the formula is now the total is 230.60.
gt; It's driving me nuts.
gt; thank you,
gt; kandyr
See www.mcgimpsey.com/excel/pennyoff.html

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

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