Returns a date/time value for a given date string. This function is provided for compatibility with other spreadsheet apps.
EDATE
Returns a date that is some number of months before or after a given date.
MINUTE
Returns the minutes for a given date/time value.
NOW
Returns a date/time value based on the current time shown on your computer’s clock.
TODAY
Returns the current date based on your computer’s clock. The time is set to 12:00 a.m.
YEAR
Returns the year for a given date/time value.
DUR2MILLISECONDS
Converts a duration value to a number of milliseconds.
DURATION
Combines separate values for weeks, days, hours, minutes, seconds, and milliseconds and returns a duration value.
BESSELY
Returns the integer Bessel function Yn(x).
BITAND
Returns the bitwise AND of two numbers.
BITRSHIFT
Returns the bitwise RSHIFT of two numbers.
DEC2OCT
Converts a decimal number to the corresponding octal number.
GESTEP
Determines if one value is greater than or exactly equal to another value. This function uses exact equality. By comparison, the = comparison operator uses string-based equality.
NUMTOBASE
Converts a number from base 10 into a number in the specified base.
ACCRINT
Returns the accrued interest on a security that pays periodic interest. The amount returned is the total interest accrued since the issue date, not the amount accrued since the last coupon payment.
COUPDAYBS
Returns the number of days between the beginning of the coupon period in which settlement occurs and the settlement date.
CUMIPMT
Returns the total interest included in loan or annuity payments over a chosen time interval based on fixed periodic payments and a fixed interest rate.
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.
DISC
Returns the annual discount rate of a security that pays no interest and is sold at a discount to its redemption value.
IPMT
Returns the interest portion of a specified loan or annuity payment based on fixed, periodic payments and a fixed interest rate.
NOMINAL
Returns the nominal annual interest rate from the effective annual interest rate based on the number of compounding periods per year.
PPMT
Returns the principal portion of a specified loan or annuity payment based on fixed periodic payments and a fixed interest rate.
PV
Returns the present value of an investment or annuity based on a series of regular periodic cash flows (payments of a constant amount and all cash flows at constant intervals) and a fixed interest rate.
STOCK
Returns data from the previous market day’s close about a given stock, retrieved remotely via the Internet.
XIRR
Returns the internal rate of return for an investment that is based on a series of irregularly spaced cash flows.
YIELDMAT
Returns the effective annual interest rate for a security that only pays interest at maturity.
The logical and information functions help you evaluate the contents of cells and help to determine how to work with cell contents or formula results.
IFERROR
Returns a value that you specify if a given value evaluates to an error; otherwise it returns the given value.
ISEVEN
Returns the boolean value TRUE if the given number is even (leaves no remainder when divided by 2); otherwise it returns the boolean value FALSE.
NOT
Returns the opposite of the boolean value of a specified expression.
ABS
Returns the absolute value of a number or duration.
EXP
Returns e (the base of natural logarithms) raised to the specified power.
GCD
Returns the greatest common divisor of a collection of number values.
LOG
Returns the logarithm of a number using a specified base.
MULTINOMIAL
Returns the closed form of the multinomial coefficient of the given numbers.
POWER
Returns a number raised to a power.
RANDBETWEEN
Returns a random integer within the specified range.
ROUNDUP
Returns a number rounded away from 0 (rounded up) to the specified number of places.
SQRTPI
Returns the square root of a number value after it has been multiplied by π (pi).
SUMIFS
Returns the sum of the cells in a collection where the test values meet the given conditions.
SUMX2PY2
Returns the sum of the squares of corresponding values in two collections.
AREAS
Returns the number of ranges the function references.
FORMULATEXT
Returns a formula as a text string.
INDEX
Returns the value in the cell located at the intersection of the specified row and column within a collection of cells or from an array returned by an array function.
MATCH
Returns the position of a value within a collection.
ROWS
Returns the number of rows included in a specified collection of cells.
XLOOKUP
Searches a range for a specified value and returns the value from the same row in another column.
AVERAGEA
Returns the average (arithmetic mean) of a set containing any value.
BETAINV
Returns the inverse of the given cumulative beta distribution probability value.
CHITEST
Returns the value from the chi-square distribution for the given data.
COUNTA
Returns the number of its arguments that are not empty.
COVAR
Returns the covariance of two sets of number values.
FDIST
Returns the F probability distribution.
GAMMADIST
Returns the gamma distribution in the specified form.
HARMEAN
Returns the harmonic mean.
LOGINV
Returns the inverse of the log-normal cumulative distribution function of x.
MAXIFS
Returns the largest numeric value in a range of cells, determined by a set of criteria.
MINIFS
Returns the smallest numeric value in a range of cells, determined by a set of criteria.
NORMINV
Returns the inverse of the cumulative normal distribution.
PERCENTRANK
Returns the rank of a value within a set of numeric values as a percentage of the collection.
QUARTILE
Returns the value for the specified quartile from a given set of numbers.
STANDARDIZE
Returns a normalized value from a distribution characterized by a given mean and standard deviation.
STDEVPA
Returns the standard deviation—a measure of dispersion—of a set of any values, based on the population (true) variance.
VAR
Returns the sample (unbiased) variance—a measure of dispersion—of a set of numeric values.
WEIBULL
Returns the Weibull distribution. The Weibull distribution is one of the continuous probability distributions.
CODE
Returns the decimal Unicode number of the first character in a specified string.
DOLLAR
Returns a string formatted as currency from a given number value.
LEFT
Returns a string value consisting of the specified number of characters from the left end of a given string value.
PLAINTEXT
Returns a string value stripped of any rich text attributes in the input value.
REPLACE
Returns a string value where a specified number of characters of a given string value have been replaced with a new string value.
SUBSTITUTE
Returns a string value where the specified characters of a given string value have been replaced with a new string value.
TEXTBETWEEN
Returns a string value consisting of all characters that appear between two given substrings in the original string value.
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.
ASINH
Returns the inverse hyperbolic sine of a number.
COS
Returns the cosine of an angle that is expressed in radians.
SIN
Returns the sine of an angle that is expressed in radians.
Types of arguments and valuesFunctions that accept conditions and wildcards as argumentsReview formula errors and follow best practices