Thread: rounding to nearest 0.5 in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default rounding to nearest 0.5 in excel
=ROUND(Value/0.5,0)*0.5


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"bigred" wrote in message
...
how do i round to the nearest 0.5


Reply With QuoteReply With Quote