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