rounding off

This topic has 4 replies, 5 voices, and was last updated 14 years, 1 month ago by Mikel.

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

Author
Posts
December 18, 2006 at 10:46 am #45558

Khatri
★★★★★★★★★★
Participant
@Anil Include @Anil in your post and this person will
be notified via email.
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
December 18, 2006 at 10:56 am #149156

Monk
★★★★★★★★★★
Participant
@Monk Include @Monk in your post and this person will
be notified via email.
Why? What’s the purpose?
0
December 18, 2006 at 11:12 am #149157

Belas
★★★★★★★★★★
Participant
@Belas Include @Belas in your post and this person will
be notified via email.
with regards to maths, you can not do that type of rounding.
0
December 18, 2006 at 1:24 pm #149164

clb1
★★★★★★★★★★
Participant
@clb1 Include @clb1 in your post and this person will
be notified via email.
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
December 18, 2006 at 2:40 pm #149169

Mikel
★★★★★★★★★★
Member
@Stan Include @Stan in your post and this person will
be notified via email.
Yes, of course you can do it.
In Excel, the command is “ROUNDUP”.
0
Author
Posts