Alphabetical List of Excel 2010 Functions (continued)
Table C-2. Alphabetical List of Excel 2010 Functions (continued)
Function |
Description |
---|---|
LARGE |
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. |
LCM |
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. |
LEFT |
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.