No, when rounding a value the next number in the figure is considered,
in this case, the 4th decimal (5). If that number is less than 5, then
the result is rounded down, if it's 5 or more, then it's rounded up. So
1.2554 becomes 1.255 but 1.2555 becomes 1.256.

If you want to keep the value without the rounding, use TRUNC instead:

TRUNC(1000.2555-999,3) returns 1.255

Cheers.


liaosheng wrote:
ROUND(1000.2555-999,3)=1.255
the correct result is 1.256,why?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions