Re: PI()

On Tue, 01 Feb 2005 15:57:55 -0700, Andreas J. Guelzow
<aguelzow taliesin ca> wrote:
In view of CEILING(-2.5) == -3 and FLOOR(-2.5) == -2

CEIL is the sane version of CEILING.
INT is the sane version of FLOOR.

The mistake here is to try to make sense of this.  If the rounding function
group in Excel had been designed with just one iota of sense we would
not have this mess.  As it is, we have.  The best we can do is to offer
our sincere apologies in the help text (after we reorganize all the help

could we change
PI() to evaluate to 4. It would make lots of calculations much simpler!

Of course.


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