Spreadsheet functions

Function

Description

ABS

Returns the absolute value of a number.

ACOS

Returns the arccosine of a number, in radians.

ACOSH

Returns the inverse hyperbolic cosine of a number.

ACOT

Returns the arccotangent of a number, in radians.

ACOTH

Returns the inverse hyperbolic cotangent of a number, in radians.

ARABIC

Converts a Roman numeral to a number.

ASIN

Returns the arcsine of a number, in radians.

ASINH

Returns the inverse hyperbolic sine of a number.

ATAN

Returns the arctangent of a number, in radians.

ATAN2

Returns the angle in radians between the x-axis and a line segment from the origin to a specified coordinate point (x,y).

ATANH

Returns the inverse hyperbolic tangent of a number.

BASE

Converts a number to a text representation in a specified base, such as base 2 for binary.

CEILING

Rounds a number up to the nearest integer multiple of a specified factor.

CEILING.MATH

-

CEILING.PRECISE

-

COMBIN

Returns the number of combinations for a given number of items from a set.

COMBINA

Returns the number of combinations with repetition for a given number of items from a set.

COS

Returns the cosine of a given angle in radians.

COSH

Returns the hyperbolic cosine of a real number.

COT

Returns the cotangent of a given angle in radians.

COTH

Returns the hyperbolic cotangent of a real number.

CSC

Returns the cosecant of a given angle in radians.

CSCH

Returns the hyperbolic cosecant of a real number.

DECIMAL

Converts a text representation of a number in a given base to its base-10 (decimal) value.

DEGREES

Converts an angle from radians to degrees.

EVEN

Rounds a number up to the nearest even integer.

EXP

Returns Euler's number, e (~2.718), raised to a specified power.

FACT

Returns the factorial of a number.

FACTDOUBLE

Returns the double factorial of a number.

FLOOR

Rounds a number down to the nearest integer multiple of a specified factor.

FLOOR.MATH

-

FLOOR.PRECISE

-

GCD

Returns the greatest common divisor of one or more integers.

INT

Rounds a number down to the nearest integer.

LCM

Returns the least common multiple of one or more integers.

LN

Returns the logarithm of a number, base e (Euler's number).

LOG

Returns the logarithm of a number to a specified base.

LOG10

Returns the base-10 logarithm of a number.

MMULT

Returns the matrix product of two matrices specified as arrays or ranges.

MOD

Returns the remainder of a division.

MROUND

Rounds a number to the nearest multiple of another number.

MULTINOMIAL

Returns the ratio of the factorial of the sum of the arguments to the product of their factorials.

MUNIT

Returns the identity matrix of a specified dimension.

ODD

Rounds a number up to the nearest odd integer.

PI

Returns the value of pi, accurate to 14 decimal places.

POWER

Returns a number raised to a specified power.

PRODUCT

Returns the product of a series of numbers.

QUOTIENT

Returns the integer part of a division.

RADIANS

Converts an angle from degrees to radians.

RAND

Returns a random number that is greater than or equal to 0 and less than 1.

RANDBETWEEN

Returns a random integer between two specified numbers, inclusive.

ROMAN

Converts a number to a Roman numeral.

ROUND

Rounds a number to a specified number of decimal places according to standard rules.

ROUNDDOWN

Rounds a number down to a specified number of decimal places.

ROUNDUP

Rounds a number up to a specified number of decimal places.

SEC

Returns the secant of a given angle in radians.

SECH

Returns the hyperbolic secant of a real number.

SIGN

Returns -1 if a number is negative, 1 if it is positive, and 0 if it is zero.

SIN

Returns the sine of a given angle in radians.

SINH

Returns the hyperbolic sine of a real number.

SQRT

Returns the positive square root of a positive number.

SQRTPI

Returns the positive square root of the product of pi and a given positive number.

SUBTOTAL

Returns a subtotal for a range of cells using a specified summary function.

SUM

Returns the sum of a series of numbers and/or cells.

SUMIF

Returns the sum of values in a range that meet a given criterion.

SUMIFS

Returns the sum of values in a range that meet multiple criteria.

SUMPRODUCT

Returns the sum of the products of corresponding entries in two equal-sized arrays or ranges.

SUMSQ

Returns the sum of the squares of a series of numbers and/or cells.

SUMX2MY2

Returns the sum of the difference of squares of corresponding values in two arrays.

SUMX2PY2

Returns the sum of the sum of squares of corresponding values in two arrays.

SUMXMY2

Returns the sum of the squares of the differences between corresponding values in two arrays.

TAN

Returns the tangent of a given angle in radians.

TANH

Returns the hyperbolic tangent of a real number.

TRUNC

Truncates a number to a specified number of decimal places without rounding.

Function

Description

DATE

Creates a date from a specified year, month, and day.

DATEDIF

Calculates the number of days, months, or years between two dates.

DATEVALUE

Converts a date string in a known format to a date value.

DAY

Returns the day of the month for a specified date.

DAYS

Returns the number of days between two dates.

DAYS360

Returns the difference between two dates based on a 360-day year (for interest calculations).

EDATE

Returns a date that is a specified number of months before or after another date.

EOMONTH

Returns the last day of the month, a specified number of months before or after a start date.

HOUR

Returns the hour component of a specified time.

ISOWEEKNUM

Returns the ISO week number for a specified date.

MINUTE

Returns the minute component of a specified time.

MONTH

Returns the month of a specified date.

NETWORKDAYS

Returns the number of net working days between two specified dates.

NETWORKDAYS.INTL

-

NOW

Returns the current date and time as a date value.

SECOND

Returns the second component of a specified time.

TIME

Creates a time from a specified hour, minute, and second.

TIMEVALUE

Converts a time string into a time value, which is a fraction of a 24-hour day.

TODAY

Returns the current date as a date value.

WEEKDAY

Returns a number representing the day of the week for a specified date.

WEEKNUM

Returns the week number of the year for a specified date.

WORKDAY

Returns a date that is a specified number of workdays before or after a specified start date.

WORKDAY.INTL

-

YEAR

Returns the year of a specified date.

YEARFRAC

Calculates the year fraction between two dates based on a specified day-count basis.

Function

Description

ADDRESS

Returns a cell reference as a string.

AREAS

-

CHOOSE

Returns an element from a list of choices based on an index.

COLUMN

Returns the column number of a specified cell, where A=1.

COLUMNS

Returns the number of columns in a specified array or range.

FILTER

Filters a source range, returning only the rows or columns that meet specified conditions.

FORMULATEXT

Returns the formula from a cell as a string.

GETPIVOTDATA

Returns a cell value from a pivot table.

HLOOKUP

Searches for a key in the first row of a range and returns the value from a specified row number in the found column.

HYPERLINK

Creates a hyperlink in a cell.

INDEX

Returns the content of a cell specified by a row and column number.

INDIRECT

Returns a cell reference specified by a string.

LOOKUP

Looks up a key in a sorted row or column and returns the value from the corresponding cell in a result range.

MATCH

Returns the relative position of an item in a range that matches a specified value.

OFFSET

Returns a range reference shifted a specified number of rows and columns from a starting cell reference.

ROW

Returns the row number of a specified cell.

ROWS

Returns the number of rows in a specified array or range.

TRANSPOSE

Transposes the rows and columns of an array or range.

VLOOKUP

Searches for a key in the first column of a range and returns the value from a specified column number in the found row.

XLOOKUP

-

XMATCH

-

Function

Description

CHAR

Converts a number to its corresponding Unicode character.

CLEAN

Removes non-printable ASCII characters from text.

CODE

Returns the Unicode code point for the first character in a string.

CONCAT

Returns the concatenation of two values. Equivalent to the "&" operator.

CONCATENATE

Appends one string to another.

EXACT

Checks if two strings are identical.

FIND

Returns the starting position of the first occurrence of a string within text. Returns #VALUE! if the string is not found.

FINDB

Returns the starting position of a string's first occurrence within text, where each double-byte character counts as two.

FIXED

Formats a number with a fixed number of decimal places.

LEFT

Returns a substring from the start of a string.

LEFTB

Returns a substring from the start of a string.

LEN

Returns the length of a string.

LENB

Returns the length of a string in bytes.

LOWER

Converts all letters in a string to lowercase.

MID

Returns a substring from a string.

MIDB

Returns a substring from a string.

PROPER

Capitalizes the first letter of each word in a string.

REPLACE

Replaces a portion of a string with a different string.

REPLACEB

Replaces a portion of a string with a different string, based on the specified number of bytes.

REPT

Repeats text a given number of times.

RIGHT

Returns a substring from the end of a string.

RIGHTB

Returns a substring from the end of a string.

SEARCH

Returns the starting position of the first occurrence of a string within text. Returns #VALUE! if the string is not found.

SEARCHB

Returns the starting position of a string's first occurrence within text, where each double-byte character counts as two.

SUBSTITUTE

Replaces existing text in a string with new text.

T

Returns the value if it is text, or an empty string otherwise.

TEXT

Converts a number to text using the specified format.

TEXTJOIN

Combines text from multiple strings or arrays, using a specified delimiter between each value.

TRIM

Removes leading, trailing, and repeated spaces from text.

UNICHAR

Returns the character specified by a decimal Unicode number.

UNICODE

Returns the decimal Unicode value of the first character in a string.

UPPER

Converts all letters in a string to uppercase.

VALUE

Converts a string in any recognizable date, time, or number format to a number.

Function

Description

AVEDEV

Returns the average of the absolute deviations of data points from their mean.

AVERAGE

Returns the arithmetic mean of a dataset, ignoring text.

AVERAGEA

Returns the arithmetic mean of a dataset.

AVERAGEIF

Returns the average of a range that meets a specified condition.

AVERAGEIFS

Returns the average of a range that meets multiple criteria.

BETA.DIST

Returns the probability for a given value based on the beta distribution function.

BETA.INV

Returns the inverse of the cumulative beta distribution function for a specified probability.

BETADIST

Returns the probability for a given value based on the beta distribution function.

BETAINV

Returns the inverse of the cumulative beta distribution function for a specified probability.

BINOM.DIST

Returns the probability of achieving a specified number of successes (or a maximum number of successes) in a given number of trials, assuming a constant probability of success and trials performed with replacement.

BINOM.DIST.RANGE

-

BINOM.INV

-

BINOMDIST

Returns the probability of achieving a specified number of successes (or a maximum number of successes) in a given number of trials, assuming a constant probability of success and trials performed with replacement.

CHIDIST

Returns the right-tailed probability of the chi-squared distribution, which is often used in hypothesis testing.

CHIINV

Returns the inverse of the right-tailed probability of the chi-squared distribution.

CHISQ.DIST

-

CHISQ.DIST.RT

-

CHISQ.INV

-

CHISQ.INV.RT

-

CHISQ.TEST

-

CHITEST

Returns the probability from a Pearson's chi-squared test on two data ranges. This test is used to determine the likelihood that observed categorical data is drawn from an expected distribution.

CONFIDENCE

Returns half the width of the confidence interval for a normal distribution.

CONFIDENCE.NORM

-

CONFIDENCE.T

-

CORREL

Returns the Pearson product-moment correlation coefficient (r) for a given dataset.

COUNT

Returns the number of numeric values in a dataset.

COUNTA

Returns the number of values in a dataset.

COUNTBLANK

Returns the number of empty cells in a specified range.

COUNTIF

Returns a conditional count across a range.

COUNTIFS

Returns the number of cells in a range that meet multiple criteria.

COVAR

Returns the covariance of a dataset.

COVARIANCE.P

-

COVARIANCE.S

-

CRITBINOM

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criterion.

DEVSQ

Returns the sum of squares of deviations based on a sample.

EXPON.DIST

Returns the value of the exponential distribution function for a specified value and lambda.

EXPONDIST

Returns the value of the exponential distribution function for a specified value and lambda.

FDIST

Returns the right-tailed F-probability distribution for two datasets, given an input x. Also known as the Fisher-Snedecor distribution or Snedecor's F-distribution.

F.DIST

Returns the right-tailed F-probability distribution for two datasets, given an input x. Also known as the Fisher-Snedecor distribution or Snedecor's F-distribution.

F.DIST.RT

-

FINV

Returns the inverse of the right-tailed F-probability distribution.

F.INV

Returns the inverse of the right-tailed F-probability distribution.

F.INV.RT

-

F.TEST

This test determines whether two samples likely come from populations with the same variance.

FISHER

Returns the Fisher transformation for a specified value.

FISHERINV

Returns the inverse of the Fisher transformation for a specified value.

FORECAST

Returns the expected y-value for a specified x based on a linear regression of a dataset.

FORECAST.LINEAR

-

FREQUENCY

Returns the frequency distribution for a one-column array, grouped into specified classes.

FTEST

This test determines whether two samples likely come from populations with the same variance.

GAMMA

Returns the gamma function value for a specified value.

GAMMA.DIST

Returns the gamma distribution, a two-parameter continuous probability distribution.

GAMMA.INV

Returns the inverse of the gamma cumulative distribution function for a specified probability, alpha, and beta.

GAMMALN

Returns the natural logarithm (base e) of the gamma function for a specified value.

GAUSS

Returns the probability that a standard normal random variable falls between the mean and z standard deviations from the mean.

GEOMEAN

Returns the geometric mean of a dataset.

HARMEAN

Returns the harmonic mean of a dataset.

HYPGEOM.DIST

Returns the probability of a specified number of successes in a given number of draws, without replacement, from a finite population.

HYPGEOMDIST

Returns the probability of a specified number of successes in a given number of draws, without replacement, from a finite population.

INTERCEPT

Returns the y-intercept (where x=0) of the linear regression line for a dataset.

KURT

Returns the kurtosis of a dataset, which describes the "peakedness" of a distribution.

LARGE

Returns the nth largest element from a dataset, where n is user-specified.

LOGNORM.DIST

Returns the value of the log-normal cumulative distribution for a specified value, given the mean and standard deviation.

MAX

Returns the maximum value in a numeric dataset.

MAXA

Returns the maximum numeric value in a dataset.

MAXIFS

Returns the maximum value among cells filtered by a set of criteria applied to other ranges.

MEDIAN

Returns the median value in a numeric dataset.

MIN

Returns the minimum value in a numeric dataset.

MINA

Returns the minimum numeric value in a dataset.

MINIFS

Returns the minimum value among cells filtered by a set of criteria applied to other ranges.

MODE

Returns the most frequently occurring value in a dataset.

MODE.MULT

-

MODE.SNGL

-

NEGBINOM.DIST

Returns the probability that a specified number of failures will occur before a specified number of successes, given a constant probability of success.

NEGBINOMDIST

Returns the probability that a specified number of failures will occur before a specified number of successes, given a constant probability of success.

NORM.DIST

Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.

NORM.INV

Returns the inverse of the normal cumulative distribution function for a specified probability, mean, and standard deviation.

NORM.S.DIST

-

NORM.S.INV

-

PEARSON

Returns the Pearson product-moment correlation coefficient (r) for a given dataset.

PERCENTILE

Returns the value at a given percentile of a dataset.

PERCENTILE.EXC

-

PERCENTILE.INC

-

PERCENTRANK

Returns the percentage rank (percentile) of a specified value in a dataset.

PERCENTRANK.EXC

-

PERCENTRANK.INC

-

PERMUT

Returns the number of permutations for selecting a given number of objects from a set.

PERMUTATIONA

Returns the number of permutations for selecting a given number of objects (with replacement) from a set.

PHI

Returns the value of the probability density function for a standard normal distribution, which has a mean of 0 and a standard deviation of 1.

POISSON

Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean.

POISSON.DIST

-

PROB

Given a set of values and their corresponding probabilities, returns the probability that a randomly chosen value falls between two limits.

QUARTILE

Returns the value closest to a specified quartile of a dataset.

QUARTILE.EXC

-

QUARTILE.INC

-

RANK

Returns the rank of a specified value in a dataset.

RANK.AVG

-

RANK.EQ

-

RSQ

Returns the square of the Pearson product-moment correlation coefficient (r) for a given dataset.

SKEW

Returns the skewness of a dataset, which describes the asymmetry of that dataset around its mean.

SKEW.P

-

SLOPE

Returns the slope of the linear regression line for a dataset.

SMALL

Returns the nth smallest element from a dataset, where n is user-specified.

STANDARDIZE

Returns the normalized value of a random variable, given the mean and standard deviation of the distribution.

STDEV

Returns the standard deviation based on a sample.

STDEV.P

Returns the standard deviation based on an entire population.

STDEV.S

-

STDEVA

Returns the standard deviation based on a sample, treating text as 0.

STDEVP

Returns the standard deviation based on an entire population.

STDEVPA

Returns the standard deviation based on an entire population, treating text as 0.

STEYX

Returns the standard error of the predicted y-value for each x in the regression for a dataset.

T.DIST

Returns the probability for the Student's t-distribution given an input value (x).

T.DIST.2T

-

T.DIST.RT

-

T.INV

Returns the left-tailed inverse of the Student's t-distribution.

T.INV.2T

-

TTEST

Returns the probability from a Student's t-test. This test determines whether two samples likely come from populations with the same mean.

T.TEST

Returns the probability from a Student's t-test. This test determines whether two samples likely come from populations with the same mean.

TINV

Returns the two-tailed inverse of the Student's t-distribution.

TRIMMEAN

Returns the mean of a dataset after excluding a percentage of data points from its upper and lower tails.

VAR

Returns the variance based on a sample.

VAR.P

Returns the variance based on an entire population.

VAR.S

-

VARA

Returns the variance based on a sample, treating text as 0.

VARP

Returns the variance based on an entire population.

VARPA

Returns the variance based on an entire population, treating text as 0.

WEIBULL

Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale.

WEIBULL.DIST

-

Z.TEST

Returns the one-tailed p-value of a z-test for a standard distribution.

ZTEST

Returns the one-tailed p-value of a z-test for a standard distribution.

Parameter

Description

BESSELI

-

BESSELJ

-

BESSELK

-

BESSELY

-

BIN2DEC

Converts a signed binary number to decimal format.

BIN2HEX

Converts a signed binary number to signed hexadecimal format.

BIN2OCT

Converts a signed binary number to signed octal format.

BITAND

Returns the bitwise Boolean AND of two numbers.

BITLSHIFT

Returns a number shifted left by a specified number of bits.

BITOR

Returns the bitwise Boolean OR of two numbers.

BITRSHIFT

Returns a number shifted right by a specified number of bits.

BITXOR

Returns the bitwise Boolean XOR of two numbers.

COMPLEX

Converts real and imaginary coefficients into a complex number.

DEC2BIN

Converts a decimal number to signed binary format.

DEC2HEX

Converts a decimal number to signed hexadecimal format.

DEC2OCT

Converts a decimal number to signed octal format.

DELTA

Returns 1 if two numbers are equal; otherwise, returns 0.

ERF

Returns the value of the error function.

ERF.PRECISE

-

ERFC

Returns the complementary error function of a value.

ERFC.PRECISE

-

GESTEP

Returns 1 if a number is greater than or equal to a step value; otherwise, returns 0. The default step value is 0.

HEX2BIN

Converts a signed hexadecimal number to signed binary format.

HEX2DEC

Converts a signed hexadecimal number to decimal format.

HEX2OCT

Converts a signed hexadecimal number to signed octal format.

IMABS

Returns the absolute value (modulus) of a complex number.

IMAGINARY

Returns the imaginary coefficient of a complex number.

IMARGUMENT

Returns the argument θ (an angle in radians) of a complex number.

IMCONJUGATE

Returns the complex conjugate of a complex number.

IMCOS

Returns the cosine of a complex number in x + yi or x + yj format.

IMCOSH

Returns the hyperbolic cosine of a complex number in x + yi or x + yj format.

IMCOT

Returns the cotangent of a complex number in x + yi or x + yj format.

IMCSC

Returns the cosecant of a complex number in x + yi or x + yj format.

IMCSCH

Returns the hyperbolic cosecant of a complex number in x + yi or x + yj format.

IMDIV

Returns the quotient of two complex numbers.

IMEXP

Returns Euler's number, e (~2.718), raised to the power of a complex number.

IMLN

Returns the natural logarithm (base e) of a complex number.

IMLOG10

Returns the base-10 logarithm of a complex number.

IMLOG2

Returns the base-2 logarithm of a complex number.

IMPOWER

Returns a complex number raised to a power.

IMPRODUCT

Returns the product of a series of complex numbers.

IMREAL

Returns the real coefficient of a complex number.

IMSEC

Returns the secant of a complex number in x + yi or x + yj format.

IMSECH

Returns the hyperbolic secant of a complex number in x + yi or x + yj format.

IMSIN

Returns the sine of a complex number in x + yi or x + yj format.

IMSINH

Returns the hyperbolic sine of a complex number in x + yi or x + yj format.

IMSQRT

Returns the square root of a complex number.

IMSUB

Returns the difference between two complex numbers.

IMSUM

Returns the sum of a series of complex numbers.

IMTAN

Returns the tangent of a complex number in x + yi or x + yj format.

OCT2BIN

Converts a signed octal number to signed binary format.

OCT2DEC

Converts a signed octal number to decimal format.

OCT2HEX

Converts a signed octal number to signed hexadecimal format.

Function

Description

COUPDAYBS

Calculates the number of days from the first coupon or interest payment date to the settlement date.

COUPDAYS

Calculates the number of days in the coupon or interest payment period containing the settlement date.

COUPDAYSNC

Calculates the number of days from the settlement date to the next coupon or interest payment date.

COUPNCD

Calculates the next coupon or interest payment date after the settlement date.

COUPNUM

Calculates the number of coupons payable between the settlement date and maturity date.

COUPPCD

Calculates the last coupon or interest payment date before the settlement date.

CUMIPMT

Calculates the cumulative interest paid on an investment with equal periodic payments and a fixed interest rate.

CUMPRINC

Calculates the cumulative principal paid on an investment with equal periodic payments and a fixed interest rate.

DB

Calculates the asset depreciation for a specified period using the fixed-declining balance method.

DDB

Calculates the asset depreciation for a specified period using the double-declining balance method.

DISC

Calculates the discount rate for a security based on its price.

DOLLARDE

Converts a fractional price to a decimal number.

DOLLARFR

Converts a decimal price to a fraction.

EFFECT

Calculates the effective annual interest rate from the nominal annual interest rate and the number of compounding periods per year.

FV

Calculates the future value of an annuity investment with equal periodic payments and a fixed interest rate.

IPMT

Calculates the interest payment for a given period on an investment with equal periodic payments and a fixed interest rate.

IRR

Calculates the internal rate of return on an investment based on a series of periodic cash flows.

ISPMT

Calculates the interest paid during a specific period of an investment.

NOMINAL

Calculates the nominal annual interest rate from the effective annual interest rate and the number of compounding periods per year.

NPER

Calculates the number of payment periods for an investment with equal periodic payments and a fixed interest rate.

NPV

Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.

PDURATION

Calculates the number of periods for an investment to reach a specified value.

PMT

Calculates the periodic payment for an annuity investment assuming constant payments and a fixed interest rate.

PPMT

Calculates the principal payment for a given period on an investment with equal periodic payments and a fixed interest rate.

PRICEDISC

Calculates the price of a discounted (non-interest-bearing) security based on an expected yield.

PV

Calculates the present value of an annuity investment with equal periodic payments and a fixed interest rate.

RATE

Calculates the interest rate per period of an annuity.

RECEIVED

Calculates the amount received at maturity for a fixed-income security purchased on a specified date.

RRI

Calculates the equivalent interest rate for an investment to grow to a specified value over a given number of periods.

SLN

Calculates the straight-line depreciation of an asset for a single period.

SYD

Calculates the asset depreciation for a specified period using the sum-of-the-years' digits method.

VDB

Calculates the asset depreciation for a specified period, including partial periods.

XIRR

Calculates the internal rate of return for an investment based on a series of potentially irregular cash flows.

XNPV

Calculates the net present value for an investment based on a series of potentially irregular cash flows and a discount rate.

YIELDDISC

Calculates the annual yield for a discounted (non-interest-bearing) security, based on its price.

Name

Description

AND

Returns TRUE if all parameters are logically true, and FALSE if any parameter is logically false.

FALSE

Returns the logical value FALSE.

IF

Returns one value if a logical expression is TRUE, and another value if it is FALSE.

IFERROR

Returns the first parameter if it is not an error value; otherwise, returns the second parameter if provided, or a blank value.

IFNA

Returns the first parameter if it is not an #N/A error value; otherwise, returns the second parameter if provided, or a blank value.

IFS

Evaluates multiple conditions and returns the value corresponding to the first true condition.

NOT

Returns the opposite of a logical value: NOT(TRUE) returns FALSE; NOT(FALSE) returns TRUE.

OR

Returns TRUE if any parameter is logically true, and FALSE if all parameters are logically false.

SWITCH

Evaluates an expression against a list of cases and returns the value corresponding to the first matching case. If no match is found, it returns an optional default value.

TRUE

Returns the logical value TRUE.

XOR

Returns TRUE if an odd number of parameters are logically true; otherwise, returns FALSE.

Function

Description

CELL

Returns information about a specified cell.

ERROR.TYPE

-

ISBLANK

Checks if a cell is empty.

ISERR

Checks if a value is any error value except #N/A.

ISERROR

Checks if a value is an error value.

ISEVEN

Checks if a number is even.

ISFORMULA

Checks if a value is a formula.

ISLOGICAL

Checks if a value is a logical value (TRUE or FALSE).

ISNA

Checks if a value is the #N/A error value.

ISNONTEXT

Checks if a value is not text.

ISNUMBER

Checks if a value is a number.

ISODD

Checks if a number is odd.

ISREF

Checks if a value is a valid cell reference.

ISTEXT

Checks if a value is text.

N

Converts a value to a number. Text becomes 0, and error values are returned unchanged.

NA

Returns the error value #N/A, which means "not available".

TYPE

Returns a number representing the value's data type.