Thread: how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0
=ROUND(A1*2,0)/2
or
=ROUND(A1/5,1)*5

Regards,
Bernd
Reply With QuoteReply With Quote