=ROUND(A1,0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Wanna Learn" wrote in message
...
Hello I need to round to the nearest number, that is if the number is 12.4
it
should round to 12 and if the number is 12.6 is should round to 13. I
have
tried round up nd round down functions and of course they do not work.
what is the right formula thanks