Ask Your Question

Revision history [back]

For exact financial calculation rounded properly to 2 decimals you always have to do the rounding yourself by using ROUND(...,2) function calls at appropriate places.

Either that, or you switch on the Tools->Options->Calc->Calculate "Precision as shown" option and format currency cells to 2 decimals. Which doesn't round intermediate results within a formula expression though, only the formula cell results that are passed on to other calculations as reference.

Effectively it's up to you and how complicated your calculations are and where they need rounding.