Results 1 to 4 of 4

Round function returns different values for same calculated input.

Threaded View

  1. #1
    Registered User
    Join Date
    06-16-2011
    Location
    NC, USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Round function returns different values for same calculated input.

    (A worksheet illustrating my issue is attached.)

    I've got 3 formulas that calculate to the same value (-0.05)

    = 58.1 - 58.15
    = 58.4 - 58.45
    = 64.4 - 64.45

    Why, then, does the round function return different values?

    =ROUND(58-58.05,1) returns 0
    =ROUND(58.4-58.45,1) returns -0.1
    =ROUND(64.4-64.45,1) returns 0

    Is there some logic at work here? (Maybe I'm searching the wrong keywords, but I'm stumped.) Thanks.
    Attached Files Attached Files
    Last edited by Kris Kohuth; 06-23-2011 at 11:06 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1