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
Please Login or Register to view this content.
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:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks