Actually, the OP is correct is certain jurisdictions. I believe the legal
way to round in Australia is has OP states
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ron Coderre" wrote in message
...
Time to check this website:

http://www.gomath.com/htdocs/lesson/round_lesson1.htm


***********
Regards,
Ron

XL2002, WinXP-Pro


"HAH" wrote:

The proper way to round a number ending in 5 with nothing past it to the
previous digit is to round that digit to the nearest even number. Excel
doesn't do that; it uses the obsolete theory that always rounds up so
2.5,
which should round to 2, is being rounded to 3. This means that over
time,
in financial uses, money will eventually be over-reported, and in
scientific
uses, the amount of energy and matter will eventually be over-reported.
Current rounding theory is to round to the nearest even number so that,
statistically, half the time numbers will be rounded up and half the time
they will be rounded down, thus eliminating artificially high compounded
results.

----------------
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...lic.excel.misc