Returns a date that is the last day of the month some number of months before or after a given date.
TIME
Converts separate values for hours, minutes and seconds into a date/time value.
DUR2HOURS
Converts a duration value to a number of hours.
BESSELY
Returns the integer Bessel function Yn(x).
CONVERT
Converts a number from one measurement system to its corresponding value in another measurement system.
HEX2DEC
Converts a hexadecimal number to the corresponding decimal number.
BONDMDURATION
Returns the modified weighted average of the present value of the cash flows for an assumed par value of £100.
CURRENCYCONVERT
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.
IRR
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.
PRICEDISC
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.
VDB
Returns the amount of depreciation of an asset over a chosen time interval, based on a specified depreciation rate.
IFERROR
Returns a value that you specify if a given value evaluates to an error; otherwise it returns the given value.
OR
Returns the boolean value TRUE if any argument is true; otherwise it returns the boolean value FALSE.
FACTDOUBLE
Returns the double factorial of a number.
MROUND
Rounds a number to the nearest multiple of a specified factor.
RANDBETWEEN
Returns a random integer within the specified range.
SUBTOTAL
Returns a subtotal for a range of cells.
TRUNC
Truncates a number to the specified number of digits.
The reference functions help you find data within tables and retrieve data from cells.
HYPERLINK
Creates a clickable link that opens a web page or new email message.
ROWS
Returns the number of rows included in a specified collection of cells.
AVERAGEIF
Returns the average (arithmetic mean) of the cells in a set that meet a given condition.
CORREL
Returns the correlation between two sets using linear regression analysis.
EXPONDIST
Returns the exponential distribution of the specified form.
HARMEAN
Returns the harmonic mean.
MEDIAN
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.
NORMSINV
Returns the inverse of the cumulative standard normal distribution.
SMALL
Returns the nth-smallest value within a set of values. The smallest value is ranked number 1.
VAR
Returns the sample (unbiased) variance — a measure of dispersion — of a set of numeric values.
CONCAT
Joins (concatenates) values or the contents of cell ranges or strings.
LOWER
Returns a string value that is entirely lowercase, regardless of the case of the characters in the specified string value.
SEARCH
Returns the starting position of one string value within another, ignoring case and allowing wildcards.
VALUE
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.
The trigonometric functions help you work with angles and their components.
COSH
Returns the hyperbolic cosine of a number.
Tips for selecting financial functionsReview formula errors and follow best practices