Thread: round to ,5
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jean-Paul De Winter Jean-Paul De Winter is offline
external usenet poster
  
Posts: 46
Default round to ,5
Hi,
When a value is 60.12 I want it to be rounded to 60.00
a value 60.45 to 60.50
a value 60.57 to 60.50
a value 60.85 to 61.00
does somebody know s how?
Thanks
JP


Reply With QuoteReply With Quote