I am working with spreadsheets in Excel 2000 and Excel 2002, and find that
although I'm using the same formulas throughout differing cells in the
spreadsheet, some cells round the results correctly and some do not. Has
anyone encountered this problem, and if so, does anyone know of a fix for it?
The data I'm working with rounds answers that result in currency (dollars
and cents) and it's imperative that I get the numbers to round correctly to
the next penny following the standard rule of up for .5 cents or more and
down for .4 cents or less.

I have even tried copying and pasting the formulas from cells that are
rounding the results correctly into the cells that are rounding incorrectly
to no avail. No matter what I've tried, some cells will round correctly (in
both up or down directions) and some will not (they truncate the answer
instead of rounding it).

Thanks in advance for any help!