Rounding to nearest number
 

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

Rounding to nearest number
 

Have you tried Excel help? Did it mention the ROUND() function?
--
David Biddulph

"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

Rounding to nearest number
 

=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