iSixSigma

rounding off

Six Sigma – iSixSigma Forums Old Forums General rounding off

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #45558

    Khatri
    Participant

    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 ?
     

    0
    #149156

    Monk
    Participant

    Why? What’s the purpose?

    0
    #149157

    Belas
    Participant

    with regards to maths, you can not do that type of rounding.

    0
    #149164

    clb1
    Participant

    Anything 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.

    0
    #149169

    Mikel
    Member

    Yes, of course you can do it. 
    In Excel, the command is “ROUNDUP”.

    0
Viewing 5 posts - 1 through 5 (of 5 total)

The forum ‘General’ is closed to new topics and replies.