EXCEL FUNCTIONS - SOLVED EXCEL

LOGICAL

FUNCTION	DESCRIPTION	SYNTAX
AND	Try different conditions, but they must all be true at the same time	AND(logical1,[logical2]...)
FALSE	Make something that says "not true"	FALSE()
IF	Check if something is exactly as you want it to be	IF(logical_test,[value_if_true], [value_if_false])
IFERROR	Catch and deal errors	IFERROR(value,value_if_error)
IFNA	Catch and deal with special "not available" problems	IFNA(value, value_if_na)
IFS	Check multiple conditions, and tell me the first one that's true	IFS(logical_test1, value_if_true1,[logical_test2, value_if_true2], ...)
NOT	Change the order of things or what they mean	NOT(logical)
OR	Test different conditions, and as long as one is true, it's good	OR(logical1,[logical2], ...)
SWITCH	Find a match from a list of things, and tell me the first one you find	SWITCH(expression, value1, result1,[default_or_ value2, result2] …)
TRUE	Make something that says "true"	TRUE()
XOR	Do something special when one thing is true and the other is not	XOR(logical1,[logical2], ...)

Date and Time

FUNCTION	DESCRIPTION	SYNTAX
DATE	Make a date with the year, month, and day values	DATE(year, month, day)
DATEDIF	Find out how many days, months, or years are between two dates.	DATEDIF(start_date, end_date, unit)
DATEVALUE	Change a date from words/string/text to a real date.	DATEVALUE(date_text)
DAY	Know which day of the month it is (from 1 to 31).	DAY(serial_number)
DAYS	Count the days between dates	DAYS(end_date, start_date)
DAYS360	Calculate the days between two dates in a 360-day year.	DAYS360(start_date, end_date,[method])
EDATE	Move a date into the future or the past by a certain number of months.	EDATE(start_date, months)
EOMONTH	Find the last day of a month, some months from now(future/past)	EOMONTH(start_date, months)
HOUR	See what time it is (from 0 to 23) in hours.	HOUR(serial_number)
ISOWEEKNUM	Find the ISO week number for a given date.	ISOWEEKNUM(date)
MINUTE	Determine how many minutes have passed (from 0 to 59) in the current time.	MINUTE(serial_number)
MONTH	Get the month as a number (from 1 to 12) from a date.	MONTH(serial_number)
NETWORKDAYS	Count how many working days are between two dates.	NETWORKDAYS(start_date, end_date,[holidays])
NETWORKDAYS.INTL	Calculate workdays between two dates (weekdays only).	NETWORKDAYS.INTL(start_date, end_date,[weekend], [holidays])
NOW	Show the current date and time.	NOW()
SECOND	Check the seconds on the clock (from 0 to 59) in the current time.	SECOND(serial_number)
TIME	Make a time with hours, minutes, and seconds.	TIME(hour, minute, second)
TIMEVALUE	Transform a text into a valid time.	TIMEVALUE(time_text)
TODAY	Find today's date.	TODAY()
WEEKDAY	Know which day of the week it is, represented as a number.	WEEKDAY(serial_number,[return_type])
WEEKNUM	Calculate the week number for a given date.	WEEKNUM(serial_number,[return_type])
WORKDAY	Calculate a date in the future or past with a specific number of working days.	WORKDAY(start_date, days,[holidays])
WORKDAY.INTL	Find a date in the future or past with a certain number of working days.	WORKDAY.INTL(start_date, days, [weekend], [holidays])
YEAR	Find out the year from a date.	YEAR(serial_number)
YEARFRAC	Determine the fraction of a year between two dates.	YEARFRAC(start_date, days,[basis])

Lookup and reference

FUNCTION	DESCRIPTION	SYNTAX
ADDRESS	Formulate a cell address using a given row and column number	ADDRESS(row_num, column_num,[abs_num], [a1], [sheet_text])
AREAS	Determine the number of distinct sections within a specified reference	AREAS(reference)
CHOOSE	Retrieve a value from a list based on its position	CHOOSE(index_num, value1,[value2] ...)
COLUMN	Determine the column number of a specific reference	COLUMN([reference])
COLUMNS	Find the total number of columns in an array or reference	COLUMNS(array)
FIELDVALUE	Extract a specific field value from a given data type	FIELDVALUE(value, field_name)
FORMULATEXT	Obtain the formula present in a cell	FORMULATEXT(reference)
GETPIVOTDATA	Access data from a pivot table within a formula	GETPIVOTDATA(data_field, pivot_table,[field1, item1], [field2, item2] ...)
HLOOKUP	Search for a value in a table organized horizontally	HLOOKUP(lookup_value, table_array, row_index_num,[range_lookup])
HYPERLINK	Generate a clickable hyperlink	HYPERLINK(link_location,[friendly_name])
INDEX	Retrieve a value from a list or table based on its location	INDEX(array, row_num,[column_num], [area_num])
INDIRECT	Form a reference using textual information	INDIRECT(ref_text,[a1])
LOOKUP	Search for a value in a single-column range	LOOKUP(lookup_value, lookup_vector,[result_vector])
MATCH	Determine the position of an item within an array	MATCH(lookup_value, lookup_array,[match_type])
OFFSET	Create a reference offset from a given starting point	OFFSET(reference, rows, cols,[height], [width])
ROW	Identify the row number of a specific reference	ROW(reference)
ROWS	Determine the total number of rows in an array or reference	ROWS(array)
TRANSPOSE	Invert the arrangement of a range of cells	TRANSPOSE(array)
VLOOKUP	Look for a value in a table by matching it with the first column	VLOOKUP(lookup_value, table_array, col_index_num,[range_lookup])

Text

FUNCTION	DESCRIPTION	SYNTAX
CHAR	Retrieve a character based on a given number	CHAR(number)
CLEAN	Remove non-printable characters from a text	CLEAN(text)
CODE	Obtain the code corresponding to a specific character	CODE(text)
CONCAT	Combine text values seamlessly without any delimiters	CONCAT(text1,[text2] ...)
CONCATENATE	Concatenate text into a single string	CONCATENATE(text1,[text2], [text3] ...)
DOLLAR	Transform a number into text while formatting it as currency	DOLLAR(number,[decimals])
EXACT	Compare two text strings for equality	EXACT(text1, text2)
FIND	Identify the position of a substring within a larger string	FIND(find_text, within_text,[start_num])
FIXED	Format a number as text with a fixed number of decimal places	FIXED(number,[decimals], [no_commas])
LEFT	Extract text from the left side of a string	LEFT(text,[num_chars])
LEN	Determine the length of a text string	LEN(text)
LOWER	Convert text to lowercase	LOWER(text)
MID	Extract specific text from within a larger string	MID(text, start_num, num_chars)
NUMBERVALUE	Convert text to a number while using custom separators	NUMBERVALUE(text,[decimal_separator], [group_separator])
PROPER	Capitalize the first letter of each word in a text	PROPER(text)
REPLACE	Replace text based on its position within a string	REPLACE(old_text, start_num, num_chars, new_text)
REPT	Repeat specified text as needed	REPT(text, number_times)
RIGHT	Extract text from the right side of a string	RIGHT(text,[num_chars])
SEARCH	Find the position of a substring within a string	SEARCH(find_text, within_text,[start_num])
SUBSTITUTE	Replace text based on its content within a string	SUBSTITUTE(text, old_text, new_text, [instance_num])
TEXT	Convert a number into text while maintaining its numeric format	TEXT(value, format_text)
TEXTJOIN	Merge text values using a designated delimiter	TEXTJOIN(delimiter, ignore_empty, text1,[text2] ...)
TRIM	Eliminate extra spaces from a text	TRIM(text)
UNICHAR	Retrieve a Unicode character based on its number	UNICHAR(number)
UNICODE	Obtain the number corresponding to a Unicode character	UNICODE(text)
UPPER	Convert text to uppercase	UPPER(text)
VALUE	Convert text into a numeric value	VALUE(text)

Dynamic

FUNCTION	DESCRIPTION	SYNTAX
ARRAYTOTEXT	Convert an array or range into a text string	ARRAYTOTEXT(array,[format])
BYCOL	Apply a function to a column	BYCOL(array,[function])
BYROW	Apply a function to a row	BYROW(array,[function])
CHOOSECOLS	Extract specific columns from an array	CHOOSECOLS(array, col_num1,[col_num2] ...)
CHOOSEROWS	Extract specific rows from an array	CHOOSEROWS(array, row_num1,[row_num2] ...)
DROP	Remove a portion of an array	DROP(array, rows,[columns])
EXPAND	Expand an array by adding rows or columns	EXPAND(array, rows,[columns], [pad_with])
FILTER	Filter a range based on given criteria	FILTER(array, include,[if_empty])
HSTACK	Merge ranges or arrays horizontally	HSTACK(array1,[array2] ...)
ISOMITTED	Check for optional arguments in LAMBDAs	ISOMITTED(argument)
LAMBDA	Create a custom function	LAMBDA(parameter_or_calculation,[parameter_or_calculation]..)
LET	Assign variables within a formula	LET(name1, name_value1, calculation_or_name2,[name_value2, calculation_or_name3],..)
MAKEARRAY	Generate an array with calculated values	MAKEARRAY(rows, columns, function)
MAP	Apply a custom function to an array	MAP(array, lambda_or_array2,[lambda_or_array3]…)
RANDARRAY	Generate an array of random numbers	RANDARRAY([rows], [columns], [min], [max], [integer])
REDUCE	Reduce an array	REDUCE(initial_value, array, function)
SCAN	Scan an array and return intermediate results	SCAN(initial_value, array, function)
SEQUENCE	Generate an array of sequential numbers	SEQUENCE(rows,[columns], [start], [step])
SORT	Sort a range or array	SORT(array,[sort_index], [sort_order], [by_col])
SORTBY	Sort a range or array by column	SORTBY(array, by_array1,[sort_order1],...)
STOCKHISTORY	Retrieve stock price information	STOCKHISTORY(stock, start_date,[end_date], [interval], [headers], [properties1] ...)
TAKE	Obtain a subset of an array	TAKE(array, rows,[columns])
TEXTAFTER	Extract text after a specified delimiter	TEXTAFTER(text, delimiter,[instance_num], [match_mode], [match_end], [if_not_found])
TEXTBEFORE	Extract text before a specified delimiter	TEXTBEFORE(text, delimiter,[instance_num], [match_mode], [match_end], [if_not_found])
TEXTSPLIT	Split a text string using a delimiter	TEXTSPLIT(text, col_delimiter,[row_delimiter], [ignore_empty], [match_mode], [pad_with])
TOCOL	Transform an array into a single column	TOCOL(array,[ignore], [scan_by_column])
TOROW	Transform an array into a single row	TOROW(array,[ignore], [scan_by_column])
UNIQUE	Extract unique values from a range	UNIQUE(array,[by_col], [exactly_once])
VALUETOTEXT	Convert a value into a text string	VALUETOTEXT(value,[format])
VSTACK	Merge ranges or arrays vertically	VSTACK(array1,[array2] ...)
WRAPCOLS	Organize an array into columns	WRAPCOLS(vector, wrap_count,[pad_with])
WRAPROWS	Organize an array into rows	WRAPROWS(vector, wrap_count,[pad_with])
XLOOKUP	Look up values in a range or array	XLOOKUP(lookup_value, lookup_array, return_array,[if_not_found], [match_mode], [search_mode])
XMATCH	Determine the position of an item in a list or table	XMATCH(lookup_value, lookup_array,[match_mode], [search_mode])

Engineering

FUNCTION	DESCRIPTION	SYNTAX
BIN2DEC	Convert a binary number to decimal	BIN2DEC(number)
BIN2HEX	Convert a binary number to hexadecimal	BIN2HEX(number,[places])
BIN2OCT	Convert a binary number to octal	BIN2OCT(number,[places])
BITAND	Perform a 'Bitwise And' operation on two numbers	BITAND(number1, number2)
BITLSHIFT	Shift a number left by a specified number of bits	BITLSHIFT(number, shift_amount)
BITOR	Perform a 'Bitwise Or' operation on two numbers	BITOR(number1, number2)
BITRSHIFT	Shift a number right by a specified number of bits	BITRSHIFT(number, shift_amount)
BITXOR	Perform a 'Bitwise Xor' operation on two numbers	BITXOR(number1, number2)
COMPLEX	Convert coefficients into a complex number	COMPLEX(real_num, i_num,[suffix])
CONVERT	Convert measurement units	CONVERT(number, from_unit, to_unit)
DEC2BIN	Convert a decimal number to binary	DEC2BIN(number,[places])
DEC2HEX	Convert a decimal number to hexadecimal	DEC2HEX(number,[places])
DEC2OCT	Convert a decimal number to octal	DEC2OCT(number,[places])
DELTA	Test if two values are equal	DELTA(number1,[number2])
HEX2BIN	Convert a hexadecimal number to binary.	HEX2BIN(number,[places])
HEX2DEC	Convert a hexadecimal number to decimal	HEX2DEC(number)
HEX2OCT	Convert a hexadecimal number to octal	HEX2OCT(number,[places])
IMABS	Obtain the absolute value of a complex number	IMABS(inumber)
IMAGINARY	Retrieve the imaginary coefficient of a complex number	IMAGINARY(inumber)
IMPOWER	Raise a complex number to a given power	IMPOWER(inumber, number)
IMPRODUCT	Calculate the product of complex numbers	IMPRODUCT(inumber1,[inumber2] ...)
IMREAL	Retrieve the real coefficient of a complex number	IMREAL(inumber)
IMSUB	Calculate the difference between two complex numbers	IMSUB()
IMSUM	Calculate the sum of complex numbers	IMSUM(inumber1,[inumber2]…)

Financial

FUNCTION	DESCRIPTION	SYNTAX
ACCRINT	Determine accrued interest periodically	ACCRINT(issue, first_interest, settlement, rate, par, frequency,[basis], [calc_method])
ACCRINTM	Calculate accrued interest at maturity	ACCRINTM(issue, settlement, rate, par,[basis])
AMORDEGRC	Obtain the depreciation coefficient for an accounting period	AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate,[basis])
AMORLINC	Calculate depreciation for an accounting period	AMORLINC(cost, date_purchased, first_period, salvage, period, rate,[basis])
COUPDAYBS	Determine days from the coupon period to the settlement date	COUPDAYBS(settlement, maturity, frequency,[basis])
COUPDAYS	Calculate days in the coupon period including the settlement date	COUPDAYS(settlement, maturity, frequency,[basis])
COUPDAYSNC	Determine days from the settlement date to the next coupon date	COUPDAYSNC(settlement, maturity, frequency,[basis])
COUPNCD	Obtain the next coupon date after the settlement date	COUPNCD(settlement, maturity, frequency,[basis])
COUPNUM	Determine the number of payable coupons	COUPNUM(settlement, maturity, frequency,[basis])
COUPPCD	Obtain the previous coupon date before the settlement date	COUPPCD(settlement, maturity, frequency,[basis])
CUMIPMT	Calculate cumulative interest paid on a loan	CUMIPMT(rate, nper, pv, start_period, end_period, type)
CUMPRINC	Calculate cumulative principal paid on a loan	CUMPRINC(rate, nper, pv, start_period, end_period, type)
DB	Calculate depreciation using fixed-declining balance method	DB(cost, salvage, life, period,[month])
DDB	Calculate depreciation using double-declining method	DDB(cost, salvage, life, period,[factor])
DISC	Obtain the discount rate for a security	DISC(settlement, maturity, pr, redemption,[basis])
DOLLARDE	Convert a dollar price as a fraction to decimal	DOLLARDE(fractional_dollar, fraction)
DOLLARFR	Convert price to fractional notation	DOLLARFR(decimal_dollar, fraction)
DURATION	Determine annual duration with periodic interest	DURATION(settlement, maturity, coupon, yld, frequency,[basis])
EFFECT	Obtain the effective annual interest rate	EFFECT(nominal_rate, npery)
FV	Calculate the future value of an investment	FV(rate, nper, pmt,[pv], [type])
FVSCHEDULE	Calculate the future value of principal with compound interest	FVSCHEDULE(principal, schedule)
INTRATE	Determine the interest rate for a fully invested security	INTRATE(settlement, maturity, investment, redemption,[basis])
IPMT	Obtain interest for a given period	IPMT(rate, per, nper, pv,[fv], [type])
IRR	Calculate the internal rate of return	IRR(values, )
ISPMT	Determine interest paid for a specific period	ISPMT(rate, per, nper, pv)
MDURATION	Obtain Macauley modified duration for a par value of $100	MDURATION(settlement, maturity, coupon, yld, frequency,[basis])
MIRR	Calculate the modified internal rate of return	MIRR(values, finance_rate, reinvest_rate)
NOMINAL	Determine annual nominal interest rate	NOMINAL(effect_rate, npery)
NPER	Determine the number of periods for a loan or investment	NPER(rate, pmt, pv,[fv], [type])
NPV	Calculate net present value	NPV(rate, value1,[value2] ...)
ODDFPRICE	Obtain price per $100 for an odd first period	ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency,[basis])
ODDFYIELD	Determine yield for a security with an odd first period	ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency,[basis])
ODDLPRICE	Obtain price per $100 face value with an odd last period	ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency,[basis])
ODDLYIELD	Determine yield for a security with an odd last period	ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency,[basis])
PDURATION	Determine periods required to reach a given value	PDURATION(rate, pv, fv)
PMT	Calculate the periodic payment for a loan	PMT(rate, nper, pv,[fv], [type])
PPMT	Determine principal payment in a given period	PPMT(rate, per, nper, pv,[fv], [type])
PRICE	Obtain price per $100 face value with periodic interest	PRICE(settlement, maturity, rate, yld, redemption, frequency,[basis])
PRICEDISC	Obtain price per $100 for a discounted security	PRICEDISC(settlement, maturity, discount, redemption,[basis])
PRICEMAT	Obtain price per $100 for interest at maturity	PRICEMAT(settlement, maturity, issue, rate, yld,[basis])
PV	Calculate the present value of an investment	PV(rate, nper, pmt,[fv], [type])
RATE	Obtain the interest rate per period for an annuity	RATE(nper, pmt, pv,[fv], [type], [guess])
RECEIVED	Determine the amount received at maturity	RECEIVED(settlement, maturity, investment, discount,[basis])
RRI	Obtain equivalent interest rate for growth	RRI(nper, pv, fv)
SLN	Calculate straight-line depreciation	SLN(cost, salvage, life)
SYD	Calculate sum-of-years depreciation	SYD(cost, salvage, life, per)
TBILLEQ	Obtain bond-equivalent yield for a Treasury bill	TBILLEQ(settlement, maturity, discount)
TBILLPRICE	Obtain price per $100 for a Treasury bill	TBILLPRICE(settlement, maturity, discount)
TBILLYIELD	Determine yield for a Treasury bill	TBILLYIELD(settlement, maturity, pr)
VDB	Calculate double-declining variable depreciation	VDB(cost, salvage, life, start_period, end_period,[factor], [no_switch])
XIRR	Calculate internal rate of return for irregular cash flows	XIRR(values, dates,[guess])
XNPV	Calculate net present value for irregular cash flows	XNPV(rate, values, dates)
YIELD	Determine yield for a security with periodic interest	YIELD(settlement, maturity, rate, pr, redemption, frequency,[basis])
YIELDDISC	Obtain annual yield for a discounted security	YIELDDISC(settlement, maturity, pr, redemption,[basis])
YIELDMAT	Determine annual yield for interest at maturity	YIELDMAT(settlement, maturity, issue, rate, pr,[basis])

Information

FUNCTION	DESCRIPTION	SYNTAX
CELL	Retrieve information about a cell	CELL(info_type,[reference])
ERROR.TYPE	Test for a specific error value	ERROR.TYPE(error_val)
INFO	Retrieve information about the current environment	INFO(type_text)
ISBLANK	Test if a cell is empty	ISBLANK(value)
ISERR	Test for any error except #N/A	ISERR(value)
ISERROR	Test for any error	ISERROR(value)
ISEVEN	Test if a value is even	ISEVEN(value)
ISFORMULA	Test if a cell contains a formula	ISFORMULA(reference)
ISLOGICAL	Test if a value is logical	ISLOGICAL(value)
ISNA	Test for the #N/A error	ISNA(value)
ISNONTEXT	Test for a non-text value	ISNONTEXT(value)
ISNUMBER	Test for a numeric value	ISNUMBER(value)
ISODD	Test if a value is odd	ISODD(value)
ISREF	Test for a reference	ISREF(value)
ISTEXT	Test for a text value	ISTEXT(value)
N	Convert a value into a number	N(value)
NA	Create an #N/A error	NA()
SHEET	Obtain the sheet index number	SHEET(value)
SHEETS	Obtain the number of sheets in a reference	SHEETS(reference)
T	Filter text values only	T(value)
TYPE	Determine the type of value in a cell	TYPE(value)

Mathametical

FUNCTION	DESCRIPTION	SYNTAX
ABS	Find the absolute value of a number	ABS(number)
AGGREGATE	Return aggregate calculations	AGGREGATE(function_num, options, array,[k])
ARABIC	Convert Roman numerals to Arabic numerals	ARABIC(text)
BASE	Convert a number to another base	BASE(number, radix,[min_length])
CEILING	Round a number up to the nearest multiple	CEILING()
CEILING.MATH	Round a number up to the nearest multiple	CEILING.MATH(number,[significance], [mode])
CEILING.PRECISE	Round a number up to the nearest multiple	CEILING.PRECISE(number,[significance])
COMBIN	Determine the number of combinations without repetitions	COMBIN(number, number_chosen)
COMBINA	Determine the number of combinations with repetitions	COMBINA(number, number_chosen)
DECIMAL	Convert a number in a different base to a decimal number	DECIMAL(number, radix)
EVEN	Round a number up to the next even integer	EVEN(number)
EXP	Find the value of e raised to the power of a number	EXP(number)
FACT	Find the factorial of a number	FACT(number)
FACTDOUBLE	Obtain the double factorial of a number	FACTDOUBLE(number)
FLOOR	Round a number down to the nearest specified multiple	FLOOR(number, significance)
FLOOR.MATH	Round a number down to the nearest multiple	FLOOR.MATH(number,[significance], [mode])
FLOOR.PRECISE	Round a number down to the nearest multiple	FLOOR.PRECISE(number,[significance])
GCD	Determine the greatest common divisor of number	GCD(number1,[number2] ...)
INT	Obtain the integer part of a number by rounding down	INT(number)
LCM	Determine the least common multiple of numbers	LCM(number1,[number2] ...)
LN	Calculate the natural logarithm of a given number	LN(number)
LOG	Find the logarithm of a number	LOG(number,[base])
LOG10	Calculate the base-10 logarithm of a number	LOG10(number)
MDETERM	Compute the determinant of a given matrix	MDETERM(array)
MINVERSE	Find the inverse matrix of an array	MINVERSE(array)
MMULT	Perform matrix multiplication on specified arrays	MMULT(array1, array2)
MOD	Obtain the remainder after division	MOD(number, divisor)
MROUND	Round a number to the nearest specified multiple	MROUND(number, multiple)
MUNIT	Generate a unit matrix for a given dimension	MUNIT(dimension)
ODD	Round a number up to the next odd integer	ODD(number)
PI	Retrieve the value of π (pi)	PI()
POWER	Raise a number to a specific power	POWER(number, power)
PRODUCT	Calculate the product of supplied numbers	PRODUCT(number1,[number2] ...)
QUOTIENT	Determine the quotient without a remainder	QUOTIENT(numerator, denominator)
RAND	Generate a random number between 0 and 1	RAND()
RANDBETWEEN	Get a random integer within a specified range	RANDBETWEEN(bottom, top)
ROMAN	Convert numbers into Roman numerals	ROMAN(number,[form])
ROUND	Round a number to a specified number of digits	ROUND(number, num_digits)
ROUNDDOWN	Round down a number to a given number of digits	ROUNDDOWN(number, num_digits)
ROUNDUP	Round up a number to a specified number of digits	ROUNDUP(number, num_digits)
SIGN	Determine the sign of a number	SIGN(number)
SQRT	Find the positive square root of a number	SQRT(number)
SUBTOTAL	Obtain a subtotal in a list or database	SUBTOTAL(function_num, ref1,[ref2] ...)
SUM	Add numbers together	SUM(number1,[number2]...)
SUMIF	Sum cells in a range that meet specific criteria	SUMIF(range, criteria,[sum_range])
SUMIFS	Sum cells in a range that meet multiple criteria	SUMIFS(sum_range, criteria_range1, criteria1,[criteria_range2, criteria2]...)
SUMPRODUCT	Calculate the sum of squares of product values	SUMPRODUCT(array1,[array2]...)
SUMSQ	Calculate the sum of the squares of the provided values	SUMSQ(number1,[number2]...)
SUMX2MY2	Determine the sum of the differences between the squares in two arrays	SUMX2MY2(array_x, array_y)
SUMX2PY2	Compute the sum of the squares within two arrays	SUMX2PY2(array_x, array_y)
SUMXMY2	Calculate the sum of the squares of the differences in two arrays	SUMXMY2(array_x, array_y)
TRUNC	Round a number to a specified precision	TRUNC(number,[num_digits])

Trigonometry

FUNCTION	DESCRIPTION	SYNTAX
ACOS	Calculate the arccosine of a value in radians	ACOS(number)
ASIN	Calculate the arcsine of a value in radians	ASIN(number)
ATAN	Compute the arctangent of a number	ATAN(number)
ATAN2	Compute the arctangent from x- and y-coordinates	ATAN2(x_num, y_num)
COS	Determine the cosine of an angle in radians	COS(number)
COSH	Find the hyperbolic cosine of a number	COSH(number)
COT	Calculate the cotangent of an angle	COT(number)
CSC	Determine the cosecant of an angle	CSC(number)
DEGREES	Convert radians to degrees	DEGREES(angle)
RADIANS	Convert degrees to radians	RADIANS(angle)
SEC	Calculate the secant of an angle	SEC(number)
SIN	Determine the sine of an angle in radians	SIN(number)
SINH	Find the hyperbolic sine of a number	SINH(number)
TAN	Calculate the tangent of an angle	TAN(number)

Statistical

FUNCTION	DESCRIPTION	SYNTAX
AVEDEV	Calculate the sum of squared deviations	AVEDEV(number1,[number2] ...)
AVERAGE	Compute the average of a group of numbers	AVERAGE(number1,[number2] ...)
AVERAGEA	Determine the average of a group of numbers and text	AVERAGEA(value1,[value2] ...)
AVERAGEIF	Find the average of numbers that meet specific criteria	AVERAGEIF(range, criteria,[average_range])
AVERAGEIFS	Average cells that match multiple criteria	AVERAGEIFS(average_range, criteria_range1, criteria1,[criteria_range2, criteria2]...)
BINOM.DIST	Calculate the probability of a binomial distribution	BINOM.DIST(number_s, trials, probability_s, cumulative)
BINOMDIST	Find the probability of a binomial distribution	BINOMDIST(number_s, trials, probability_s, cumulative)
COUNT	Count numbers in a dataset	COUNT(value1,[value2] ...)
COUNTA	Count the number of non-blank cells	COUNTA(value1,[value2] ...)
COUNTBLANK	Count cells that are blank	COUNTBLANK(range)
COUNTIF	Count cells that match specific criteria	COUNTIF(range, criteria)
COUNTIFS	Count cells that match multiple criteria	COUNTIFS(criteria_range1, criteria1,[criteria_range2, criteria2]...)
DEVSQ	Calculate the sum of squared deviations	DEVSQ(number1,[number2] ...)
FORECAST	Predict a value along a linear trend	FORECAST(x, known_ys, kown_xs)
FORECAST.ETS	Predict a value with a seasonal trend	FORECAST.ETS(target_date, values, timeline,[seasonality], [data_completion], [aggregation])
FORECAST.ETS.CONFINT	Obtain the confidence interval for a forecasted value at a given date	FORECAST.ETS.CONFINT(target_date, values, timeline,[confidence_level], [seasonality], [data_completion], [aggregation])
FORECAST.ETS.SEASONALITY	Determine the length of the seasonal pattern	FORECAST.ETS.SEASONALITY(values, timeline,[data_completion], [aggregation])
FORECAST.ETS.STAT	Get statistical values related to forecasting	FORECAST.ETS.STAT(values, timeline, statistic_type,[seasonality], [data_completion], [aggregation])
FORECAST.LINEAR	Predict a value along a linear trend	FORECAST.LINEAR(x, known_ys, kown_xs)
FREQUENCY	Find the frequency of values in a dataset	FREQUENCY(data_array, bins_array)
GEOMEAN	Calculate the geometric mean	GEOMEAN(number1,[number2] ...)
HARMEAN	Calculate the harmonic mean	HARMEAN(number1,[number2] ...)
INTERCEPT	Determine the intercept of a linear regression line	INTERCEPT(known_ys, known_xs)
LARGE	Find the nth largest value	LARGE(array, k)
LINEST	Get parameters of a linear trend	LINEST(known_ys,[known_xs], [const], [stats])
MAX	Find the largest value	MAX(number1,[number2] ...)
MAXA	Return the largest value	MAXA(value1,[value2] ...)
MAXIFS	Get the maximum value with specific criteria	MAXIFS(max_range, range1, criteria1, range2 criteria2 …)
MEDIAN	Calculate the median of a group of numbers	MEDIAN(number1, number2 …)
MIN	Find the smallest value	MIN(number1, number2 …)
MINA	Return the smallest value	MINA(value1 value2 …)
MINIFS	Get the minimum value with specific criteria	MINIFS(max_range, criteria_range1, criteria1,[criteria_range2, criteria2]...)
MODE	Find the most frequently occurring number	MODE(number1,[number2] ...)
MODE.MULT	Find the most frequently occurring numbers	MODE.MULT(number1,[number2] ...)
MODE.SNGL	Find the most frequently occurring number	MODE.SNGL(number1,[number2] ...)
NORM.DIST	Obtain values and areas for the normal distribution	NORM.DIST(x, mean, standard_dev, cumulative)
NORM.INV	Calculate the inverse of the normal cumulative distribution	NORM.INV(probability, mean, standard_dev)
NORM.S.DIST	Get the standard normal CDF and PDF	NORM.S.DIST(z, cumulative)
NORM.S.INV	Find the inverse of the standard normal cumulative distribution	NORM.S.INV(probability)
PERCENTILE	Calculate the kth percentile	PERCENTILE(array, k)
PERCENTILE.EXC	Find the kth percentile	PERCENTILE.EXC(array, k)
PERCENTILE.INC	Determine the kth percentile	PERCENTILE.INC(array, k)
PERCENTRANK	Calculate percentile rank, inclusive	PERCENTRANK(array, x,[significance])
PERCENTRANK.EXC	Calculate percentile rank, exclusive	PERCENTRANK.EXC(array, x,[significance])
PERCENTRANK.INC	Determine percentile rank, inclusive	PERCENTRANK.INC(array, x,[significance])
PERMUT	Find the number of permutations without repetitions	PERMUT(number, number_chosen)
PERMUTATIONA	Find the number of permutations with repetitions	PERMUTATIONA(number, number_chosen)
QUARTILE	Get the quartile in a dataset	QUARTILE(array, quart)
QUARTILE.EXC	Determine the quartile in a dataset	QUARTILE.EXC(array, quart)
QUARTILE.INC	Find the quartile in a dataset	QUARTILE.INC(array, quart)
RANK	Rank a number against a range of numbers	RANK(number, ref,[order])
RANK.AVG	Rank a number against a range of numbers	RANK.AVG(number, ref,[order])
RANK.EQ	Rank a number against a range of numbers	RANK.EQ(number, ref,[order])
SKEW	Calculate the skewness of a distribution	SKEW(number1,[number2] ...)
SKEW.P	Find the skewness of a distribution based on population	SKEW.P(number1,[number2] ...)
SLOPE	Determine the slope of a linear regression line	SLOPE(known_ys, known_xs)
SMALL	Find the nth smallest value	SMALL(array, k)
STANDARDIZE	Calculate a normalized value (z-score)	STANDARDIZE(x, mean, standard_dev)
STDEV	Get the standard deviation in a sample	STDEV(number1,[number2] ...)
STDEV.P	Calculate the standard deviation of a population	STDEV.P(number1,[number2] ...)
STDEV.S	Find the standard deviation in a sample	STDEV.S(number1,[number2] ...)
STDEVA	Calculate the standard deviation in a sample	STDEVA(number1,[number2] ...)
STDEVP	Find the standard deviation of a population	STDEVP(number1,[number2] ...)
STDEVPA	Calculate the standard deviation for a population	STDEVPA(number1,[number2] ...)
TRIMMEAN	Calculate the mean excluding outliers	TRIMMEAN(array, percent)
VAR	Get the variation of a sample	VAR(number1,[number2] ...)
VAR.P	Find the variation of a population	VAR.P(number1,[number2] ...)
VAR.S	Get the variation of a sample	VAR.S(number1,[number2] ...)
VARA	Get the variation of a sample	VARA(number1,[number2] ...)
VARP	Find the variation of a population	VARP(number1,[number2] ...)
VARPA	Get the variation of a population	VARPA(number1,[number2] ...)

Web

FUNCTION	DESCRIPTION	SYNTAX
ENCODEURL	Obtain a URL-encoded string	ENCODEURL(text)
FILTERXML	Retrieve data from XML using XPath	FILTERXML(xml, xpath)
WEBSERVICE	Fetch data from a web service	WEBSERVICE(url)

Database

FUNCTION	DESCRIPTION	SYNTAX
DAVERAGE	Calculate the average from matching records	DAVERAGE(database, field, criteria)
DCOUNT	Count matching records in a database	DCOUNT(database, field, criteria)
DCOUNTA	Count matching records in a database	DCOUNTA(database, field, criteria)
DGET	Retrieve a value from a matching record	DGET(database, field, criteria)
DMAX	Find the maximum from matching records	DMAX(database, field, criteria)
DMIN	Find the minimum from matching records	DMIN(database, field, criteria)
DPRODUCT	Calculate the product from matching records	DPRODUCT(database, field, criteria)
DSTDEV	Compute the standard deviation of a sample in matching records	DSTDEV(database, field, criteria)
DSTDEVP	Compute the standard deviation of a population in matching records	DSTDEVP(database, field, criteria)
DSUM	Calculate the sum from matching records	DSUM(database, field, criteria)
DVAR	Calculate the sample variance for matching records	DVAR(database, field, criteria)
DVARP	Calculate the population variance for matching records	DVARP(database, field, criteria)

LOGICAL

AND

Description: Try different conditions, but they must all be true at the same time

Syntax: AND(logical1,[logical2]...)

FALSE

Description: Make something that says "not true"

Syntax: FALSE()

IF

Description: Check if something is exactly as you want it to be

Syntax: IF(logical_test,[value_if_true], [value_if_false])

IFERROR

Description: Catch and deal errors

Syntax: IFERROR(value,value_if_error)

IFNA

Description: Catch and deal with special "not available" problems

Syntax: IFNA(value, value_if_na)

IFS

Description: Check multiple conditions, and tell me the first one that's true

Syntax: IFS(logical_test1, value_if_true1,[logical_test2, value_if_true2], ...)

NOT

Description: Change the order of things or what they mean

Syntax: NOT(logical)

OR

Description: Test different conditions, and as long as one is true, it's good

Syntax: OR(logical1,[logical2], ...)

SWITCH

Description: Find a match from a list of things, and tell me the first one you find

Syntax: SWITCH(expression, value1, result1,[default_or_ value2, result2] …)

TRUE

Description: Make something that says "true"

Syntax: TRUE()

XOR

Description: Do something special when one thing is true and the other is not

Syntax: XOR(logical1,[logical2], ...)

Date and Time

DATE

Description: Make a date with the year, month, and day values

Syntax: DATE(year, month, day)

DATEDIF

Description: Find out how many days, months, or years are between two dates.

Syntax: DATEDIF(start_date, end_date, unit)

DATEVALUE

Description: Change a date from words/string/text to a real date.

Syntax: DATEVALUE(date_text)

DAY

Description: Know which day of the month it is (from 1 to 31).

Syntax: DAY(serial_number)

DAYS

Description: Count the days between dates

Syntax: DAYS(end_date, start_date)

DAYS360

Description: Calculate the days between two dates in a 360-day year.

Syntax: DAYS360(start_date, end_date,[method])

EDATE

Description: Move a date into the future or the past by a certain number of months.

Syntax: EDATE(start_date, months)

EOMONTH

Description: Find the last day of a month, some months from now(future/past)

Syntax: EOMONTH(start_date, months)

HOUR

Description: See what time it is (from 0 to 23) in hours.

Syntax: HOUR(serial_number)

ISOWEEKNUM

Description: Find the ISO week number for a given date.

Syntax: ISOWEEKNUM(date)

MINUTE

Description: Determine how many minutes have passed (from 0 to 59) in the current time.

Syntax: MINUTE(serial_number)

MONTH

Description: Get the month as a number (from 1 to 12) from a date.

Syntax: MONTH(serial_number)

NETWORKDAYS

Description: Count how many working days are between two dates.

Syntax: NETWORKDAYS(start_date, end_date,[holidays])

NETWORKDAYS.INTL

Description: Calculate workdays between two dates (weekdays only).

Syntax: NETWORKDAYS.INTL(start_date, end_date,[weekend], [holidays])

NOW

Description: Show the current date and time.

Syntax: NOW()

SECOND

Description: Check the seconds on the clock (from 0 to 59) in the current time.

Syntax: SECOND(serial_number)

TIME

Description: Make a time with hours, minutes, and seconds.

Syntax: TIME(hour, minute, second)

TIMEVALUE

Description: Transform a text into a valid time.

Syntax: TIMEVALUE(time_text)

TODAY

Description: Find today's date.

Syntax: TODAY()

WEEKDAY

Description: Know which day of the week it is, represented as a number.

Syntax: WEEKDAY(serial_number,[return_type])

WEEKNUM

Description: Calculate the week number for a given date.

Syntax: WEEKNUM(serial_number,[return_type])

WORKDAY

Description: Calculate a date in the future or past with a specific number of working days.

Syntax: WORKDAY(start_date, days,[holidays])

WORKDAY.INTL

Description: Find a date in the future or past with a certain number of working days.

Syntax: WORKDAY.INTL(start_date, days, [weekend], [holidays])

YEAR

Description: Find out the year from a date.

Syntax: YEAR(serial_number)

YEARFRAC

Description: Determine the fraction of a year between two dates.

Syntax: YEARFRAC(start_date, days,[basis])

Lookup and reference

ADDRESS

Description: Formulate a cell address using a given row and column number

Syntax: ADDRESS(row_num, column_num,[abs_num], [a1], [sheet_text])

AREAS

Description: Determine the number of distinct sections within a specified reference

Syntax: AREAS(reference)

CHOOSE

Description: Retrieve a value from a list based on its position

Syntax: CHOOSE(index_num, value1,[value2] ...)

COLUMN

Description: Determine the column number of a specific reference

Syntax: COLUMN([reference])

COLUMNS

Description: Find the total number of columns in an array or reference

Syntax: COLUMNS(array)

FIELDVALUE

Description: Extract a specific field value from a given data type

Syntax: FIELDVALUE(value, field_name)

FORMULATEXT

Description: Obtain the formula present in a cell

Syntax: FORMULATEXT(reference)

GETPIVOTDATA

Description: Access data from a pivot table within a formula

Syntax: GETPIVOTDATA(data_field, pivot_table,[field1, item1], [field2, item2] ...)

HLOOKUP

Description: Search for a value in a table organized horizontally

Syntax: HLOOKUP(lookup_value, table_array, row_index_num,[range_lookup])

HYPERLINK

Description: Generate a clickable hyperlink

Syntax: HYPERLINK(link_location,[friendly_name])

INDEX

Description: Retrieve a value from a list or table based on its location

Syntax: INDEX(array, row_num,[column_num], [area_num])

INDIRECT

Description: Form a reference using textual information

Syntax: INDIRECT(ref_text,[a1])

LOOKUP

Description: Search for a value in a single-column range

Syntax: LOOKUP(lookup_value, lookup_vector,[result_vector])

MATCH

Description: Determine the position of an item within an array

Syntax: MATCH(lookup_value, lookup_array,[match_type])

OFFSET

Description: Create a reference offset from a given starting point

Syntax: OFFSET(reference, rows, cols,[height], [width])

ROW

Description: Identify the row number of a specific reference

Syntax: ROW(reference)

ROWS

Description: Determine the total number of rows in an array or reference

Syntax: ROWS(array)

TRANSPOSE

Description: Invert the arrangement of a range of cells

Syntax: TRANSPOSE(array)

VLOOKUP

Description: Look for a value in a table by matching it with the first column

Syntax: VLOOKUP(lookup_value, table_array, col_index_num,[range_lookup])

Text

CHAR

Description: Retrieve a character based on a given number

Syntax: CHAR(number)

CLEAN

Description: Remove non-printable characters from a text

Syntax: CLEAN(text)

CODE

Description: Obtain the code corresponding to a specific character

Syntax: CODE(text)

CONCAT

Description: Combine text values seamlessly without any delimiters

Syntax: CONCAT(text1,[text2] ...)

CONCATENATE

Description: Concatenate text into a single string

Syntax: CONCATENATE(text1,[text2], [text3] ...)

DOLLAR

Description: Transform a number into text while formatting it as currency

Syntax: DOLLAR(number,[decimals])

EXACT

Description: Compare two text strings for equality

Syntax: EXACT(text1, text2)

FIND

Description: Identify the position of a substring within a larger string

Syntax: FIND(find_text, within_text,[start_num])

FIXED

Description: Format a number as text with a fixed number of decimal places

Syntax: FIXED(number,[decimals], [no_commas])

LEFT

Description: Extract text from the left side of a string

Syntax: LEFT(text,[num_chars])

LEN

Description: Determine the length of a text string

Syntax: LEN(text)

LOWER

Description: Convert text to lowercase

Syntax: LOWER(text)

MID

Description: Extract specific text from within a larger string

Syntax: MID(text, start_num, num_chars)

NUMBERVALUE

Description: Convert text to a number while using custom separators

Syntax: NUMBERVALUE(text,[decimal_separator], [group_separator])

PROPER

Description: Capitalize the first letter of each word in a text

Syntax: PROPER(text)

REPLACE

Description: Replace text based on its position within a string

Syntax: REPLACE(old_text, start_num, num_chars, new_text)

REPT

Description: Repeat specified text as needed

Syntax: REPT(text, number_times)

RIGHT

Description: Extract text from the right side of a string

Syntax: RIGHT(text,[num_chars])

SEARCH

Description: Find the position of a substring within a string

Syntax: SEARCH(find_text, within_text,[start_num])

SUBSTITUTE

Description: Replace text based on its content within a string

Syntax: SUBSTITUTE(text, old_text, new_text, [instance_num])

TEXT

Description: Convert a number into text while maintaining its numeric format

Syntax: TEXT(value, format_text)

TEXTJOIN

Description: Merge text values using a designated delimiter

Syntax: TEXTJOIN(delimiter, ignore_empty, text1,[text2] ...)

TRIM

Description: Eliminate extra spaces from a text

Syntax: TRIM(text)

UNICHAR

Description: Retrieve a Unicode character based on its number

Syntax: UNICHAR(number)

UNICODE

Description: Obtain the number corresponding to a Unicode character

Syntax: UNICODE(text)

UPPER

Description: Convert text to uppercase

Syntax: UPPER(text)

VALUE

Description: Convert text into a numeric value

Syntax: VALUE(text)

Dynamic

ARRAYTOTEXT

Description: Convert an array or range into a text string

Syntax: ARRAYTOTEXT(array,[format])

BYCOL

Description: Apply a function to a column

Syntax: BYCOL(array,[function])

BYROW

Description: Apply a function to a row

Syntax: BYROW(array,[function])

CHOOSECOLS

Description: Extract specific columns from an array

Syntax: CHOOSECOLS(array, col_num1,[col_num2] ...)

CHOOSEROWS

Description: Extract specific rows from an array

Syntax: CHOOSEROWS(array, row_num1,[row_num2] ...)

DROP

Description: Remove a portion of an array

Syntax: DROP(array, rows,[columns])

EXPAND

Description: Expand an array by adding rows or columns

Syntax: EXPAND(array, rows,[columns], [pad_with])

FILTER

Description: Filter a range based on given criteria

Syntax: FILTER(array, include,[if_empty])

HSTACK

Description: Merge ranges or arrays horizontally

Syntax: HSTACK(array1,[array2] ...)

ISOMITTED

Description: Check for optional arguments in LAMBDAs

Syntax: ISOMITTED(argument)

LAMBDA

Description: Create a custom function

Syntax: LAMBDA(parameter_or_calculation,[parameter_or_calculation]..)

LET

Description: Assign variables within a formula

Syntax: LET(name1, name_value1, calculation_or_name2,[name_value2, calculation_or_name3],..)

MAKEARRAY

Description: Generate an array with calculated values

Syntax: MAKEARRAY(rows, columns, function)

MAP

Description: Apply a custom function to an array

Syntax: MAP(array, lambda_or_array2,[lambda_or_array3]…)

RANDARRAY

Description: Generate an array of random numbers

Syntax: RANDARRAY([rows], [columns], [min], [max], [integer])

REDUCE

Description: Reduce an array

Syntax: REDUCE(initial_value, array, function)

SCAN

Description: Scan an array and return intermediate results

Syntax: SCAN(initial_value, array, function)

SEQUENCE

Description: Generate an array of sequential numbers

Syntax: SEQUENCE(rows,[columns], [start], [step])

SORT

Description: Sort a range or array

Syntax: SORT(array,[sort_index], [sort_order], [by_col])

SORTBY

Description: Sort a range or array by column

Syntax: SORTBY(array, by_array1,[sort_order1],...)

STOCKHISTORY

Description: Retrieve stock price information

Syntax: STOCKHISTORY(stock, start_date,[end_date], [interval], [headers], [properties1] ...)

TAKE

Description: Obtain a subset of an array

Syntax: TAKE(array, rows,[columns])

TEXTAFTER

Description: Extract text after a specified delimiter

Syntax: TEXTAFTER(text, delimiter,[instance_num], [match_mode], [match_end], [if_not_found])

TEXTBEFORE

Description: Extract text before a specified delimiter

Syntax: TEXTBEFORE(text, delimiter,[instance_num], [match_mode], [match_end], [if_not_found])

TEXTSPLIT

Description: Split a text string using a delimiter

Syntax: TEXTSPLIT(text, col_delimiter,[row_delimiter], [ignore_empty], [match_mode], [pad_with])

TOCOL

Description: Transform an array into a single column

Syntax: TOCOL(array,[ignore], [scan_by_column])

TOROW

Description: Transform an array into a single row

Syntax: TOROW(array,[ignore], [scan_by_column])

UNIQUE

Description: Extract unique values from a range

Syntax: UNIQUE(array,[by_col], [exactly_once])

VALUETOTEXT

Description: Convert a value into a text string

Syntax: VALUETOTEXT(value,[format])

VSTACK

Description: Merge ranges or arrays vertically

Syntax: VSTACK(array1,[array2] ...)

WRAPCOLS

Description: Organize an array into columns

Syntax: WRAPCOLS(vector, wrap_count,[pad_with])

WRAPROWS

Description: Organize an array into rows

Syntax: WRAPROWS(vector, wrap_count,[pad_with])

XLOOKUP

Description: Look up values in a range or array

Syntax: XLOOKUP(lookup_value, lookup_array, return_array,[if_not_found], [match_mode], [search_mode])

XMATCH

Description: Determine the position of an item in a list or table

Syntax: XMATCH(lookup_value, lookup_array,[match_mode], [search_mode])

Engineering

BIN2DEC

Description: Convert a binary number to decimal

Syntax: BIN2DEC(number)

BIN2HEX

Description: Convert a binary number to hexadecimal

Syntax: BIN2HEX(number,[places])

BIN2OCT

Description: Convert a binary number to octal

Syntax: BIN2OCT(number,[places])

BITAND

Description: Perform a 'Bitwise And' operation on two numbers

Syntax: BITAND(number1, number2)

BITLSHIFT

Description: Shift a number left by a specified number of bits

Syntax: BITLSHIFT(number, shift_amount)

BITOR

Description: Perform a 'Bitwise Or' operation on two numbers

Syntax: BITOR(number1, number2)

BITRSHIFT

Description: Shift a number right by a specified number of bits

Syntax: BITRSHIFT(number, shift_amount)

BITXOR

Description: Perform a 'Bitwise Xor' operation on two numbers

Syntax: BITXOR(number1, number2)

COMPLEX

Description: Convert coefficients into a complex number

Syntax: COMPLEX(real_num, i_num,[suffix])

CONVERT

Description: Convert measurement units

Syntax: CONVERT(number, from_unit, to_unit)

DEC2BIN

Description: Convert a decimal number to binary

Syntax: DEC2BIN(number,[places])

DEC2HEX

Description: Convert a decimal number to hexadecimal

Syntax: DEC2HEX(number,[places])

DEC2OCT

Description: Convert a decimal number to octal

Syntax: DEC2OCT(number,[places])

DELTA

Description: Test if two values are equal

Syntax: DELTA(number1,[number2])

HEX2BIN

Description: Convert a hexadecimal number to binary.

Syntax: HEX2BIN(number,[places])

HEX2DEC

Description: Convert a hexadecimal number to decimal

Syntax: HEX2DEC(number)

HEX2OCT

Description: Convert a hexadecimal number to octal

Syntax: HEX2OCT(number,[places])

IMABS

Description: Obtain the absolute value of a complex number

Syntax: IMABS(inumber)

IMAGINARY

Description: Retrieve the imaginary coefficient of a complex number

Syntax: IMAGINARY(inumber)

IMPOWER

Description: Raise a complex number to a given power

Syntax: IMPOWER(inumber, number)

IMPRODUCT

Description: Calculate the product of complex numbers

Syntax: IMPRODUCT(inumber1,[inumber2] ...)

IMREAL

Description: Retrieve the real coefficient of a complex number

Syntax: IMREAL(inumber)

IMSUB

Description: Calculate the difference between two complex numbers

Syntax: IMSUB()

IMSUM

Description: Calculate the sum of complex numbers

Syntax: IMSUM(inumber1,[inumber2]…)

Financial

ACCRINT

Description: Determine accrued interest periodically

Syntax: ACCRINT(issue, first_interest, settlement, rate, par, frequency,[basis], [calc_method])

ACCRINTM

Description: Calculate accrued interest at maturity

Syntax: ACCRINTM(issue, settlement, rate, par,[basis])

AMORDEGRC

Description: Obtain the depreciation coefficient for an accounting period

Syntax: AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate,[basis])

AMORLINC

Description: Calculate depreciation for an accounting period

Syntax: AMORLINC(cost, date_purchased, first_period, salvage, period, rate,[basis])

COUPDAYBS

Description: Determine days from the coupon period to the settlement date

Syntax: COUPDAYBS(settlement, maturity, frequency,[basis])

COUPDAYS

Description: Calculate days in the coupon period including the settlement date

Syntax: COUPDAYS(settlement, maturity, frequency,[basis])

COUPDAYSNC

Description: Determine days from the settlement date to the next coupon date

Syntax: COUPDAYSNC(settlement, maturity, frequency,[basis])

COUPNCD

Description: Obtain the next coupon date after the settlement date

Syntax: COUPNCD(settlement, maturity, frequency,[basis])

COUPNUM

Description: Determine the number of payable coupons

Syntax: COUPNUM(settlement, maturity, frequency,[basis])

COUPPCD

Description: Obtain the previous coupon date before the settlement date

Syntax: COUPPCD(settlement, maturity, frequency,[basis])

CUMIPMT

Description: Calculate cumulative interest paid on a loan

Syntax: CUMIPMT(rate, nper, pv, start_period, end_period, type)

CUMPRINC

Description: Calculate cumulative principal paid on a loan

Syntax: CUMPRINC(rate, nper, pv, start_period, end_period, type)

DB

Description: Calculate depreciation using fixed-declining balance method

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

DDB

Description: Calculate depreciation using double-declining method

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

DISC

Description: Obtain the discount rate for a security

Syntax: DISC(settlement, maturity, pr, redemption,[basis])

DOLLARDE

Description: Convert a dollar price as a fraction to decimal

Syntax: DOLLARDE(fractional_dollar, fraction)

DOLLARFR

Description: Convert price to fractional notation

Syntax: DOLLARFR(decimal_dollar, fraction)

DURATION

Description: Determine annual duration with periodic interest

Syntax: DURATION(settlement, maturity, coupon, yld, frequency,[basis])

EFFECT

Description: Obtain the effective annual interest rate

Syntax: EFFECT(nominal_rate, npery)

FV

Description: Calculate the future value of an investment

Syntax: FV(rate, nper, pmt,[pv], [type])

FVSCHEDULE

Description: Calculate the future value of principal with compound interest

Syntax: FVSCHEDULE(principal, schedule)

INTRATE

Description: Determine the interest rate for a fully invested security

Syntax: INTRATE(settlement, maturity, investment, redemption,[basis])

IPMT

Description: Obtain interest for a given period

Syntax: IPMT(rate, per, nper, pv,[fv], [type])

IRR

Description: Calculate the internal rate of return

Syntax: IRR(values, )

ISPMT

Description: Determine interest paid for a specific period

Syntax: ISPMT(rate, per, nper, pv)

MDURATION

Description: Obtain Macauley modified duration for a par value of $100

Syntax: MDURATION(settlement, maturity, coupon, yld, frequency,[basis])

MIRR

Description: Calculate the modified internal rate of return

Syntax: MIRR(values, finance_rate, reinvest_rate)

NOMINAL

Description: Determine annual nominal interest rate

Syntax: NOMINAL(effect_rate, npery)

NPER

Description: Determine the number of periods for a loan or investment

Syntax: NPER(rate, pmt, pv,[fv], [type])

NPV

Description: Calculate net present value

Syntax: NPV(rate, value1,[value2] ...)

ODDFPRICE

Description: Obtain price per $100 for an odd first period

Syntax: ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency,[basis])

ODDFYIELD

Description: Determine yield for a security with an odd first period

Syntax: ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency,[basis])

ODDLPRICE

Description: Obtain price per $100 face value with an odd last period

Syntax: ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency,[basis])

ODDLYIELD

Description: Determine yield for a security with an odd last period

Syntax: ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency,[basis])

PDURATION

Description: Determine periods required to reach a given value

Syntax: PDURATION(rate, pv, fv)

PMT

Description: Calculate the periodic payment for a loan

Syntax: PMT(rate, nper, pv,[fv], [type])

PPMT

Description: Determine principal payment in a given period

Syntax: PPMT(rate, per, nper, pv,[fv], [type])

PRICE

Description: Obtain price per $100 face value with periodic interest

Syntax: PRICE(settlement, maturity, rate, yld, redemption, frequency,[basis])

PRICEDISC

Description: Obtain price per $100 for a discounted security

Syntax: PRICEDISC(settlement, maturity, discount, redemption,[basis])

PRICEMAT

Description: Obtain price per $100 for interest at maturity

Syntax: PRICEMAT(settlement, maturity, issue, rate, yld,[basis])

PV

Description: Calculate the present value of an investment

Syntax: PV(rate, nper, pmt,[fv], [type])

RATE

Description: Obtain the interest rate per period for an annuity

Syntax: RATE(nper, pmt, pv,[fv], [type], [guess])

RECEIVED

Description: Determine the amount received at maturity

Syntax: RECEIVED(settlement, maturity, investment, discount,[basis])

RRI

Description: Obtain equivalent interest rate for growth

Syntax: RRI(nper, pv, fv)

SLN

Description: Calculate straight-line depreciation

Syntax: SLN(cost, salvage, life)

SYD

Description: Calculate sum-of-years depreciation

Syntax: SYD(cost, salvage, life, per)

TBILLEQ

Description: Obtain bond-equivalent yield for a Treasury bill

Syntax: TBILLEQ(settlement, maturity, discount)

TBILLPRICE

Description: Obtain price per $100 for a Treasury bill

Syntax: TBILLPRICE(settlement, maturity, discount)

TBILLYIELD

Description: Determine yield for a Treasury bill

Syntax: TBILLYIELD(settlement, maturity, pr)

VDB

Description: Calculate double-declining variable depreciation

Syntax: VDB(cost, salvage, life, start_period, end_period,[factor], [no_switch])

XIRR

Description: Calculate internal rate of return for irregular cash flows

Syntax: XIRR(values, dates,[guess])

XNPV

Description: Calculate net present value for irregular cash flows

Syntax: XNPV(rate, values, dates)

YIELD

Description: Determine yield for a security with periodic interest

Syntax: YIELD(settlement, maturity, rate, pr, redemption, frequency,[basis])

YIELDDISC

Description: Obtain annual yield for a discounted security

Syntax: YIELDDISC(settlement, maturity, pr, redemption,[basis])

YIELDMAT

Description: Determine annual yield for interest at maturity

Syntax: YIELDMAT(settlement, maturity, issue, rate, pr,[basis])

Information

CELL

Description: Retrieve information about a cell

Syntax: CELL(info_type,[reference])

ERROR.TYPE

Description: Test for a specific error value

Syntax: ERROR.TYPE(error_val)

INFO

Description: Retrieve information about the current environment

Syntax: INFO(type_text)

ISBLANK

Description: Test if a cell is empty

Syntax: ISBLANK(value)

ISERR

Description: Test for any error except #N/A

Syntax: ISERR(value)

ISERROR

Description: Test for any error

Syntax: ISERROR(value)

ISEVEN

Description: Test if a value is even

Syntax: ISEVEN(value)

ISFORMULA

Description: Test if a cell contains a formula

Syntax: ISFORMULA(reference)

ISLOGICAL

Description: Test if a value is logical

Syntax: ISLOGICAL(value)

ISNA

Description: Test for the #N/A error

Syntax: ISNA(value)

ISNONTEXT

Description: Test for a non-text value

Syntax: ISNONTEXT(value)

ISNUMBER

Description: Test for a numeric value

Syntax: ISNUMBER(value)

ISODD

Description: Test if a value is odd

Syntax: ISODD(value)

ISREF

Description: Test for a reference

Syntax: ISREF(value)

ISTEXT

Description: Test for a text value

Syntax: ISTEXT(value)

N

Description: Convert a value into a number

Syntax: N(value)

NA

Description: Create an #N/A error

Syntax: NA()

SHEET

Description: Obtain the sheet index number

Syntax: SHEET(value)

SHEETS

Description: Obtain the number of sheets in a reference

Syntax: SHEETS(reference)

T

Description: Filter text values only

Syntax: T(value)

TYPE

Description: Determine the type of value in a cell

Syntax: TYPE(value)

Mathametical

ABS

Description: Find the absolute value of a number

Syntax: ABS(number)

AGGREGATE

Description: Return aggregate calculations

Syntax: AGGREGATE(function_num, options, array,[k])

ARABIC

Description: Convert Roman numerals to Arabic numerals

Syntax: ARABIC(text)

BASE

Description: Convert a number to another base

Syntax: BASE(number, radix,[min_length])

CEILING

Description: Round a number up to the nearest multiple

Syntax: CEILING()

CEILING.MATH

Description: Round a number up to the nearest multiple

Syntax: CEILING.MATH(number,[significance], [mode])

CEILING.PRECISE

Description: Round a number up to the nearest multiple

Syntax: CEILING.PRECISE(number,[significance])

COMBIN

Description: Determine the number of combinations without repetitions

Syntax: COMBIN(number, number_chosen)

COMBINA

Description: Determine the number of combinations with repetitions

Syntax: COMBINA(number, number_chosen)

DECIMAL

Description: Convert a number in a different base to a decimal number

Syntax: DECIMAL(number, radix)

EVEN

Description: Round a number up to the next even integer

Syntax: EVEN(number)

EXP

Description: Find the value of e raised to the power of a number

Syntax: EXP(number)

FACT

Description: Find the factorial of a number

Syntax: FACT(number)

FACTDOUBLE

Description: Obtain the double factorial of a number

Syntax: FACTDOUBLE(number)

FLOOR

Description: Round a number down to the nearest specified multiple

Syntax: FLOOR(number, significance)

FLOOR.MATH

Description: Round a number down to the nearest multiple

Syntax: FLOOR.MATH(number,[significance], [mode])

FLOOR.PRECISE

Description: Round a number down to the nearest multiple

Syntax: FLOOR.PRECISE(number,[significance])

GCD

Description: Determine the greatest common divisor of number

Syntax: GCD(number1,[number2] ...)

INT

Description: Obtain the integer part of a number by rounding down

Syntax: INT(number)

LCM

Description: Determine the least common multiple of numbers

Syntax: LCM(number1,[number2] ...)

LN

Description: Calculate the natural logarithm of a given number

Syntax: LN(number)

LOG

Description: Find the logarithm of a number

Syntax: LOG(number,[base])

LOG10

Description: Calculate the base-10 logarithm of a number

Syntax: LOG10(number)

MDETERM

Description: Compute the determinant of a given matrix

Syntax: MDETERM(array)

MINVERSE

Description: Find the inverse matrix of an array

Syntax: MINVERSE(array)

MMULT

Description: Perform matrix multiplication on specified arrays

Syntax: MMULT(array1, array2)

MOD

Description: Obtain the remainder after division

Syntax: MOD(number, divisor)

MROUND

Description: Round a number to the nearest specified multiple

Syntax: MROUND(number, multiple)

MUNIT

Description: Generate a unit matrix for a given dimension

Syntax: MUNIT(dimension)

ODD

Description: Round a number up to the next odd integer

Syntax: ODD(number)

PI

Description: Retrieve the value of π (pi)

Syntax: PI()

POWER

Description: Raise a number to a specific power

Syntax: POWER(number, power)

PRODUCT

Description: Calculate the product of supplied numbers

Syntax: PRODUCT(number1,[number2] ...)

QUOTIENT

Description: Determine the quotient without a remainder

Syntax: QUOTIENT(numerator, denominator)

RAND

Description: Generate a random number between 0 and 1

Syntax: RAND()

RANDBETWEEN

Description: Get a random integer within a specified range

Syntax: RANDBETWEEN(bottom, top)

ROMAN

Description: Convert numbers into Roman numerals

Syntax: ROMAN(number,[form])

ROUND

Description: Round a number to a specified number of digits

Syntax: ROUND(number, num_digits)

ROUNDDOWN

Description: Round down a number to a given number of digits

Syntax: ROUNDDOWN(number, num_digits)

ROUNDUP

Description: Round up a number to a specified number of digits

Syntax: ROUNDUP(number, num_digits)

SIGN

Description: Determine the sign of a number

Syntax: SIGN(number)

SQRT

Description: Find the positive square root of a number

Syntax: SQRT(number)

SUBTOTAL

Description: Obtain a subtotal in a list or database

Syntax: SUBTOTAL(function_num, ref1,[ref2] ...)

SUM

Description: Add numbers together

Syntax: SUM(number1,[number2]...)

SUMIF

Description: Sum cells in a range that meet specific criteria

Syntax: SUMIF(range, criteria,[sum_range])

SUMIFS

Description: Sum cells in a range that meet multiple criteria

Syntax: SUMIFS(sum_range, criteria_range1, criteria1,[criteria_range2, criteria2]...)

SUMPRODUCT

Description: Calculate the sum of squares of product values

Syntax: SUMPRODUCT(array1,[array2]...)

SUMSQ

Description: Calculate the sum of the squares of the provided values

Syntax: SUMSQ(number1,[number2]...)

SUMX2MY2

Description: Determine the sum of the differences between the squares in two arrays

Syntax: SUMX2MY2(array_x, array_y)

SUMX2PY2

Description: Compute the sum of the squares within two arrays

Syntax: SUMX2PY2(array_x, array_y)

SUMXMY2

Description: Calculate the sum of the squares of the differences in two arrays

Syntax: SUMXMY2(array_x, array_y)

TRUNC

Description: Round a number to a specified precision

Syntax: TRUNC(number,[num_digits])

Trigonometry

ACOS

Description: Calculate the arccosine of a value in radians

Syntax: ACOS(number)

ASIN

Description: Calculate the arcsine of a value in radians

Syntax: ASIN(number)

ATAN

Description: Compute the arctangent of a number

Syntax: ATAN(number)

ATAN2

Description: Compute the arctangent from x- and y-coordinates

Syntax: ATAN2(x_num, y_num)

COS

Description: Determine the cosine of an angle in radians

Syntax: COS(number)

COSH

Description: Find the hyperbolic cosine of a number

Syntax: COSH(number)

COT

Description: Calculate the cotangent of an angle

Syntax: COT(number)

CSC

Description: Determine the cosecant of an angle

Syntax: CSC(number)

DEGREES

Description: Convert radians to degrees

Syntax: DEGREES(angle)

RADIANS

Description: Convert degrees to radians

Syntax: RADIANS(angle)

SEC

Description: Calculate the secant of an angle

Syntax: SEC(number)

SIN

Description: Determine the sine of an angle in radians

Syntax: SIN(number)

SINH

Description: Find the hyperbolic sine of a number

Syntax: SINH(number)

TAN

Description: Calculate the tangent of an angle

Syntax: TAN(number)

Statistical

AVEDEV

Description: Calculate the sum of squared deviations

Syntax: AVEDEV(number1,[number2] ...)

AVERAGE

Description: Compute the average of a group of numbers

Syntax: AVERAGE(number1,[number2] ...)

AVERAGEA

Description: Determine the average of a group of numbers and text

Syntax: AVERAGEA(value1,[value2] ...)

AVERAGEIF

Description: Find the average of numbers that meet specific criteria

Syntax: AVERAGEIF(range, criteria,[average_range])

AVERAGEIFS

Description: Average cells that match multiple criteria

Syntax: AVERAGEIFS(average_range, criteria_range1, criteria1,[criteria_range2, criteria2]...)

BINOM.DIST

Description: Calculate the probability of a binomial distribution

Syntax: BINOM.DIST(number_s, trials, probability_s, cumulative)

BINOMDIST

Description: Find the probability of a binomial distribution

Syntax: BINOMDIST(number_s, trials, probability_s, cumulative)

COUNT

Description: Count numbers in a dataset

Syntax: COUNT(value1,[value2] ...)

COUNTA

Description: Count the number of non-blank cells

Syntax: COUNTA(value1,[value2] ...)

COUNTBLANK

Description: Count cells that are blank

Syntax: COUNTBLANK(range)

COUNTIF

Description: Count cells that match specific criteria

Syntax: COUNTIF(range, criteria)

COUNTIFS

Description: Count cells that match multiple criteria

Syntax: COUNTIFS(criteria_range1, criteria1,[criteria_range2, criteria2]...)

DEVSQ

Description: Calculate the sum of squared deviations

Syntax: DEVSQ(number1,[number2] ...)

FORECAST

Description: Predict a value along a linear trend

Syntax: FORECAST(x, known_ys, kown_xs)

FORECAST.ETS

Description: Predict a value with a seasonal trend

Syntax: FORECAST.ETS(target_date, values, timeline,[seasonality], [data_completion], [aggregation])

FORECAST.ETS.CONFINT

Description: Obtain the confidence interval for a forecasted value at a given date

Syntax: FORECAST.ETS.CONFINT(target_date, values, timeline,[confidence_level], [seasonality], [data_completion], [aggregation])

FORECAST.ETS.SEASONALITY

Description: Determine the length of the seasonal pattern

Syntax: FORECAST.ETS.SEASONALITY(values, timeline,[data_completion], [aggregation])

FORECAST.ETS.STAT

Description: Get statistical values related to forecasting

Syntax: FORECAST.ETS.STAT(values, timeline, statistic_type,[seasonality], [data_completion], [aggregation])

FORECAST.LINEAR

Description: Predict a value along a linear trend

Syntax: FORECAST.LINEAR(x, known_ys, kown_xs)

FREQUENCY

Description: Find the frequency of values in a dataset

Syntax: FREQUENCY(data_array, bins_array)

GEOMEAN

Description: Calculate the geometric mean

Syntax: GEOMEAN(number1,[number2] ...)

HARMEAN

Description: Calculate the harmonic mean

Syntax: HARMEAN(number1,[number2] ...)

INTERCEPT

Description: Determine the intercept of a linear regression line

Syntax: INTERCEPT(known_ys, known_xs)

LARGE

Description: Find the nth largest value

Syntax: LARGE(array, k)

LINEST

Description: Get parameters of a linear trend

Syntax: LINEST(known_ys,[known_xs], [const], [stats])

MAX

Description: Find the largest value

Syntax: MAX(number1,[number2] ...)

MAXA

Description: Return the largest value

Syntax: MAXA(value1,[value2] ...)

MAXIFS

Description: Get the maximum value with specific criteria

Syntax: MAXIFS(max_range, range1, criteria1, range2 criteria2 …)

MEDIAN

Description: Calculate the median of a group of numbers

Syntax: MEDIAN(number1, number2 …)

MIN

Description: Find the smallest value

Syntax: MIN(number1, number2 …)

MINA

Description: Return the smallest value

Syntax: MINA(value1 value2 …)

MINIFS

Description: Get the minimum value with specific criteria

Syntax: MINIFS(max_range, criteria_range1, criteria1,[criteria_range2, criteria2]...)

MODE

Description: Find the most frequently occurring number

Syntax: MODE(number1,[number2] ...)

MODE.MULT

Description: Find the most frequently occurring numbers

Syntax: MODE.MULT(number1,[number2] ...)

MODE.SNGL

Description: Find the most frequently occurring number

Syntax: MODE.SNGL(number1,[number2] ...)

NORM.DIST

Description: Obtain values and areas for the normal distribution

Syntax: NORM.DIST(x, mean, standard_dev, cumulative)

NORM.INV

Description: Calculate the inverse of the normal cumulative distribution

Syntax: NORM.INV(probability, mean, standard_dev)

NORM.S.DIST

Description: Get the standard normal CDF and PDF

Syntax: NORM.S.DIST(z, cumulative)

NORM.S.INV

Description: Find the inverse of the standard normal cumulative distribution

Syntax: NORM.S.INV(probability)

PERCENTILE

Description: Calculate the kth percentile

Syntax: PERCENTILE(array, k)

PERCENTILE.EXC

Description: Find the kth percentile

Syntax: PERCENTILE.EXC(array, k)

PERCENTILE.INC

Description: Determine the kth percentile

Syntax: PERCENTILE.INC(array, k)

PERCENTRANK

Description: Calculate percentile rank, inclusive

Syntax: PERCENTRANK(array, x,[significance])

PERCENTRANK.EXC

Description: Calculate percentile rank, exclusive

Syntax: PERCENTRANK.EXC(array, x,[significance])

PERCENTRANK.INC

Description: Determine percentile rank, inclusive

Syntax: PERCENTRANK.INC(array, x,[significance])

PERMUT

Description: Find the number of permutations without repetitions

Syntax: PERMUT(number, number_chosen)

PERMUTATIONA

Description: Find the number of permutations with repetitions

Syntax: PERMUTATIONA(number, number_chosen)

QUARTILE

Description: Get the quartile in a dataset

Syntax: QUARTILE(array, quart)

QUARTILE.EXC

Description: Determine the quartile in a dataset

Syntax: QUARTILE.EXC(array, quart)

QUARTILE.INC

Description: Find the quartile in a dataset

Syntax: QUARTILE.INC(array, quart)

RANK

Description: Rank a number against a range of numbers

Syntax: RANK(number, ref,[order])

RANK.AVG

Description: Rank a number against a range of numbers

Syntax: RANK.AVG(number, ref,[order])

RANK.EQ

Description: Rank a number against a range of numbers

Syntax: RANK.EQ(number, ref,[order])

SKEW

Description: Calculate the skewness of a distribution

Syntax: SKEW(number1,[number2] ...)

SKEW.P

Description: Find the skewness of a distribution based on population

Syntax: SKEW.P(number1,[number2] ...)

SLOPE

Description: Determine the slope of a linear regression line

Syntax: SLOPE(known_ys, known_xs)

SMALL

Description: Find the nth smallest value

Syntax: SMALL(array, k)

STANDARDIZE

Description: Calculate a normalized value (z-score)

Syntax: STANDARDIZE(x, mean, standard_dev)

STDEV

Description: Get the standard deviation in a sample

Syntax: STDEV(number1,[number2] ...)

STDEV.P

Description: Calculate the standard deviation of a population

Syntax: STDEV.P(number1,[number2] ...)

STDEV.S

Description: Find the standard deviation in a sample

Syntax: STDEV.S(number1,[number2] ...)

STDEVA

Description: Calculate the standard deviation in a sample

Syntax: STDEVA(number1,[number2] ...)

STDEVP

Description: Find the standard deviation of a population

Syntax: STDEVP(number1,[number2] ...)

STDEVPA

Description: Calculate the standard deviation for a population

Syntax: STDEVPA(number1,[number2] ...)

TRIMMEAN

Description: Calculate the mean excluding outliers

Syntax: TRIMMEAN(array, percent)

VAR

Description: Get the variation of a sample

Syntax: VAR(number1,[number2] ...)

VAR.P

Description: Find the variation of a population

Syntax: VAR.P(number1,[number2] ...)

VAR.S

Description: Get the variation of a sample

Syntax: VAR.S(number1,[number2] ...)

VARA

Description: Get the variation of a sample

Syntax: VARA(number1,[number2] ...)

VARP

Description: Find the variation of a population

Syntax: VARP(number1,[number2] ...)

VARPA

Description: Get the variation of a population

Syntax: VARPA(number1,[number2] ...)

Web

ENCODEURL

Description: Obtain a URL-encoded string

Syntax: ENCODEURL(text)

FILTERXML

Description: Retrieve data from XML using XPath

Syntax: FILTERXML(xml, xpath)

WEBSERVICE

Description: Fetch data from a web service

Syntax: WEBSERVICE(url)

Database

DAVERAGE

Description: Calculate the average from matching records

Syntax: DAVERAGE(database, field, criteria)

DCOUNT

Description: Count matching records in a database

Syntax: DCOUNT(database, field, criteria)

DCOUNTA

Description: Count matching records in a database

Syntax: DCOUNTA(database, field, criteria)

DGET

Description: Retrieve a value from a matching record

Syntax: DGET(database, field, criteria)

DMAX

Description: Find the maximum from matching records

Syntax: DMAX(database, field, criteria)

DMIN

Description: Find the minimum from matching records

Syntax: DMIN(database, field, criteria)

DPRODUCT

Description: Calculate the product from matching records

Syntax: DPRODUCT(database, field, criteria)

DSTDEV

Description: Compute the standard deviation of a sample in matching records

Syntax: DSTDEV(database, field, criteria)

DSTDEVP

Description: Compute the standard deviation of a population in matching records

Syntax: DSTDEVP(database, field, criteria)

DSUM

Description: Calculate the sum from matching records

Syntax: DSUM(database, field, criteria)

DVAR

Description: Calculate the sample variance for matching records

Syntax: DVAR(database, field, criteria)

DVARP

Description: Calculate the population variance for matching records

Syntax: DVARP(database, field, criteria)