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
 
Have you tried Excel help? Did it mention the ROUND() function?
 
=ROUND(A1,0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding up to nearest specified whole number 1
round up to nearest 50p 1
Average rounded to nearest 0.50 4
rounding down to nearest 1/32 3
advice on rounding or ceilng a 24 hour time value 3
Round formula 1
Round Down to the nearest multiple 2
Round time up to nearest :15 2

Back
Top