Thread: rounding to nearest 0.5 in excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bigred
 
Posts: n/a
Default rounding to nearest 0.5 in excel
works great
thanks

"Domenic" wrote:

Try...

=ROUND(A1/0.5,0)*0.5

Hope this helps!

In article ,
bigred wrote:

how do i round to the nearest 0.5

Reply With QuoteReply With Quote