Thread: correct to the nearest half
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default correct to the nearest half
Hi soorya,

You can also use =MROUND(A1,0.5)

You will need to have the Analysis Tool Pack installed in order
to use MROUND. See the help file for details on how to do
this.

HTH
Martin


Reply With QuoteReply With Quote