View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_390_] Rick Rothstein \(MVP - VB\)[_390_] is offline
external usenet poster
 
Posts: 1
Default how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0

Make sure you have the Analysis ToolPak Add-In loaded...

=MROUND(A1,0.5)

Rick


"tiffa" wrote in message
...
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0