On Tue, 01 Feb 2005 15:57:55 -0700, Andreas J. Guelzow <[EMAIL PROTECTED]> 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 _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
