Thread
:
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_390_]
external usenet poster
Posts: 1
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
Reply With Quote
Rick Rothstein \(MVP - VB\)[_390_]
View Public Profile
Find all posts by Rick Rothstein \(MVP - VB\)[_390_]