Hi,

Is there a way to control how Excel interprets rounding? In 2 different documents, it comes to different results ( by a penny ) so it throws off some other calculations

How does Excel XP usually round numbers in calculations?

thanks!

After a little time, i found out the ROUND() function will do just fine. Hadnt thought of using it... too obvious..

Cheers!

Glad you found it.

Also, keep in mind that MS Excel rounds differently than mathematical rounding that some of us learned 45+ years ago.