Alphabetical List of Excel 2010 Functions (continued)

Table C-2. Alphabetical List of Excel 2010 Functions (continued)




Returns the kth largest value in an input range. Takes the form =LARGE(array, k), where k is the position from the largest value in array you want to find. See Using Functions That Analyze Rank and Percentile on page 604.


Returns the least common multiple of integers (the smallest positive integer that is a multiple of all arguments). Takes the form =LCM(number1, number2, …), and accepts up to 29 numeric integer arguments.


Returns the leftmost series of characters from a string. Takes the form =LEFT(text, num_chars), where num_chars indicates how many characters you want to extract ...

Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.