Excel is infamous for its incorrect roundings. Google "excel roundings quirks".

I don't know about crystal rep.


2012/11/29, Greg Graham <ggra...@cistercian.org>:
> Thank you to everyone who weighed in on the topic; the discussion has been
> very informative and interesting.
>
> I've decided to not do the rounding in Racket, but to store all of the
> digits in the database. The rounding will occur at the time of display by
> either Crystal Reports or Excel, which is what the current system does
> anyway. That way we won't see any unexpected changes in anyone's GPAs.
>
> Now, the unanswered question is why do Crystal Reports and Excel round 4.225
> to 4.23? I don't think I'll find as helpful of a forum to answer that
> question as I have found for Racket. Thanks again for being such a great
> community!
>
> -Greg
>
>
> ____________________
>   Racket Users list:
>   http://lists.racket-lang.org/users
>

-- 
Inviato dal mio dispositivo mobile
____________________
  Racket Users list:
  http://lists.racket-lang.org/users

Reply via email to