Re: PI()

[Morten Welinder <mwelinder gmail com>]

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
texts).

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

Of course.

Morten