From what I read, it pretty much said that the computer can't fix it. I did
change my spreadsheet to precision as displayed, though, so that will at
least help when I add everything up. As far as using the ROUND function, I
don't think that will help, because I'm just using two decimals and it
automatically does that, right?

"JMB" wrote:

Look in help for the ROUND function

Also see link for discussion of rounding issues

http://www.cpearson.com/excel/rounding.htm


"Jaime" wrote:

I am figuring my payroll on an Excel spreadsheet. When I enter the formulas,
the values are sometimes off by a penny. On my calculator, I have it set to
5/4. How do I get my formulas to come out the same as the calculator?