rounding off
Six Sigma – iSixSigma › Forums › Old Forums › General › rounding off
- This topic has 4 replies, 5 voices, and was last updated 15 years, 8 months ago by
Mikel.
-
AuthorPosts
-
December 18, 2006 at 10:46 am #45558
I want to round off the figures as follows
if it is 1.1,it should be 2, if it is 1.2 or 1.3 etc to 2 just like 2.1 to 3, 2.3 etc. to 3 like that.
is it possible ?
0December 18, 2006 at 10:56 am #149156Why? What’s the purpose?
0December 18, 2006 at 11:12 am #149157with regards to maths, you can not do that type of rounding.
0December 18, 2006 at 1:24 pm #149164Anything is possible but the big question should be – is it reasonable? There various rules for rounding. The one I was taught lo these many years ago is
if it is < X.5 you round down to X.
if it is > X.5 you round up to X+1
if it is = X.5 and X is even you round down to X and if X is odd you round up to X+1.
I’m sure there are others who can give you empirical rules that are similar.0December 18, 2006 at 2:40 pm #149169Yes, of course you can do it.
In Excel, the command is “ROUNDUP”.0 -
AuthorPosts
The forum ‘General’ is closed to new topics and replies.