Thread: how do i round to the nearest 0.5 in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default how do i round to the nearest 0.5 in excel
One way:
=ROUND(A1*2,0)/2



bigred wrote:

--

Dave Peterson
Reply With QuoteReply With Quote