How do I stop rounding in simple addition formula in Excel, 1 cen.

[bjm1010]

I am using Excel 2002, and created a workbook where dollars and cents are
used. When I write the formula =sum(#,#,#) it calculates the result one cent
off the actual total. Like $2623.27 is shown and it should be $2628.28. Can
this be fixed?

[Ragdyer]

Check out John's web page on the subject:

http://www.mcgimpsey.com/excel/pennyoff.html
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"bjm1010" <bjm1010@discussions.microsoft.com> wrote in message
news:5A3F71C2-B3D3-4955-ACEB-CB36D4F3017B@microsoft.com...
> I am using Excel 2002, and created a workbook where dollars and cents are
> used. When I write the formula =sum(#,#,#) it calculates the result one
cent
> off the actual total. Like $2623.27 is shown and it should be $2628.28.
Can
> this be fixed?