help :
need a formula for round , roundoff or roundup , if
eg:
99.763
99.722
99.82
99.716
i need ans as
99.765
99.720
99.82
99.715
roundoff must be to the nearest of 3rd decimal
help plzzzz
help :
need a formula for round , roundoff or roundup , if
eg:
99.763
99.722
99.82
99.716
i need ans as
99.765
99.720
99.82
99.715
roundoff must be to the nearest of 3rd decimal
help plzzzz
Last edited by mihir777; 03-12-2016 at 02:42 PM.
IF YOUR DATA STARTS FROM A1 use below formula
=FLOOR(A1+0.002,0.005)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Or try this: =MROUND(A1,0.005)
Or you can use
Formula:=ROUND(A1*200,0)/200
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks