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@[EMAIL PROTECTED]
)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general