Generally 1.4 is rounded rounded down and 1.5 and above is rounded up.
=Round(a1,0) will behave as above. If you want to round
down at 1.5 you need to apply as
=Round(a1-1,0)
Elioch
--
eliochPosted from http://www.pcreview.co.uk/ newsgroup access
Bookmarks