Rounding up/down

[Chutney]

Hey

I'm having a problem finding a solution to rounding up or down.

Basically, I calculate values and if they fall below 0.5 of a number i wish to round them down, if they go abvoe 0.5 of a number then to round up.

In cell A14 i have the Round Up function but I wish to have a funciton that either rounds up or down depneding on what the value in B14 is, in this instance i wish it to Round Down at it is below 0.5 of the number (4.32)

Hope that makes sense and you can help?!

[quekbc]

I think what you need is the ROUND function. (not ROUNDUP nor ROUNDDOWN).