Rounding to the nearest cent...currency values

[Mr Mark]

I am having trouble getting either a product or sum to round to the nearest
cent.

How do I do this?

Example 6015.54x1.4=8421.76, However when I do this in excel, it ends up
being 8421.75 for some reason.

Or if I choose to add 6015.54 and 2406.22 (the latter a result of
multiplying the former by .4) it still gives me 8421.75...the actual
calculation works out to 8421.756, so obviously it is just dropping the last
number (or rounding it down to the nearest fifth one hundredth?)...I'd prefer
seeing as how I am working with currency that it rounded the final number
appropriately.

Help?

 

[Niek Otten]

Read this:

http://www.mcgimpsey.com/excel/pennyoff.html

 

[JE McGimpsey]

Unless you have the option "Precision as displayed" selected, XL
calculates based on the stored values in the cells, not the displayed
values.

If your multiplicand or multiplier are calculated, they're probably not
exactly 6015.54 or 1.4. You can expand the number of decimal places to
find out.

Working with currency should always be done with care to round
appropriately at each stage. As long as you're using floating point
math, there's no general way to prevent rounding errors at the end of a
string of calculations.

See http://www.mcgimpsey.com/excel/pennyoff.html

for more...

 

[Mr Mark]

Unfortunately it would appear I need the precision as displayed to be an
option for individual cells...thanks for the clarification at any rate!