Rounding to nearest number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=ROUND(A1,0)

--
HTH

Bob

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