On 29 Aug 2005 09:33:26 -0700, "Harlan Grove" wrote:

Mikus wrote...
Is it possible to construct function that rounds down if 5 is met

For example:
1) 2.455 = 2.45
2) 2.454 = 2.45
3) 2.456 = 2.46
...

Simplest way would be

=ROUND(x-0.0009,2)

Given OP's specifications, how should

2.4559

round?


--ron