Re: rounding problems

Can you be more explicit about the rounding that's wrong in Excel?
Are you talking about the ....n5 round-up to n+1 that Excel uses
vs. ....n5 round-to-even n (sometimes called Banker's Rounding)?

-- Andy

On May 12, 2008, at 1:48 PM, Justin wrote:

> I have very annoying problem that i would like to get a work
> around  in place so the data entry people stop trying to kill me.
>
> Normally people give quotes out of the price book which was done in
> Excel like 15 years ago and just has been updated over the years.
> the problem is excel is rounding differently than postgres 8.3.1
> (Yes i know Excel rounds incorrectly) which results in normally
> being pennies off but on large qty its usually under a few bucks on
> the postgresql side.   We internally don't  care but those annoying
> customers scream bloody murder if the quote don't agree to the
> penny on the invoice  Even when its to their benefit .
> Has anyone every got  Postgresql and Excel to agree on rounding.
> I have checked excel up to Office XP and its still wrong.  (open
> office was looked out and the people  screamed really loudly NO )
>
> Another annoying thing is the calculators on everyones desk get it
> wrong to if the rounding is turned to 2 places.
> Although my TI-89, and TI-36X calculators agree perfectly with
> postgresql .
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general