[Solved] QOTIENT formula isn't working

[B-rad]

I'm trying to do a simple Miles/gal formula to track my car's gas mileage. The simple equations work like 200/10, but if I try to be more accurate like 210.7/13.2, I get a whole number. The help page says that I need Analysis Add-in, but I can't find it on the website. I reformated all the cells to 2 decimal places, but it's just more zeros.

I have the 2.1 version, and it seems like it should be an easy fix, but I just can't figure it out.

[kingfisher]

Analysis add-in is part of the standard installation.

What exactly are you doing? Do you have the formula =210.7/13.2 in a cell? The result I get displays as 15.96.

[acknak]

You read the help, where it says you need the analysis add-on, but it seems you missed the important little tidbit just above it:

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

The "integer part" will always be a whole number.

Instead of the QUOTIENT function, just use the division operator: /

[TerryE]

The help page says that I need Analysis Add-in.

Tee-Hee. What this really reveals this that the Calc Function Implementation was re-engineered from the Excel (97) function definitions. The Excel Help says

QUOTIENT
Returns the integer portion of a division. Use this function when you want to discard the remainder of a division.
If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.

and Excel does have an Analysis Add-in.

The OOo help says

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

Well actually as Acknak says, there is no Analysis AddIn in OOo; its standard.

Another good example of this is the Help for RAND(). It again mirrors Excel 97, but the implementation is different.

[B-rad]

I got it! Thanks for the help. I'm a little rusty with the excel, and some of the equations needed a direct reference before I could get it to work(I'm not sure why), but I used =$A3/$B3 and it's working perfectly!