B-rad wrote: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.

Ubuntu 11.04-x64 + LibreOffice 3 and MS free except the boss's Notebook which runs XP + OOo 3.3.