Calculates the number of coupons, or interest payments, between the settlement date and the matur...

COUPNUM(settlement, maturity, frequency, [day_count_convention])

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

COUPNCD(settlement, maturity, frequency, [day_count_convention])

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

COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])

Calculates the number of days in the coupon, or interest payment, period that contains the specif...

COUPDAYS(settlement, maturity, frequency, [day_count_convention])

Calculates the number of days from the first coupon, or interest payment, until settlement.

COUPDAYBS(settlement, maturity, frequency, [day_count_convention])

Returns the hyperbolic cotangent of any real number..

COTH(value)

Cotangent of an angle provided in radians..

COT(angle)

Returns the hyperbolic cosine of any real number.

COSH(value)

Returns the cosine of an angle provided in radians.

COS(angle)

Calculates r, the Pearson product-moment correlation coefficient of a dataset.

CORREL(data_y, data_x)

Converts a numeric value to a different unit of measure.

CONVERT(value, start_unit, end_unit)

Calculates the width of half the confidence interval for a Student’s t-distribution..

CONFIDENCE.T(alpha, standard_deviation, size)

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

CONFIDENCE.NORM(alpha, standard_deviation, pop_size)

See CONFIDENCE.NORM

CONFIDENCE(alpha, standard_deviation, pop_size)

Creates a complex number given real and imaginary coefficients.

COMPLEX(real_part, imaginary_part, [suffix])

Returns the number of ways to choose some number of objects from a pool of a given size of object...

COMBINA(n, k)

Returns the number of ways to choose some number of objects from a pool of a given size of objects.

COMBIN(n, k)

The ERF function returns the integral of the Gauss error function over an interval of values..

ERF(lower_bound, [upper_bound])

Calculates the annual effective interest rate given the nominal rate and number of compounding pe...

EFFECT(nominal_rate, periods_per_year)

Returns the variance of an entire population selected from a database table-like array or range u...

DVARP(database, field, criteria)

Returns the variance of a population sample selected from a database table-like array or range us...

DVAR(database, field, criteria)

Calculates the number of compounding periods required for an investment of a specified present va...

DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) .

Returns the sum of values selected from a database table-like array or range using a SQL-like query.

DSUM(database, field, criteria)

Returns the standard deviation of an entire population selected from a database table-like array ...

DSTDEVP(database, field, criteria)

Returns the standard deviation of a population sample selected from a database table-like array o...

DSTDEV(database, field, criteria)

Returns the product of values selected from a database table-like array or range using a SQL-like...

DPRODUCT(database, field, criteria)

Converts a price quotation given as a decimal value into a decimal fraction.

DOLLARFR(decimal_price, unit)

Converts a price quotation given as a decimal fraction into a decimal value.

DOLLARDE(fractional_price, unit)

Formats a number into the locale-specific currency format.

DOLLAR(number, [number_of_places])

Returns the minimum value selected from a database table-like array or range using a SQL-like query.

DMIN(database, field, criteria)

Returns the maximum value selected from a database table-like array or range using a SQL-like query.

DMAX(database, field, criteria)

Returns one number divided by another. Equivalent to the `/` operator.

DIVIDE(dividend, divisor)

Calculates the discount rate of a security based on price.

DISC(settlement, maturity, price, redemption, [day_count_convention])

Returns a single value from a database table-like array or range using a SQL-like query.

DGET(database, field, criteria)

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

DEVSQ(value1, value2)

Compare two numeric values, returning 1 if they're equal.

DELTA(number1, [number2])

Converts an angle value in radians to degrees.

DEGREES(angle)

The DECIMAL function converts the text representation of a number in another base, to base 10 (de...

DECIMAL(value, base)

Converts a decimal number to signed octal format.

DEC2OCT(decimal_number, [significant_digits])

Converts a decimal number to signed binary format.

DEC2BIN(decimal_number, [significant_digits])

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

DDB(cost, salvage, life, period, [factor])

Counts numeric values selected from a database table-like array or range using a SQL-like query.

DCOUNT(database, field, criteria)

Calculates the depreciation of an asset for a specified period using the arithmetic declining bal...

DB(cost, salvage, life, period, [month])

Returns the difference between two days based on the 360 day year used in some financial interest...

DAYS360(start_date, end_date, [method])

Returns the number of days between two dates..

DAYS(end_date, start_date)

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

COLUMNS(range)

See BETA.INV

BETAINV(probability, alpha, beta, lower_bound, upper_bound)

See BETA.DIST.

BETADIST(value, alpha, beta, lower_bound, upper_bound)