Say i got a figure 9.9218. If written "=floor(9.9218,0.0625)", the result i would get is 9.875. However, if the formula was written with the CEILING function, I would get 9.9375.

Now here's the fun part. Is it possible to combine the FLOOR and CEILING function codes into one complete function, where it could determine whether 9.9218 is closer to 9.9375 than 9.875?

The following was taken from my decimal equivalent chart, at spaces of .0156:
.875
.8906
.9062
.9218
.9375

*As seen here, .9218 is closer to .9375