Spreadsheets and precision?

[Lee A. Newcomb]

This is where reading the doc. helps (marks added) :)

QUOTIENT
This function is only available if Analysis AddIn is installed. 
Returns the _integer_ result of a division operation.

Syntax
QUOTIENT(Numerator;Denominator)

Example
=QUOTIENT(11;3) returns 3. _The remainder of 2 is omitted._

> 
> 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
> _______________________________________________
> gnhlug-discuss mailing list
> gnhlug-discuss at mail.gnhlug.org
> http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss/
>