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

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!