Hi

Obviously it was too early morning for me :-))


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Yes, I think you *are* confused, Arvi. With 1.37 in A1, =ROUND(A1,2) will
leave it at 1.37 (with 2 decimal places displayed), not round to 1.50.
--
David Biddulph

"Arvi Laanemets" wrote in message
...
Hi

??? (confused)
With number in A1
=ROUND(A1,2)

... Or have they implemented the bankers rounding for worksheetfunction
too in later versions (I use Excel2000)?
--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )

"Thomas Prescott" <Thomas wrote in
message ...
Round the number range from 1.01 through 1.49 to 1.50; and to round 1.50
through 1.99 to 2.00