Spreadsheets and precision?

Paul Lussier p.lussier at comcast.net
Sun Sep 9 12:42:46 EDT 2007


Hi All,

Does anyone know how to get any kind of decent precision out of either
oocalc or gnumeric?

I'm trying a simple formula:
  =QUOTIENT(3329.10;10)

Which leads to the answer 332.00 rather 332.90.  Which is really just
wrong, especially since what I *really* want to do involves numbers
requiring much higher precision:

  =QUOTIENT(301.52;3329.10)

Should not yield an answer of 0.00 :)

I will admit to being a complete and utter idiot when it comes to
spreadsheets, but I tried the obvios of increasing the cell format to
go out to several decimal places.

Any ideas?

Thanks.
-- 
Seeya,
Paul


More information about the gnhlug-discuss mailing list