Note: The other languages of the website are Google-translated. Back to English

Excel Functions Guide | ExtendOffice


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
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

Logical

Description

Arguments

AND Tests multiple conditions to return True or False logical1, [logical2], ...
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], ...
NOT Reverses the arguments or results logical
OR Tests multiple conditions with OR logical1, [logical2], ...
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], ...
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
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]
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
TRANSPOSE Rotates the orientation of a range or array array
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]
FIELDVALUE Retrieves field data from linked data types like Stocks or Geography data types value, field_name

Math

Description

Arguments

ABS Returns the absolute value of 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
BASE Returns the text representation of the converted number to another base number, radix, [min_length]
ASIN Returns an angle of triangle in radians number
CEILING Rounds number up to nearest multiple number, multiple
CEILING.MATH Rounds number up to nearest multiple or nearest integer number, [significance], [mode]
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
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
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
MUNIT Returns a unit matrix for specified dimension dimension
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
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
SIGN Returns sign of a number number
SQRT Returns square root of a number 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
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], ...
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
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], ...
DEVSQ Returns the sum of squares of the deviations from the sample mean number1, [number2], ...
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
GEOMEAN Returns geometric mean of a range of positive numbers number1, [number2], ...
HARMEAN Returns harmonic mean of a range of positive numbers number1, [number2], ...
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
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]
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
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
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
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], ...
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]
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
TRIMMEAN Returns the mean of the interior of a data set array, percent
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], ...

Text

Description

Arguments

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], ...
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]
FIXED Returns a number formatted as decimals and represented as text number, [decimal_places], [no_commas]
LEFT Extracts string from left of the text string text, [num_chars]
LEN Counts the number of characters text
LOWER Lowercases letters in the text string text
SUBSTITUTE Replaces text based on given text text, new_text, old_text, [instance_num]
TEXT Converts number to text with a specific format text, format_text
TEXTJOIN Joins multiple values with specific delimiter delimiter, ignore_empty, text1, [text2], ...
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
MID Returns the specific characters from the middle of text string text, start_num, num_chars
NUMBERVALUE Returns the real number from number is stored as text text, [decimal_separator], [group_separator]
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
REPT Returns the repeated text by specific number of times text, number_times
RIGHT Extracts the text from right of the text string text, [num_chars]
SEARCH Returns the location of the specific character or text from the given text string find_text, within_text, [start_num]