View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
UBR362 UBR362 is offline
external usenet poster
 
Posts: 6
Default Rounding in Excel

Want to know if this is even possible. I need excel to round numbers down
that are .50 and lower and up for numbers that are .51 and higher. Excel
tends to round up when numbers are .50 and higher.
So for instance
10.51 and higher would need to round up to 11 whereas
10.50 and lower would round down 10.
I am very unfamiliar with formulas so if you can explain to me what to do
step by step I would appreciate it.

Thanks