Results 1 to 3 of 3

Thread: Rounding issues

  1. #1
    Join Date
    Nov 2003
    Posts
    150

    Unanswered: Rounding issues

    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!
    Cheers!

    Mr.Crud

    There are 10 kinds of people, ones that understand digital, others that dont

  2. #2
    Join Date
    Nov 2003
    Posts
    150
    After a little time, i found out the ROUND() function will do just fine. Hadnt thought of using it... too obvious..

    Cheers!
    Cheers!

    Mr.Crud

    There are 10 kinds of people, ones that understand digital, others that dont

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    Glad you found it.

    Also, keep in mind that MS Excel rounds differently than mathematical rounding that some of us learned 45+ years ago.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •