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

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top