Returns a date that is the last day of the month some number of months before or after a given date.
Converts separate values for hours, minutes, and seconds into a date/time value.
Converts a duration value to a number of hours.
Returns the integer Bessel function Yn(x).
Converts a number from one measurement system to its corresponding value in another measurement system.
Converts a hexadecimal number to the corresponding decimal number.
Returns the modified weighted average of the present value of the cash flows for an assumed par value of $100.
Returns the price of a given currency value in a different currency, using exchange rate data from the previous market day’s close, retrieved remotely via the Internet.
Returns the internal rate of return for an investment that is based on a series of potentially irregular cash flows (payments that do not need to be a constant amount) that occur at regular time intervals.
Returns the price of a security that is sold at a discount to redemption value and does not pay interest per $100 of redemption (par) value.
Returns the amount of depreciation of an asset over a chosen time interval, based on a specified depreciation rate.
Returns a value that you specify if a given value evaluates to an error; otherwise it returns the given value.
Returns the boolean value TRUE if any argument is true; otherwise it returns the boolean value FALSE.
Returns the double factorial of a number.
Rounds a number to the nearest multiple of a specified factor.
Returns a random integer within the specified range.
Returns a subtotal for a range of cells.
Truncates a number to the specified number of digits.
Reference functions
The reference functions help you find data within tables and retrieve data from cells.
Creates a clickable link that opens a webpage or new email message. | |
Returns the number of rows included in a specified collection of cells. | |
Returns the average (arithmetic mean) of the cells in a set that meet a given condition. | |
Returns the correlation between two sets using linear regression analysis. | |
Returns the exponential distribution of the specified form. | |
Returns the harmonic mean. | |
Returns the median value of a set of numeric values. The median is the value where half the values in the set are less than the median and half are greater. | |
Returns the inverse of the cumulative standard normal distribution. | |
Returns the nth-smallest value within a set of values. The smallest value is ranked number 1. | |
Returns the sample (unbiased) variance—a measure of dispersion—of a set of numeric values. | |
Joins (concatenates) values or the contents of cell ranges or strings. | |
Returns a string value that is entirely lowercase, regardless of the case of the characters in the specified string value. | |
Returns the starting position of one string value within another, ignoring case and allowing wildcards. | |
Returns a number value, even if the argument is formatted as text. This function is included for compatibility with tables imported from other spreadsheet apps. |
Trigonometric functions
The trigonometric functions help you work with angles and their components.
Returns the hyperbolic cosine of a number. | |
Tips for selecting financial functionsReview formula errors and follow best practices |