Page 3 of 11
CRITBINOM
Calculates the smallest value for which the cumulative binomial distribution is greater than or e...
CRITBINOM(num_trials, prob_success, target_prob)
CSC
Returns the cosecant of an angle provided in radians..
CSC(angle)
CSCH
The CSCH function returns the hyperbolic cosecant of any real number..
CSCH(value)
CUMIPMT
Calculates the cumulative interest over a range of payment periods for an investment based on con...
CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)
CUMPRINC
Calculates the cumulative principal paid over a range of payment periods for an investment based ...
CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)
DATE
Converts a provided year, month, and day into a date.
DATE(year, month, day)
DATEDIF
Calculates the number of days, months, or years between two dates.
DATEDIF(start_date, end_date, unit)
DATEVALUE
Converts a provided date string in a known format to a date value.
DATEVALUE(date_string)
DAVERAGE
Returns the average of a set of values selected from a database table-like array or range using a...
DAVERAGE(database, field, criteria)
DAY
Returns the day of the month that a specific date falls on, in numeric format.
DAY(date)
DAYS
Returns the number of days between two dates..
DAYS(end_date, start_date)
DAYS360
Returns the difference between two days based on the 360 day year used in some financial interest...
DAYS360(start_date, end_date, [method])
DB
Calculates the depreciation of an asset for a specified period using the arithmetic declining bal...
DB(cost, salvage, life, period, [month])
DCOUNT
Counts numeric values selected from a database table-like array or range using a SQL-like query.
DCOUNT(database, field, criteria)
DCOUNTA
Counts values, including text, selected from a database table-like array or range using a SQL-lik...
DCOUNTA(database, field, criteria)
DDB
Calculates the depreciation of an asset for a specified period using the double-declining balance...
DDB(cost, salvage, life, period, [factor])
DEC2BIN
Converts a decimal number to signed binary format.
DEC2BIN(decimal_number, [significant_digits])
DEC2HEX
Converts a decimal number to signed hexadecimal format.
DEC2HEX(decimal_number, [significant_digits])
DEC2OCT
Converts a decimal number to signed octal format.
DEC2OCT(decimal_number, [significant_digits])
DECIMAL
The DECIMAL function converts the text representation of a number in another base, to base 10 (de...
DECIMAL(value, base)
DEGREES
Converts an angle value in radians to degrees.
DEGREES(angle)
DELTA
Compare two numeric values, returning 1 if they're equal.
DELTA(number1, [number2])
DETECTLANGUAGE
Identifies the language used in text within the specified range.
DETECTLANGUAGE(text_or_range)
DEVSQ
Calculates the sum of squares of deviations based on a sample.
DEVSQ(value1, value2)
DGET
Returns a single value from a database table-like array or range using a SQL-like query.
DGET(database, field, criteria)
DISC
Calculates the discount rate of a security based on price.
DISC(settlement, maturity, price, redemption, [day_count_convention])
DIVIDE
Returns one number divided by another. Equivalent to the `/` operator.
DIVIDE(dividend, divisor)
DMAX
Returns the maximum value selected from a database table-like array or range using a SQL-like query.
DMAX(database, field, criteria)
DMIN
Returns the minimum value selected from a database table-like array or range using a SQL-like query.
DMIN(database, field, criteria)
DOLLAR
Formats a number into the locale-specific currency format.
DOLLAR(number, [number_of_places])
DOLLARDE
Converts a price quotation given as a decimal fraction into a decimal value.
DOLLARDE(fractional_price, unit)
DOLLARFR
Converts a price quotation given as a decimal value into a decimal fraction.
DOLLARFR(decimal_price, unit)
DPRODUCT
Returns the product of values selected from a database table-like array or range using a SQL-like...
DPRODUCT(database, field, criteria)
DSTDEV
Returns the standard deviation of a population sample selected from a database table-like array o...
DSTDEV(database, field, criteria)
DSTDEVP
Returns the standard deviation of an entire population selected from a database table-like array ...
DSTDEVP(database, field, criteria)
DSUM
Returns the sum of values selected from a database table-like array or range using a SQL-like query.
DSUM(database, field, criteria)
DURATION
Calculates the number of compounding periods required for an investment of a specified present va...
DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) .
DVAR
Returns the variance of a population sample selected from a database table-like array or range us...
DVAR(database, field, criteria)
DVARP
Returns the variance of an entire population selected from a database table-like array or range u...
DVARP(database, field, criteria)
EDATE
Returns a date a specified number of months before or after another date.
EDATE(start_date, months)
EFFECT
Calculates the annual effective interest rate given the nominal rate and number of compounding pe...
EFFECT(nominal_rate, periods_per_year)
ENCODEURL
Encodes a string of text for the purpose of using in a URL query..
ENCODEURL(text)
EOMONTH
Returns a date representing the last day of a month which falls a specified number of months befo...
EOMONTH(start_date, months)
EPOCHTODATE
Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC.
EPOCHTODATE(timestamp, [unit])
EQ
Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` ope...
EQ(value1, value2)
ERF
The ERF function returns the integral of the Gauss error function over an interval of values..
ERF(lower_bound, [upper_bound])
ERF.PRECISE
See ERF
ERF.PRECISE(lower_bound, [upper_bound])
ERFC
Returns the complementary Gauss error function of a value.
ERFC(z)