# RE: Rounding??

• From: "Alves, Carlos Alberto - Coelce" <calves coelce com br>
• To: Morten Welinder <terra diku dk>
• Cc: kjetilho ifi uio no, gnumeric-list gnome org
• Subject: RE: Rounding??
• Date: Tue, 12 Jun 2001 18:50:47 -0300

Title: RE: Rounding??

Ok, I think it is a Math question!
Rounding operation works for the next decimal point above or below; depending on the last decimal value is less or greater than 5 ( if it is equal, than rounding should truncate that decimal).

So,
3.15, 3.25, 3.35, 3.45, 3.55, 3.65, 3.75, 3.85, 3.95, 4.05, 4.15
should gives me
3.1,  3.2,  3.3,  3.4,  3.5,  3.6,  3.7,  3.8,  4.0,  4.0,  4.2
Although we also have binary questions, there should be a mechanism to deal with decimal and bynary convertion. 'though I don't know if it is possible in pratice.

Carlos Alberto
COELCE/DPRON-Departamento de Projetos e Obras Norte
Fone: 677- 2228
e-mail: calves coelce com br
(___)
< o o >
\ ^ /
(")

-----Original Message-----
From: Morten Welinder [mailto:terra diku dk]
Sent: Tuesday, June 12, 2001 5:59 PM
To: nj lee plumtree co nz
Cc: kjetilho ifi uio no; gnumeric-list gnome org
Subject: Re: Rounding??

Gnumeric seems to do all sorts of things I cant quite figure out.

The _important_ thing is to have _consistent_ behaviour.

At the moment

3.15, 3.25, 3.35, 3.45, 3.55, 3.65, 3.75, 3.85, 3.95, 4.05, 4.15
gives me
3.1,  3.2,  3.3,  3.5,  3.5,  3.6,  3.7,  3.8,  4.0,  4.0,  4.2

which just seems confusing.  Why are 3.4 and 3.9 missed??

Think binary.

Gnumeric does not know what 3.45 is.  It has some approximation, which
may be ever so slightly bigger or ever so slightly smaller.  (Well,
it's more like "i386" than "gnumeric" that does this, but all other
processors in common use these days also use a binary representation.)

Morten

_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]