Difference between revisions of "Documentation/How Tos/Calc: QUOTIENT function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
| Line 3: | Line 3: | ||
== QUOTIENT == | == QUOTIENT == | ||
Returns the integer part of a division operation. | Returns the integer part of a division operation. | ||
| − | |||
This function is only available if the '''Analysis AddIn''' is installed. | This function is only available if the '''Analysis AddIn''' is installed. | ||
| − | |||
=== Syntax: === | === Syntax: === | ||
| Line 13: | Line 11: | ||
: <tt>'''QUOTIENT'''</tt> is equivalent to <tt>'''INT(numerator/denominator)'''</tt>, except that it may report errors with different error codes. | : <tt>'''QUOTIENT'''</tt> is equivalent to <tt>'''INT(numerator/denominator)'''</tt>, except that it may report errors with different error codes. | ||
| − | |||
=== Example: === | === Example: === | ||
<tt>'''QUOTIENT(11; 3)'''</tt> | <tt>'''QUOTIENT(11; 3)'''</tt> | ||
: returns <tt>'''3'''</tt>, the integer part of <tt>'''11'''</tt> divided by <tt>'''3'''</tt>. The remainder of <tt>'''2'''</tt> is lost. | : returns <tt>'''3'''</tt>, the integer part of <tt>'''11'''</tt> divided by <tt>'''3'''</tt>. The remainder of <tt>'''2'''</tt> is lost. | ||
| − | |||
=== See also: === | === See also: === | ||
Revision as of 06:29, 2 March 2008
QUOTIENT
Returns the integer part of a division operation.
This function is only available if the Analysis AddIn is installed.
Syntax:
QUOTIENT(numerator; denominator)
- returns the integer part of numerator divided by denominator.
- QUOTIENT is equivalent to INT(numerator/denominator), except that it may report errors with different error codes.
Example:
QUOTIENT(11; 3)
- returns 3, the integer part of 11 divided by 3. The remainder of 2 is lost.
