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