| LARGE | The Kth largest value in a list or array of numbers. |
| LCM* | The least common multiple of integers. |
| LEFT | The first or left most character (or characters) in a text string. |
| LEN | The number of characters in a text string. |
| LINEST | The array of values for a straight line that best fits your data. |
| LN | The natural logarithm of a number. |
| LOG | The logarithm of a number to a given base. |
| LOG10 | The logarithm of a number to the base 10. |
| LOGEST | The array of values for an exponential curve that best fits your data. |
| LOGINV | The probability of getting greater than a particular value in a lognormal distribution. |
| LOGNORM.DIST | (2010 - LOGNORMDIST) The probability of getting exactly or less than a particular value in a lognormal distribution. |
| LOGNORM.INV | (2010 - LOGINV) The probability of getting greater than a particular value in a lognormal distribution. |
| LOGNORMDIST | (no cumulative) The probability of getting a particular value in a lognormal distribution. |
| LOOKUP | The value in a row (or column) that matches a value in a column (or row). |
| LOWER | The text string with all the characters converted to lower case. |