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