LinkBack URL
About LinkBacks
You can use MROUND function
=MROUND(A1,0.05)
In versions of Excel 2003 or before you need to activate Analysis ToolPak add-in for MROUND so an alternative is
=ROUND(A1*2,1)/2
where your number is in A1
You can use MROUND function
=MROUND(A1,0.05)
In versions of Excel 2003 or before you need to activate Analysis ToolPak add-in for MROUND so an alternative is
=ROUND(A1*2,1)/2
where your number is in A1
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks