Formula field - anyway to round up/down to nearest integer?

Formula field - anyway to round up/down to nearest integer?

Hi all

I'm sure I'm missing something, but how can I return the nearest integer i.e. 5.2 = 5, 5.7 = 6?

Ceil and Floor round up or down... not to the nearest.

Thanks

BUMP

Any ideas on this? This cannot be too difficult surely?

Just to clarify, this is what I need to do:  http://en.wikipedia.org/wiki/Nearest_integer_function

BUMP!! If this isn't possible - please let me know?