Difference between revisions of "Documentation/How Tos/Calc: LCM ADD function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(See also:)
m (Robot: Automated text replacement %s)
Line 19: Line 19:
 
: where B1 and C1 contain <tt>'''6'''</tt> and  <tt>'''3'''</tt> respectively, returns <tt>'''6'''</tt>.
 
: where B1 and C1 contain <tt>'''6'''</tt> and  <tt>'''3'''</tt> respectively, returns <tt>'''6'''</tt>.
  
=== See also: ===
+
{{Documentation/SeeAlso|
'''[[Documentation/How_Tos/Calc: LCM function|LCM]]''',
+
* [[Documentation/How_Tos/Calc: LCM function|LCM]]
'''[[Documentation/How_Tos/Calc: GCD function|GCD]]''',
+
* [[Documentation/How_Tos/Calc: GCD function|GCD]]
'''[[Documentation/How_Tos/Calc: GCD_ADD function|GCD_ADD]]'''
+
* [[Documentation/How_Tos/Calc: GCD_ADD function|GCD_ADD]]'''
  
'''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]'''
+
* [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]'''
  
[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
+
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]
+
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
  
 
=== Issues: ===
 
=== Issues: ===
 
The ODFF international standardisation of the <tt>'''LCM'''</tt> / <tt>'''LCM_ADD'''</tt> functions will allow both functions to produce precisely the same results.
 
The ODFF international standardisation of the <tt>'''LCM'''</tt> / <tt>'''LCM_ADD'''</tt> functions will allow both functions to produce precisely the same results.

Revision as of 14:01, 25 February 2009


LCM_ADD

Returns the least common multiple of one or more integers.

This function is only available if the Analysis AddIn is installed.

Syntax:

LCM_ADD(integer1; integer2; ... integer30)

integer1 to integer30 are up to 30 integers or ranges of integers whose least common multiple is to be calculated.
The least common multiple (or lowest common multiple) is the smallest positive integer that is a multiple of all the given numbers.

Example:

LCM_ADD(4; 6)

returns 12, which is the smallest positive integer that is a multiple of 4 (12=4*3) and 6 (12=6*2).

LCM_ADD(B1:C1)

where B1 and C1 contain 6 and 3 respectively, returns 6.

Template:Documentation/SeeAlso

Issues:

The ODFF international standardisation of the LCM / LCM_ADD functions will allow both functions to produce precisely the same results.

Personal tools