Thread: Excel. How to round a number to nearest half number?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer bpeltzer is offline
external usenet poster
  
Posts: 171
Default Excel. How to round a number to nearest half number?
With the Analysis Tool Pak add in you can use =mround(A1,0.5).
Otherwise, I'd double the number, round, then divide by two: =round(2*A1,0)/2

"HaraldS" wrote:

Not always up or always down!
Reply With QuoteReply With Quote