Skip to main content

Excel Functions Guide | ExtendOffice


Cube

Description

Arguments

CUBEKPIMEMBER Returns the key performance indicator (KPI) property connection, kpi_name, kpi_property, [caption]
CUBEMEMBER Returns a member or tuple from a cube connection, member_expression, [caption]
CUBESET Returns a calculated set of members or tuples connection, set_expression, [caption], [sort_order], [sort_by]
CUBESETCOUNT Returns the number of items in a set set
CUBEVALUE Returns an aggregated value from a cube filtered by multiple member_expression arguments connection, [member_expression1], [member_expression2], …

Database

Description

Arguments

DAVERAGE Returns average that matches the specific criteria database, field, criteria
DCOUNT Counts the cells that contain numbers in a field of records in a databased which match the specified criteria database, field, criteria
DCOUNTA Counts the cells that in a field of records in a databased which match the specified criteria database, field, criteria
DGET Returns a single value in the given field of the database that matches the criteria database, field, criteria
DMAX Returns max that matches the specific criteria database, field, criteria
DMIN Returns min that matches the specific criteria database, field, criteria
DPRODUCT Returns product that matches the specific criteria database, field, criteria
DSTDEV Returns the estimated value of a population’s standard deviation based on a sample by using the values from the sample database that match the given criteria you specify database, field, criteria
DSTDEVP Returns the standard deviation of a population by using the numbers from the entire database that match the given criteria you specify database, field, criteria
DSUM Returns the sum of numbers from a database that match the given criteria database, field, criteria
DVAR Estimates the variance of a sample retrieved from a field that matches the given conditions database, field, criteria
DVARP Returns the variance for an entire population retrieved from a field that matches the given conditions database, field, criteria

Date and Time

Description

Arguments

DATE Creates date with year, month and day year, month, day
DATEDIF Returns the years, months or days between two dates start_date, end_date, unit
DATEVALUE Converts a date stored as text format to a valid date date_text
DAY Gets the day as a number (1 to 31) from a date date
DAYS Gets the number of days between two dates start_date, end_date
DAYS360 Gets the number of days between 2 dates in a 360-day year start_date, end_date, [method]
EDATE Adds n months for a date start_date, months
EOMONTH Gets the last day of month n months in future or past start_date, months
ISOWEEKNUM Gets ISO week number from a given date date
HOUR Gets the hour as a number (0 to 23) from a date time serial_number
MINUTE Returns the minute as number (0 to 59) from time serial_number
MONTH Gets the month as integer number (1 to 12) from date serial_number
NETWORKDAYS Gets the number of working days between two dates start_date, end_date, [holidays]
NETWORKDAYS.INTL Gets workdays between two dates start_date, end_date, [weekend], [holidays]
NOW Gets the current date and time //
SECOND Returns the seconds as number (0 to 59) from time serial_number
TIME Creates time with hours, minutes and seconds hour, minute, second
TIMEVALUE Gets time from a text string time_text
TODAY Gets the current date //
WEEKDAY Gets day of the week as a number (1 to 7) from date serial_number, [return_type]
WEEKNUM Returns the week number of the given date in a year serial_number, [return_type]
WORKDAY Adds workdays to the given start date and returns a workday start_date, days, [holidays]
WORKDAY.INTL Adds workdays to the given start date and returns a workday excluding custom weekend and holidays start_date, days, [weekend], [holidays]
YEAR Returns the year based on the given date in a 4-digit serial number format serial_number
YEARFRAC Calculates the fractional year in a decimal format between given dates start_date, end_date, [basis]

Engineering

Description

Arguments

BESSELI Calculates the modified Bessel function x, n
BESSELJ Returns the Bessel function, for a specified value x and order x, n
BESSELK Returns the modified Bessel functio x, n
BESSELY Returns the Bessel function x, n
BIN2DEC Converts a binary number to a decimal number number
BIN2HEX Converts a binary number to a hexadecimal number number, [places]
BIN2OCT Converts a binary number to an octal number number, [places]
BITAND Returns a decimal number representing the bitwise 'AND' of two supplied numbers number1, number2
BITLSHIFT Returns a decimal number shifted left by a specified number of bits number, shift_amount
BITOR Returns the bitwise ‘OR’ of two given numbers number1, number2
BITRSHIFT Returns the given number shifted right by the specified number of bits number, shift_amount
BITXOR Returns the bitwise ‘XOR’ of two given numbers number1, number2
COMPLEX Converts real and imaginary coefficients to a complex number real_num, i_num, [suffix]
CONVERT Converts a given number from one measurement system to another number, from_unit, to_unit
DEC2BIN Converts a decimal number to a binary number number, [places]
DEC2HEX Converts a decimal number to a hexadecimal number number, [places]
DEC2OCT Converts a decimal number to an octal number number, [places]
DELTA Compares two numeric values, and checks if they are equal number1, number2
ERF Returns the error function integrated between lower_limit and upper_limit lower_limit, [upper_limit]
ERF.PRECISE Returns the error function integrated between zero (0) and a limit x
ERFC Returns the complementary Error function integrated between a lower limit and infinity x
ERFC.PRECISE Returns the complementary Error function integrated between a limit and infinity x
GESTEP Checks whether the given number is greater than or equal to the given step value and returns 1 if TRUE and 0 if FALSE number, [step]
HEX2BIN Converts a hexadecimal number to a binary number number, [places]
HEX2DEC Converts a hexadecimal number to a binary number number
HEX2OCT Converts a hexadecimal number to a binary number number, [places]
IMABS Returns the absolute value of a complex number inumber
IMAGINARY Returns the imaginary coefficient of a given complex number inumber
IMARGUMENT Returns the angle expressed in radians of a given complex number inumber
IMCONJUGATE Returns the complex conjugate of a given complex number inumber
IMCOS Returns the cosine of a given complex number inumber
IMCOSH Returns the hyperbolic cosine of a given complex number inumber
IMCOT Returns the cotangent of a given complex number inumber
IMCSC Returns the cosecant of a given complex number inumber
IMCSCH Returns the hyperbolic cosecant of a given complex number inumber
IMDIV Calculates the quotient of two given complex numbers inumber1, inumber2
IMEXP Returns the exponential of a given complex number inumber
IMLN Returns the natural logarithm of a given complex number inumber
IMLOG2 Returns the base-2 logarithm of a given complex number inumber
IMLOG10 Returns the common (base 10) logarithm of a given complex number inumber
IMPOWER Returns a complex number raised to a given power inumber
IMPRODUCT Calculates the product of one or more complex numbers inumber1, [inumber2], ...
IMREAL Returns the real coefficient of a given complex number inumber
IMSEC Returns the secant of a complex number inumber
IMSECH Returns the hyperbolic secant of a complex number inumber
IMSIN Returns the sine of a complex number inumber
IMSINH Returns the hyperbolic sine of a complex number inumber
IMSQRT Returns the square root of a complex number inumber
IMTAN Returns the tangent of a given complex number inumber
IMSUB Returns the difference between two complex numbers inumber1, inumber2
IMSUM Calculates the sum of two or more complex numbers inumber1, [inumber2], ...
OCT2BIN Converts an octal number to a binary number number, [places]
OCT2DEC Converts an octal number to a decimal number number
OCT2HEX Converts an octal number to a hexadecimal number number, [places]

Financial

Description

Arguments

ACCRINT Returns accrued interest periodic issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]
ACCRINTM Returns accrued interest at maturity issue, settlement, rate, par, [basis]
AMORDEGRC Returns the linear depreciation of an asset for each accounting period by applying a depreciation coefficient based on the lifetime of the assets cost, date_purchased, first_period, salvage, period, rate, [basis]
AMORLINC Returns the linear depreciation of an asset for each accounting period cost, date_purchased, first_period, salvage, period, rate, [basis]
COUPDAYBS Returns the number of days between the beginning of the coupon period and its settlement date settlement, maturity, frequency, [basis]
COUPDAYS Returns the number of days in the coupon period including the settlement date settlement, maturity, frequency, [basis]
COUPDAYSNC Returns the calculated number of days from the settlement date to the next coupon date settlement, maturity, frequency, [basis]
COUPNCD Returns the next coupon date after the settlement date settlement, maturity, frequency, [basis]
COUPNUM Returns number of coupons payable between settlement date and maturity date settlement, maturity, frequency, [basis]
COUPPCD Returns previous coupon date before settlement date settlement, maturity, frequency, [basis]
CUMIPMT Returns the cumulative interest paid on a load between the start period and end period rate, nper, pv, start_period, end_period, type
CUMPRINC Calculates the cumulative principal paid on a load between the start period and end period rate, nper, pv, start_period, end_period, type
DB Returns the depreciation of an asset for a specified period by using a fixed-declining balance method cost, salvage, life, period, [month]
DDB Returns the depreciation of an asset for a specified period by using a double-declining balance method or other specific method cost, salvage, life, period, [factor]
DISC Returns the discount rate of a security settlement, maturity, pr, redemption, [basis]
DOLLARDE Converts a dollar value expressed in fractional notation to decimal fractional_dollar, fraction
DOLLARFR Converts a dollar value expressed in decimal to fractional notation decimal_dollar, fraction
DURATION Calculates the duration of a security that pays interest on a periodic basis settlement, maturity, coupon, yld, frequency,[basis]
EFFECT Calculates the effective annual interest rate nominal_rate, npery
FV Figures out the future value of an investment rate, nper, pmt, pv, type
FVSCHEDULE Figures out future value of a lump sum investment with adjustable interest rates principal, schedule
INTRATE Figures out the interest rate for a fully invested security settlement, maturity, investment, redemption, [basis]
IPMT Figures out the interest payment for the specified period for an investment or load rate, per, nper, pv, [fv], [type]
IRR Figures out the internal rate of return for a series of cash flows that occur at regular intervals values, [guess]
ISPMT Figures out interest payment of given period of an investment or loan rate, per, nper, pv
MDURATION Figures out the modified Macauley duration for a security settlement, maturity, coupon, yld, frequency, [basis]
MIRR Figures out modified internal rate of return for a series of cash flows values, finance_rate, reinvest_rate
NOMINAL Calculates the nominal annual interest rate effect_rate, npery
NPER Calculates the number of periods for investment or loan rate, pmt, pv, [fv], [type]
NPV Calculates the net present value of investment rate, value1, [value2], ...
ODDFPRICE Returns price per $100 face value with odd first period settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis]
ODDFYIELD Returns yield of security with odd first period settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis]
ODDLPRICE Returns price per $100 face value with odd last period settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis]
ODDLYIELD Returns yield of security with odd last period settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis]
PDURATION Returns the required number of periods for an investment to reach a specific value rate, pv, fv
PMT Returns the periodic payment required to pay off a loan rate, nper, pv, [fv], [type]
PPMT Returns the principal portion of a given loan payment rate, per, nper, pv, [fv], [type]
PRICE Returns the price of a bond per $100 face value that pays periodic interest settlement, maturity, rate, yld, redemption, frequency, [basis]
PRICEDISC Returns the price per $100 face value of a discounted security settlement, maturity, discount, redemption, [basis]
PRICEMAT Returns the price per $100 face value of a security that pays interests at maturity settlement, maturity, issue, rate, yld, [basis]
PV Returns the present value of a loan or an investment based on a constant interest rate rate, nper, pmt, [fv], [type]
RATE Returns the interest rate per period of an annuity nper, pmt, pv, [fv], [type], [guess]
RECEIVED Returns the amount received at maturity for a fully invested security settlement, maturity, investment, discount, [basis]
RRI Returns a numeric value. You can format the result to a percentage format nper, pv, fv
SLN Returns straight-line depreciation of asset for one period cost, salvage, life
SYD Returns sum-of-years’ depreciation of asset for given period cost, salvage, life, per
TBILLEQ Returns bond-equivalent yield for Treasury bill settlement, maturity, discount
TBILLPRICE Returns price per $100 for Treasury bill settlement, maturity, discount
TBILLYIELD Returns yield for Treasury bill settlement, maturity, pr
VDB Calculates depreciation using the double-declining balance method cost, salvage, life, start_period, end_period, [factor], [no_switch]
XIRR Calculates the internal rate of return for irregular cash flows values, dates, [guess]
XNPV Calculates the net present value for irregular cash flows rate, values, dates
YIELD Calculates the yield on a security that pays periodic interest settlement, maturity, rate, pr, redemption, frequency, [basis]
YIELDDISC Returns the annual yield for a discounted security settlement, maturity, pr, redemption, [basis]
YIELDMAT Returns the annual yield of a security that pays interest at maturity settlement, maturity, issue, rate, pr, [basis]

Information

Description

Arguments

CELL Returns the requested information about a specified cell info_type, [reference]
ERROR.TYPE Returns a number that corresponds to a specific error value error_val
INFO Returns details about the current operating environment type_text
ISBLANK Returns TRUE if a cell is empty or blank and FALSE otherwise value
ISERR Returns TRUE for any error type (except #N/A) and FALSE otherwise value
ISERROR Tests if an initial supplied expression or value returns an Excel error value
ISEVEN Tests if a supplied number (or numeric expression) is even number
ISFORMULA Tests if a cell contains formula reference
ISLOGICAL Tests if a supplied value or expression returns a logical value (TRUE and FALSE) value
ISNA Tests if a value or expression returns Excel #N/A error value
ISNONTEXT Returns TRUE if a given value is non-text value
ISNUMBER Returns TRUE if a given value is a number value
ISODD Returns TRUE if a given value is an odd number value
ISOMITTED Checks if the value is omitted in the LAMBDA function argument
ISREF Returns TRUE if a given value is a reference value
ISTEXT Returns TRUE if a given value is a text value
N Converts a value to a number value
NA Returns the #N/A error value //
SHEET Returns the index number of a reference sheet in Excel [value]
SHEETS Returns the number of sheets in a given reference [reference]
TYPE Returns the type of the given value value

Logical

Description

Arguments

AND Tests multiple conditions to return True or False logical1, [logical2], ...
BYCOL Applies a LAMBDA function to each column in a given array and returns the result per column as a single array array, lambda(column)
BYROW Applies a LAMBDA function to each row in a given array and returns the result per row as a single array array, lambda(row)
FALSE Generates the logical FALSE value //
IF Tests for a specific condition logical_test, [value_if_true], [value_if_false]
IFERROR Traps and deals with errors value, value_if_error
IFNA Traps and deals with #N/A errors value, value_if_na
IFS Tests multiple conditions to return the first match logical_test1, value_if_true1, [logical_test2, value_if_true2], ...
LAMBDA Creates custom functions that can be reused throughout a workbook [parameter1, parameter2, …], calculation
LET Assigns names to calculation results name1, name1_value, [name2/name2_value], ...,calculation
MAKEARRAY Returns a calculated array based on the given number of rows and columns rows, columns, lambda(r,c,calculation)
MAP Returns an array formed by mapping each value in the supplied array(s) to a new value array1, [array2], ..., lambda
NOT Reverses the arguments or results logical
OR Tests multiple conditions with OR logical1, [logical2], ...
REDUCE Returns the total value in the accumulator, reducing the array to an accumulated value [initial_value], array, lambda(accumulator, value)
SCAN Returns an array that contains the intermediate values while scanning the array [initial_value], array, lambda(accumulator, value)
SWITCH Matches multiple values, but returns the first match expression, value1, result1, [value2, result2], ..., [default]
TRUE Generates the logical TRUE value //
XOR Performs the exclusive OR function logical1, [logical2], ...

Lookup and Reference

Description

Arguments

ADDRESS Returns the cell address reference by column number and row number row_num, column_num, [abs_num], [a1], [sheet_text]
AREAS Returns the number of areas that make up the reference reference
CHOOSE Returns a value from the list of value argument by the given index number index_num, value1, [value2], ...
CHOOSECOLS Returns specified columns in an array or a range array, col_num1, [col_num2],...
CHOOSEROWS Returns specified rows in an array or a range array, row_num1, [row_num2],...
COLUMN Returns the number of column which formula appears or the column number of given reference reference
COLUMNS Returns the total number of columns in a given array or reference array
DROP Returns the specific rows or columns from an array based on the given number array, rows, [columns]
EXPAND Expands or pads an array to a specified number of rows and columns dimensions array, rows, [columns], [pad_with]
FIELDVALUE Retrieves field data from linked data types like Stocks or Geography data types value, field_name
FILTER Filters a range of data and dynamically returns the matching results array, include, [if_empty]
FORMULATEXT Returns a formula as a text string from a given reference reference
GETPIVOTDATA Returns data based on the pivot table structure data_field, pivot_table, [field1, item1], ...
HLOOKUP Looks a value in table by matching first row value, table, row_index, [range_lookup]
HSTACK Combines multiplearrays horizontally into one large array array1,[array2],...
HYPERLINK Creates a hyperlink which links to a given web page, a cell reference link_location, [friendly_name]
INDEX Returns the displayed value based on a given position from a range or an array array, row_num, [col_num], [area_num]
INDIRECT Converts a text string to a valid reference ref_text, [a1]
LOOKUP Finds certain value in a one-column range lookup_value, lookup_vector, [result_vector]
MATCH Gets the position of an item in an array lookup_value, lookup_array, [match_type]
OFFSET Returns a reference offset from a starting point reference, rows, cols, [height], [width]
ROW Returns row number of a reference [reference]
ROWS Returns the number of rows in a reference or an array array
SORT Sorts the contents of a range or array in ascending or descending order array, [sort_index], [sort_order], [by_col]
SORTBY Sorts the contents of one range or array based on the values in a corresponding range or array array, by_array1, [sort_order1], [by_array2, sort_order2],...
TAKE Returns a specified number of contiguous rows or columns from the start or end of a given array array, rows,[columns]
TOCOL Transforms an array or range to a single column array, [ignore], [scan_by_column]
TOROW Transforms an array or range to a single row array, [ignore], [scan_by_column]
TRANSPOSE Rotates the orientation of a range or array array
UNIQUE Extracts unique values from a range of data array, [by_col], [exactly_once]
VLOOKUP Looks a value in a table by matching on the first column and return value from a certain column lookup_value, Table_array, col_index, [range_lookup]
VSTACK Combines multiple arrays vertically into one large array array1,[array2],...
WRAPROWS Converts a single row or column into multiple rows by specifying the number of values in each row. avector, wrap_count, [pad_with]
WRAPCOLS Converts a single row or column into multiple columns by specifying the number of values in each column. vector, wrap_count, [pad_with]
XMATCH Returns relative position of a specified value in a vertical or horizontal array or range lookup_value, lookup_array, [match_mode], [search_mode]

Math and Trigonometry

Description

Arguments

ABS Returns the absolute value of number number
ACOS Returns the arccosine (inverse cosine) of number number
ACOSH Returns the inverse hyperbolic cosine of a number number
ACOT Returns the arccotangent (inverse cotangent) of number number
ACOTH Returns the inverse hyperbolic cotangent of a number number
AGGREGATE Returns based on the specific used function function_num, options, ref1, [ref2]
ARABIC Returns an arabic number by the given roman number text
ASIN Returns an angle of triangle in radians number
ASINH Returns the inverse hyperbolic sine of a number number
ATAN Returns the arctangent (inverse tangent) of a number number
ATAN2 Returns the arctangent (inverse tangent) of specified x- and y-coordinates x_num, y_num
ATANH Returns the inverse hyperbolic tangent of a number number
BASE Returns the text representation of the converted number to another base number, radix, [min_length]
CEILING Rounds number up to nearest multiple number, multiple
CEILING.MATH Rounds number up to nearest multiple or nearest integer number, [significance], [mode]
CEILING.PRECISE Returns a number that is rounded up to the nearest integer or to the nearest multiple of specified significance number, [significance]
COMBIN Returns the number of combinations for a given number of items number, number_chosen
COMBINA Returns the number of combinations for a specified number of items with repetitions allowed number, number_chosen
COS Returns the cosine of an angle given in radians number
COSH Returns the hyperbolic cosine of a given number number
COT Calculate the cotangent of an angle in radians number
COTH Returns the hyperbolic cotangent of a hyperbolic angle in radians number
CSC Returns the cosecant of an angle provided in radians array, number
CSCH Returns the hyperbolic cosecant of an angle provided in radians array, number
DECIMAL Returns decimal number text, radix
DEGREES Returns an angle in degrees angle
EVEN Rounds numbers away from zero to the nearest even integer number
EXP Returns the result of the constant e raised to the nth power number
FACT Returns the factorial of a given number number
FACTDOUBLE Returns the double factorial of a given number number
FLOOR Rounds a given number down to the nearest multiple of the specified significance number, significance
FLOOR.MATH Rounds a given number down to the nearest integer or nearest multiple of the specified significance number, [significance], [mode]
FLOOR.PRECISE Rounds a given number down to the nearest integer or nearest multiple of the specified significance number, [significance]
GCD Returns the greatest common divisor of two or more integers number1, [number2], ...
INT Returns the integer part of a number by rounding it down to the nearest integer number
ISO.CEILING Rounds up the nearest integer or the nearest multiple of significance number, [significance]
LCM Returns the least common multiple of integers number1, [number2], ...
LN Returns the natural logarithm of a given number number
LOG Returns the logarithm of a number using a specified base number, [base]
LOG10 Returns the base-10 logarithm of a given number number
MDETERM Returns the matrix determinant of an array array
MINVERSE Returns the inverse matrix of a given array array
MMULT Returns the matrix products of two arrays array1, array2
MOD Returns the remainder after division number, divisor
MROUND Returns a number rounded to the nearest specified multiple number, multiple
MULTINOMIAL Returns the ratio of the factorial of a sum of supplied values to the product of factorials of those values number1, [number2], ...
MUNIT Returns a unit matrix for specified dimension dimension
NEGBINOM.DIST Returns returns the negative binomial distribution number_f, number_s, probability_s, cumulative
ODD Rounds a number up to the nearest odd integer number
PI Returns the number 3.14159265358979 of the mathematical constant called pi //
POWER Returns the result of a number raised to a given power number, power
PRODUCT Calculates the product of cell values provides as arguments number1, [number2], ...
QUOTIENT Returns only the integer portion of a division numerator, denominator
RADIANS Converts degrees to radians angle
RAND Returns a random real number between 0 and 1 //
RANDBETWEEN Returns a random integer number between two given numbers bottom, top
ROMAN Converts an Arabic number to a Roman numeral as text number, [form]
ROUND Rounds a number to a specified number of digits number, num_digits
ROUNDDOWN Rounds a number up (toward zero) to a specified number of digits number, num_digits
ROUNDUP Rounds a number up (away from zero) to a specified number of digits number, num_digits
SEC Returns the secant of an angle provided in radians number
SECH Returns hyperbolic secant of an angle in radians number
SERIESSUM Returns sum of a power series x, n, m, coefficients
SIGN Returns sign of a number number
SIN Returns sine of an angle in radians number
SINH Returns hyperbolic sine of a number number
SQRT Returns square root of a number number
SQRTPI Returns square root of a supplied number multiplied by pi number
SUBTOTAL Returns subtotal in a list or database function_num, ref1, [ref2], ...
SUM Returns sum of numbers number1, [number2], …
SUMIF Returns the summation for a list of numbers based on the specific criteria range, criteria, sum_range
SUMIFS Returns the summation for a list of numbers that meet all specific criteria sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...
SUMPRODUCT Returns the result of multiplied and summed arrays array1, [array2], ...
SUMSQ Returns sum of squares of values number1, [number2], …
SUMX2MY2 Returns the sum of the difference of squares of corresponding values in two given arrays array_x, array_y
SUMX2PY2 Returns the sum of squares of corresponding values in two given arrays array_x, array_y
SUMXMY2 Returns the sum of squares of the differences of corresponding values in two given arrays array_x, array_y
TAN Returns the tangent value of an angle number
TANH Returns the hyperbolic tangent of a supplied number. number
TRUNC Returns a truncated number based on a given precision number, num_digits

Statistical

Description

Arguments

AVEDEV Returns the average of the absolute deviations of the numbers provided from their mean number1, [number2], ...
AVERAGE Returns the average (arithmetic mean) of the given numbers number1, [number2], ...
AVERAGEA Returns the average (arithmetic mean) of the supplied values value1, [value2], ...
AVERAGEIF Returns the average (arithmetic mean) of the numbers in a range that meet the given criteria range, criteria, [average_range]
AVERAGEIFS Returns the average (arithmetic mean) of the numbers in a range that meet one or more supplied criteria average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...
BETA.DIST Returns the beta distribution which is usually used to study the percentage variation of something across samples. x, alpha, beta, cumulative, [A], [B]
BETA.INV Returns the inverse of the cumulative beta probability density function for a specified beta distribution probability, alpha, beta, [A], [B]
BETADIST Rturns the cumulative beta probability density function x, alpha, beta, [A], [B]
BETAINV Rturns the inverse of the cumulative beta probability density function probability, alpha, beta, [A], [B]
BINOM.DIST Returns the individual term binominal distribution probability number_s, trials, probability_s, cumulative
BINOMDIST Returns the individual term binominal distribution probability number_s, trials, probability_s, cumulative
BINOM.DIST.RANGE Returns the binomial distribution probability for the number of successes from a specified number of trials falling into a specified range trials, probability_s, number_s, [number_s2]
BINOM.INV Returns the minimum value for which the cumulative binomial distribution is greater than or equal to a criterion trials, probability_s, alpha
CRITBINOM Returns the minimum value for which the cumulative binomial distribution is greater than or equal to a criterion trials, probability_s, alpha
CHISQ.DIST Returns the left-tailed probability of the chi-squared distribution x, deg_freedom, cumulative
CHISQ.DIST.RT Returns the right-tailed probability of the chi-squared distribution x, deg_freedom
CHISQ.INV Returns the inverse of the left-tailed probability of the chi-squared distribution probability, deg_freedom
CHISQ.INV.RT Returns the inverse of the right-tailed probability of the chi-squared distribution probability, deg_freedom
CHISQ.TEST Returns the chi-squared distribution of two provided data sets actual_range, expected_range
CONFIDENCE.NORM Uses a normal distribution to calculate the confidence interval for a population mean alpha, standard_dev, size
CONFIDENCE.T Uses a student’s distribution to calculate the confidence interval for a population mean alpha, standard_dev, size
CORREL Returns the correlation coefficient of two cell ranges array1, array2
COUNT Returns the number of cells contain numbers value1, [value2]
COUNTA Returns the number of cells excluding empty cells value1, [value2]
COUNTBLANK Returns the number of empty cells range
COUNTIF Returns the number of cells that meet acriterion range, criteria
COUNTIFS Returns the number of cells that meet multiple critera criteria_range1, criteria1, [criteria_range2], [criteria2], ...
COVARIANCE.P Returns the population variance of two data sets array1, array2
COVARIANCE.S Returns the sample variance of two data sets array1, array2
COVAR Returns the variance of two data sets array1, array2
DEVSQ Returns the sum of squares of the deviations from the sample mean number1, [number2], ...
EXPON.DIST Returns the exponential distribution based on the given x value and the parameter of the distribution array1, arry2, cumulative
EXPONDIST Returns the exponential distribution based on the given x value and the parameter of the distribution array1, arry2, cumulative 
F.DIST Returns the F probability distribution x, deg_freedom1, deg_freedom2, cumulative
FDIST Returns the (right-tailed) F probability distribution x, deg_freedom1, deg_freedom2 
F.DIST.RT Calculates the (right-tailed) F probability distribution x, deg_freedom1, deg_freedom2 
F.INV Returns the inverse of F probability distribution probability, deg_freedom1, deg_freedom2 
FINV Returns the inverse of the (right-tailed) F probability distribution probability, deg_freedom1, deg_freedom2 
FISHER Returns the Fisher transformation of a supplied value (x) x
FISHERINV Returns the inverse of Fisher transformation of a supplied value (y) y
F.INV.RT Calculates the inverse of the (right-tailed) F probability distribution probability, deg_freedom1, deg_freedom2 
FORECAST Predicts a value with a linear trend x, known_y's, known_x's
FORECAST.ETS Predicts a value with a seasonal trend target_date, values, timeline, [seasonality], [data_completion], [aggregation]
FORECAST.ETS.CONFINT Calculates the confidence interval for the forecast value at the specified target date target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation]
FORECAST.ETS.SEASONALITY Returns the length of a seasonal pattern based on existing values and a timeline values, timeline, [data_completion], [aggregation]
FORECAST.ETS.STAT Returns a specified statistical value as a result of time series forecasting values, timeline, statistic_type, [seasonality], [data_completion], [aggregation]
FORECAST.LINEAR Predicts a value with a linear trend x, known_y's, known_x's
FREQUENCY Returns a frequency distribution data_array, bins_array
F.TEST Returns the result of an F-test for two given arrays or ranges array1, array2
FTEST Returns the result of an F-test for two given arrays or ranges array1, array2
GAMMA Returns the value of the gamma function for a specified number x
GAMMA.DIST Returns the gamma distribution x, alpha, beta, cumulative
GAMMADIST Returns the gamma distribution x, alpha, beta, cumulative
GAMMA.INV Returns the inverse of the gamma cumulative distribution probability, alpha, beta
GAMMAINV Returns the inverse of the gamma cumulative distribution probability, alpha, beta
GAMMALN Returns the natural logarithm of the gamma function, Γ(n) x
GAMMALN.PRECISE Returns the natural logarithm of the gamma function, Γ(n) x
GAUSS Calculates the probability that a member of a standard normal population falls between the mean and z standard deviation from the mean z
GEOMEAN Returns geometric mean of a range of positive numbers number1, [number2], ...
GROWTH Returns the predicted exponential GROWTH based on a given set of data known_y’s, [known_x’s], [new_x’s], [const]
HARMEAN Returns harmonic mean of a range of positive numbers number1, [number2], ...
HYPGEOM.DIST Returns the value of the hypergeometric distribution sample_s, number_sample, population_s, number_pop, cumulative
HYPGEOMDIST Returns the value of the hypergeometric distribution sample_s, number_sample, population_s, number_pop
INTERCEPT Calculates the point at which a linear regression line will intersect the y-axis by using the given x-values and y-values known_ys, known_xs
KURT Returns the kurtosis of a supplied data set number1, [number2], ...
LARGE Returns the k-th largest number in array array, k
LINEST Returns the statistic for a best fit straight line based on the supplied set of x value and y value by using the “least squares” method known_ys, known_xs, [const], [stats]
LOGEST Returns an exponential curve that best fits a supplied set of y- and x- values and returns an array of values that describes the curve known_y’s, [known_x’s], [const], [stats]
LOGNORM.DIST Calculates the lognormal distribution for a given value of x x, mean, standard_dev, cumulative
LOGNORMDIST Calculates the lognormal distribution for a given value of x x, mean, standard_dev
LOGNORM.INV Returns the inverse lognormal distribution for a given value of x probability, mean, standard_dev
LOGINV Returns the inverse lognormal distribution for a given value of x probability, mean, standard_dev
MAX Returns the largest value in the supplied set of values, ignores logical values number1, [number2], ...
MAXA Returns the largest value in the supplied set of values value1, [value2], ...
MAXIFS Returns the largest value of a range of values that specified set of criteria max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...
MEDIAN Returns the middle number of the supplied numbers number1, [number2], ...
MIN Returns the smallest number from the data provided number1, [number2], ...
MINA Returns the smallest numeric value from a set of values provided value1, [value2], ...
MINIFS Returns the smallest numeric value in a range that meet one or more supplied criteria min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...
MODE Returns the most frequently occurring number in a set of numbers number1, [number2], ...
MODE.MULT Returns a vertical array of the most frequently occurring numbers in a set of numbers number1, [number2], ...
MODE.SNGL Returns the most frequently occurring number in a set of numbers number1, [number2], ...
NORM.DIST Returns normal cumulative distribution function or probability density function x, mean, standard_dev, cumulative
NORMDIST Returns normal cumulative distribution function or probability density function x, mean, standard_dev, cumulative
NORM.INV Returns inverse of the normal cumulative distribution probability, mean, standard_dev
NORMINV Returns inverse of the normal cumulative distribution probability, mean, standard_dev
NORM.S.DIST Returns standard normal cumulative distribution function or probability density function z, cumulative
NORMSDIST Returns standard normal cumulative distribution function z
NORM.S.INV Returns inverse of the standard normal cumulative distribution probability
NORMSINV Returns inverse of the standard normal cumulative distribution probability
PEARSON Returns the Pearson product-moment correlation coefficient array1, array2
PERCENTILE Returns k-th percentile, k is from 0 to 1 including array, k
PERCENTILE.EXC Returns k-th percentile, k is from 0 to 1 excluding array, k
PERCENTILE.INC Returns k-th percentile, k is from 0 to 1 including array, k
PERCENTRANK Returns the rank of a value in a data set as a percentage of the data set array, x, [significance]
PERCENTRANK.EXC Returns the rank of a value in a data set as a percentage (excludes 0 and 1) of the data set array, x, [significance]
PERCENTRANK.INC Returns the rank of a value in a data set as a percentage (includes 0 and 1) of the data set array, x, [significance]
PERMUT Returns the number of permutations of a given number of objects from a set of objects (not allow repetitions) number, number_chosen
PERMUTATIONA Returns the number of permutations of a given number of objects from a set of objects (allows repetitions) number, number_chosen
PHI Returns the value of density distribution for a standard normal distribution for a given number x
POISSON Returns the Poisson distribution which is used to predict the number of events occurring over a specific time x, mean, cumulative
POISSON.DIST Returns the Poisson distribution which is used to predict the number of events occurring over a specific time x, mean, cumulative
PROB Returns the probability that values in a range are between two limits x_range, prob_range, [lower_limit], [uppeer_limit]
QUARTILE Returns the quartile for a data set array, quart
QUARTILE.EXC Returns the quartile for a data set based on a percentile range of 0 to 1 exclusive array, quart
QUARTILE.INC Returns the quartile for a data set based on a percentile range of 0 to 1 inclusive array, quart
RANDARRAY Returns an array of random numbers [rows], [columns], [min], [max], [integer]
RANK Returns the rank of a number against numbers in the same list number, ref, [order]
RANK.AVG Returns the rank of a number against numbers in the same list number, ref, [order]
RANK.EQ Returns the rank of a number against numbers in the same list number, ref, [order]
RSQ Returns the square of the Pearson product-moment correlation coefficient known_ys, known_xs
SEQUENCE Allows creating a list of sequential numbers in an array rows, [columns], [start], [step]
SKEW Returns the skewness of a distribution of a set of values number1, [number2], ...
SKEW.P Returns the skewness of a distribution of data that represents an entire population number1, [number2], ...
SLOPE Returns the slope of a regression line based on the supplied y values and x values known_y's, known_x's
SMALL Returns the kth smallest value from a set of numeric values array, k
STANDARDIZE Returns a normalized value (z-score) from a distribution based on the mean and standard deviation of a data set x, mean, standard_dev
STDEV Returns standard deviation based on a given sample of data number1, [number2], ...
STDEV.P Returns standard deviation based on the entire population value1, [value2], ...
STDEV.S Returns standard deviation based on a given sample of data number1, [number2], ...
STDEVA Returns standard deviation based on a sample of population number1, [number2], ...
STDEVP Returns standard deviation based on the entire population value1, [value2}, ...
STDEVPA Calculates standard deviation based on the given entire population value1, [value2], ...
STEYX Returns the standard error of the predicted y value for each x in a linear regression known_ys, known_xs
T.DIST Returns the Student's left-tailed t-distribution x, deg_freedom, cumulative
T.DIST.2T Returns the Student's two-tailed t-distribution x, deg_freedom
T.DIST.RT Returns the Student's right-tailed t-distribution x, deg_freedom
TDIST Returns the Student's t-distribution x, deg_freedom, tails
T.INV Returns the inverse of Student's left-tailed t-distribution probability, deg_freedom
TINV Returns the two-tailed inverse of the Student's t-distribution probability, deg_freedom
T.INV.2T Returns the inverse of Student's two-tailed-distribution probability, deg_freedom
TREND Predicts values along a linear trend known_y's, [known_x's], [new_x's], [const]
TRIMMEAN Returns the mean of the interior of a data set array, percent
T.TEST Returns the probability that is associated with a Student's t-test array1, array2, tails, type
TTEST Returns the probability that is associated with a Student's t-test array1, array2, tails, type
VAR Returns the variance based on a given sample number1, [number2], ...
VAR.P Returns the variance based on the entire population number1, [number2], ...
VAR.S Returns the variance based on a given sample number1, [number2], ...
VARA Returns the variance based on a given sample value1, [value2], ...
VARP Returns the variance based on the entire population number1, [number2], ...
VARPA Returns the variance based on the entire population value1, [value2], ...
WEIBULL Returns the Weibull probability density function or Weibull cumulative distribution x_range, alpha, betta, cumulative
WEIBULL.DIST Returns the Weibull probability density function or Weibull cumulative distribution x_range, alpha, betta, cumulative
ZTEST Returns the one-tailed P-value of a z-test which is useful for various analyses array, x, [sigma]
Z.TEST Returns the one-tailed P-value of a z-test which is useful for various analyses array, x, [sigma]

Text

Description

Arguments

ARRAYTOTEXT Converts an array or range into a text string array, [format]
ASC Returns the ASCII code for the first character of a string text
BAHTTEXT Converts a number to Thai text with a suffix of “Baht” (Thai currency บาทถ้วน) number
CHAR Returns the character specified by a number number
CLEAN Removes all non-printable characters from the given text text
CODE Returns a numeric code of the first character in a given text string text
CONCAT Joins texts from multiple columns, rows or ranges together text1, [text2], ...
CONCATENATE Joins two or more texts items from multiple cells into one text1, [text2], ...
DBCS Converts half-width (single-byte) characters into full-width (double-byte) characters in a text string text
DOLLAR Converts a number to text in the currency formatting number, decimals
EXACT Returns TRUE if two compared strings are exactly same, or returns FALSE text1, text2
FIND Returns the starting position of a string inside another one find_text, within_text, [start_num]
FINDB Returns the starting position of a string inside another one in bytes find_text, within_text, [start_num]
FIXED Returns a number formatted as decimals and represented as text number, [decimal_places], [no_commas]
LEFT Extracts string from left of a text string text, [num_chars]
LEFTB Extracts specified bytes of string from left of a text string text, [num_bytes]
LEN Counts the length of a string text
LENB Counts the length of a string in bytes text
LOWER Lowercases letters in the text string text
MID Returns the specific characters from the middle of text string text, start_num, num_chars
MIDB Returns specific bytes of characters from the position you specify from a text string text, start_num, num_bytes
NUMBERVALUE Returns the real number from number is stored as text text, [decimal_separator], [group_separator]
PHONETIC Extracts the phonetic (furigana) characters from a text string reference
PROPER Converts text strings to proper case text
REPLACE Finds and replaces characters based on given location from text string with a new text old_text, start_num, num_chars, new_text
REPLACEB replaces part of a text string with a new text string based on the number of bytes you specify old_text, start_num, num_bytes, new_text
REPT Returns the repeated text by specific number of times text, number_times
RIGHT Extracts the text from right of a text string text, [num_chars]
RIGHTB Extracts specified bytes of string from right of a text string text, [num_bytes]
SEARCH Returns the location of the specific character or text from the given text string find_text, within_text, [start_num]
SEARCHB Returns the starting position of a string inside another one in bytes find_text, within_text, [start_num]
SUBSTITUTE Replaces text based on given text text, new_text, old_text, [instance_num]
T Returns the text referred to by a value value
TEXT Converts number to text with a specific format text, format_text
TEXTAFTER Extracts and returns the text that occurs after a given substring or delimiter text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found]
TEXTBEFORE Extracts and returns the text that occurs before a given substring or delimiter text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found]
TEXTJOIN Joins multiple values with specific delimiter delimiter, ignore_empty, text1, [text2], ...
TEXTSPLIT Splits text strings by a given delimiter text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with]
TRIM Removes extra spaces from text string text
UNICHAR Returns the Unicode character based on given number number
UNICODE Returns the number based on the first character of given text text
UPPER Converts all letters of a given text to uppercase text
VALUE Converts text to a number text
VALUETOTEXT Converts any specified value to text value, [format]

Web

Description

Arguments

ENCODEURL Converts a text to a URL-encoded string text
FILTERXML Returns specific values from XML text by using the given XPath xml, xpath
WEBSERVICE Returns data from a web service url