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.
NOT
Returns the opposite of the boolean value of a specified expression.
FACT
Returns the factorial of a number.
MOD
Returns the remainder from a division.
RAND
Returns a random number that is greater than or equal to 0 and less than 1.
SQRTPI
Returns the square root of a number value after it has been multiplied by π (pi).
SUMXMY2
Returns the sum of the squares of the differences between corresponding values in two collections.
HLOOKUP
Returns a value from a collection of rows by using the top row of values to pick a column and a row number to pick a row within that column.
ROW
Returns the row number of the row containing a specified cell.
AVERAGEA
Returns the average (arithmetic mean) of a set containing any value.
CONFIDENCE
Returns a value for creating a statistical confidence interval for a sample from a population with a known standard deviation.
DEVSQ
Returns the sum of the squares of deviations of a set of numbers from their average (arithmetic mean).
GEOMEAN
Returns the geometric mean.
MAXIFS
Returns the largest numeric value in a range of cells, determined by a set of criteria.
NORMSDIST
Returns the standard normal distribution.
SLOPE
Returns the slope of the best-fit line for the set using linear regression analysis.
TTEST
Returns the probability associated with a student’s t-test, based on the t-distribution function.
CODE
Returns the decimal Unicode number of the first character in a specified string.
LEN
Returns the number of characters in a string value.
RIGHT
Returns a string value consisting of the specified number of characters from the right end of a given string value.
UPPER
Returns a string value that is entirely uppercase, regardless of the case of the characters in the specified string value.
COS
Returns the cosine of an angle that is expressed in radians.
Use string operators and wildcardsReview formula errors and follow best practices