Because it is rounding to the nearest .00025, not as per your actual criteria.

HTH,
Bernie
MS Excel MVP


It works great however, when i used the function below for values such as
1.52866, 1.52821, 1.52775, 1.52730 etc. the result is not correct. Any idea
why it won't work on these?