Tuesday, August 26, 2008

Error in Excel

I noted that 9*508697815467511(aka 9*5.08697815467511E14)=4578280339207599
but in Excel, it says 4578280339207600.

I want a refund!


J said...

You are right and Excel is wrong. Please present at the main cashier your proof of purchase and we shall refund you the 2.1842262288662692e-16 th of it. Please bring exact change.

Anonymous said...

I don't think Microsoft really cares about quants and scientists - I still can't plot in 3D or keep the elements in my graphs from resizing bizarrely when I copy and paste them, 12 years and 5 versions after I first wanted to.