View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo
 
Posts: n/a
Default Rounding numbers

Hi Nico,

use =round(a2,0)

note the "0", is how many decimals you want

hope this helps
Regards from Brazil
Marcelo


"nicojr" escreveu:

Hey,

I am a student and I am trying to figure out how I can round some grades
properly.
My question is: how do I make a formula that rounds numbers to whole
numbers, and if the decimal is .5 or higher, then round up to whole number,
if the decimal is lower than .5 round down to whole number. For example:

5.5 would become 6
5.4 would become 5

Thanks!