TABLE OF CONTENTS

  1. Date and time
    1. DATE
    2. DATEDIFF
    3. DATEFORMAT
    4. DAYNAME
    5. DATEVALUE
    6. DAY
    7. DAYS
    8. DAYS360
    9. EDATE
    10. EOMONTH
    11. FROMNOW
    12. HOUR
    13. ISOWEEKNUM
    14. MINUTE
    15. MONTH
    16. NETWORKDAYS
    17. NETWORKDAYSINTL
    18. NOW
    19. SECOND
    20. TIME
    21. TIMEVALUE
    22. TODAY
    23. WEEKDAY
    24. WEEKNUM
    25. WORKDAY
    26. WORKDAYINTL
    27. YEAR
    28. YEARFRAC
  2. Engineering
    1. BIN2DEC
    2. BIN2HEX
    3. BIN2OCT
    4. BITAND
    5. BITLSHIFT
    6. BITOR
    7. BITRSHIFT
    8. BITXOR
    9. COMPLEX
    10. CONVERT
    11. DEC2BIN
    12. DEC2HEX
    13. DEC2OCT
    14. DELTA
    15. ERF
    16. ERFC
    17. ERFC.PRECISE
    18. GESTEP
    19. HEX2BIN
    20. HEX2DEC
    21. HEX2OCT
    22. IMABS
    23. IMAGINARY
    24. IMARGUMENT
    25. IMCONJUGATE
    26. IMCOS
    27. IMCOSH
    28. IMCOT
    29. IMCSC
    30. IMCSCH
    31. IMDIV
    32. IMEXP
    33. IMLN
    34. IMLOG10
    35. IMLOG2
    36. IMPOWER
    37. IMPRODUCT
    38. IMREAL
    39. IMSEC
    40. IMSECH
    41. IMSIN
    42. IMSINH
    43. IMSQRT
    44. IMSUB
    45. IMSUM
    46. IMTAN
    47. OCT2BIN
    48. OCT2DEC
    49. OCT2HEX
  3. Financial
    1. ACCRINT
    2. CUMIPMT
    3. CUMPRINC
    4. DB
    5. DDB
    6. DOLLARDE
    7. DOLLARFR
    8. EFFECT
    9. FV
    10. FVSCHEDULE
    11. IPMT
    12. IRR
    13. ISPMT
    14. MIRR
    15. NOMINAL
    16. NPER
    17. NPV
    18. PDURATION
    19. PMT
    20. PPMT
    21. PV
    22. RATE
    23. RRI
    24. SLN
    25. SYD
    26. TBILLEQ
    27. TBILLPRICE
    28. TBILLYIELD
    29. XIRR
    30. XNPV
  4. Logical
    1. AND
    2. CHOOSE
    3. IF
    4. IFERROR
    5. IFNA
    6. NOT
    7. OR
    8. SWITCH
    9. XOR
    10. FALSE
    11. TRUE
    12. NULL
  5. General
    1. HLOOKUP
    2. VLOOKUP
    3. XLOOKUP
  6. MATH
    1. ABS
    2. ACOS
    3. ACOSH
    4. ACOT
    5. ACOTH
    6. AGGREGATE
    7. ARABIC
    8. ASIN
    9. ASINH
    10. ATAN
    11. ATAN2
    12. ATANH
    13. BASE
    14. CEILING
    15. CEILINGMATH
    16. CEILINGPRECISE
    17. COMBIN
    18. COMBINA
    19. COS
    20. COSH
    21. COT
    22. COTH
    23. CSC
    24. CSCH
    25. DECIMAL
    26. DEGREES
    27. DIVIDE
    28. EVEN
    29. EXP
    30. FACT
    31. FACTDOUBLE
    32. FLOOR
    33. FLOORMATH
    34. FLOORPRECISE
    35. GCD
    36. INT
    37. ISEVEN
    38. ISOCEILING
    39. ISODD
    40. LCM
    41. LN
    42. LOG
    43. LOG10
    44. MDETERM
    45. MOD
    46. MROUND
    47. MULTINOMIAL
    48. ODD
    49. PI
    50. POWER
    51. PRODUCT
    52. QUOTIENT
    53. RADIANS
    54. RAND
    55. RANDARRAY
    56. RANDBETWEEN
    57. ROUND
    58. ROUNDDOWN
    59. ROUNDUP
    60. SEC
    61. SECH
    62. SERIESSUM
    63. SIGN
    64. SIN
    65. SINH
    66. SQRT
    67. SQRTPI
    68. SUBTOTAL
    69. SUBTRACT
    70. SUM
    71. SUMIF
    72. SUMIFS
    73. SUMPRODUCT
    74. SUMSQ
    75. SUMX2MY2
    76. SUMX2PY2
    77. SUMXMY2
    78. TAN
    79. TANH
    80. TRUNC
  7. Statistical
    1. AVEDEV
    2. AVERAGE
    3. AVERAGEA
    4. AVERAGEIF
    5. AVERAGEIFS
    6. BETADIST
    7. BETAINV
    8. BINOMDIST
    9. BINOMDISTRANGE
    10. BINOMINV
    11. CHISQDIST
    12. CHISQDISTRT
    13. CHISQINV
    14. CHISQINVRT
    15. CHISQTEST
    16. CONFIDENCE.NORM
    17. CONFIDENCET
    18. CORREL
    19. COUNT
    20. COUNTA
    21. COUNTBLANK
    22. COUNTIF
    23. COUNTUNIQUE
    24. COUNTIFS
    25. COVARIANCEP
    26. COVARIANCES
    27. DEVSQ
    28. EXPONDIST
    29. FDIST
    30. FINV
    31. F.INV.RT
    32. FINV
    33. FISHER
    34. FISHERINV
    35. FORECAST
    36. FREQUENCY
    37. GAMMA
    38. GAMMADIST
    39. GAMMAINV
    40. GAMMALN
    41. GAUSS
    42. GEOMEAN
    43. GROWTH
    44. HARMEAN
    45. HYPGEOMDIST
    46. INTERCEPT
    47. KURT
    48. LARGE
    49. LINEST
    50. LOGNORMDIST
    51. LOGNORMINV
    52. MAX
    53. MAXA
    54. MEDIAN
    55. MIN
    56. MINA
    57. MODEMULT
    58. MODESNGL
    59. NEGBINOMDIST
    60. NORMDIST
    61. NORMSDIST
    62. NORMSINV
    63. NORMINV
    64. PEARSON
    65. PERCENTILEEXC
    66. PERCENTILEINC
    67. PERCENTRANKEXC
    68. PERCENTRANKINC
    69. PERMUT
    70. PERMUTATIONA
    71. PHI
    72. POISSONDIST
    73. PROB
    74. QUARTILEEXC
    75. QUARTILEINC
    76. RANKAVG
    77. RANKEQ
    78. RSQ
    79. SKEW
    80. SKEWP
    81. SLOPE
    82. SMALL
    83. STANDARDIZE
    84. STDEVP
    85. STDEVS
    86. STDEVA
    87. STDEVPA
    88. STEYX
    89. TDIST
    90. TINV
    91. TREND
    92. TRIMMEAN
    93. VARP
    94. VARS
    95. VARA
    96. VARPA
    97. WEIBULLDIST
    98. ZTEST
  8. Text

Date and time

DATE

Returns the serial number of a particular date



DATEDIFF

Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.


DATEFORMAT

[info needed: not present in Microsoft link] 


DAYNAME

[info needed: not present in Microsoft link] 


DATEVALUE

Converts a date in the form of text to a serial number


DAY

Converts a serial number to a day of the month


DAYS

Returns the number of days between two dates


DAYS360

Calculates the number of days between two dates based on a 360-day year



EDATE

Returns the serial number of the date that is the indicated number of months before or after the start date



EOMONTH

Returns the serial number of the last day of the month before or after a specified number of months


FROMNOW

[info needed: not present in Microsoft link] 


HOUR

Converts a serial number to an hour



ISOWEEKNUM

Returns the number of the ISO week number of the year for a given date



MINUTE

Converts a serial number to a minute



MONTH

Converts a serial number to a month


NETWORKDAYS

Returns the number of whole workdays between two dates


NETWORKDAYSINTL

Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days



NOW

Returns the serial number of the current date and time



SECOND

Converts a serial number to a second



TIME

Returns the serial number of a particular time



TIMEVALUE

Converts a time in the form of text to a serial number



TODAY

Returns the serial number of today's date



WEEKDAY

Converts a serial number to a day of the week



WEEKNUM

Converts a serial number to a number representing where the week falls numerically with a year



WORKDAY

Returns the serial number of the date before or after a specified number of workdays


WORKDAYINTL

Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days



YEAR

Converts a serial number to a year


YEARFRAC

Returns the year fraction representing the number of whole days between start_date and end_date

Engineering



BIN2DEC

Converts a binary number to decimal



BIN2HEX

Converts a binary number to hexadecimal



BIN2OCT

Converts a binary number to octal



BITAND

Returns a 'Bitwise And' of two numbers



BITLSHIFT

Returns a value number shifted left by shift_amount bits



BITOR

Returns a bitwise OR of 2 numbers



BITRSHIFT

Returns a value number shifted right by shift_amount bits



BITXOR

Returns a bitwise 'Exclusive Or' of two numbers



COMPLEX

Converts real and imaginary coefficients into a complex number



CONVERT

Converts a number from one measurement system to another



DEC2BIN

Converts a decimal number to binary



DEC2HEX

Converts a decimal number to hexadecimal



DEC2OCT

Converts a decimal number to octal



DELTA

Tests whether two values are equal



ERF

Returns the error function


ERFC

Returns the complementary error function



ERFC.PRECISE

Returns the complementary ERF function integrated between x and infinity



GESTEP

Tests whether a number is greater than a threshold value



HEX2BIN

Converts a hexadecimal number to binary



HEX2DEC

Converts a hexadecimal number to decimal



HEX2OCT

Converts a hexadecimal number to octal



IMABS

Returns the absolute value (modulus) of a complex number



IMAGINARY

Returns the imaginary coefficient of a complex number



IMARGUMENT

Returns the argument theta, an angle expressed in radians



IMCONJUGATE

Returns the complex conjugate of a complex number



IMCOS

Returns the cosine of a complex number



IMCOSH

Returns the hyperbolic cosine of a complex number



IMCOT

Returns the cotangent of a complex number



IMCSC

Returns the cosecant of a complex number



IMCSCH

Returns the hyperbolic cosecant of a complex number



IMDIV

Returns the quotient of two complex numbers



IMEXP

Returns the exponential of a complex number



IMLN

Returns the natural logarithm of a complex number



IMLOG10

Returns the base-10 logarithm of a complex number



IMLOG2

Returns the base-2 logarithm of a complex number



IMPOWER

Returns a complex number raised to an integer power



IMPRODUCT

Returns the product of complex numbers



IMREAL

Returns the real coefficient of a complex number



IMSEC

Returns the secant of a complex number


IMSECH

Returns the hyperbolic secant of a complex number



IMSIN

Returns the sine of a complex number



IMSINH

Returns the hyperbolic sine of a complex number



IMSQRT

Returns the square root of a complex number



IMSUB

Returns the difference between two complex numbers



IMSUM

Returns the sum of complex numbers



IMTAN

Returns the tangent of a complex number



OCT2BIN

Converts an octal number to binary



OCT2DEC

Converts an octal number to decimal



OCT2HEX

Converts an octal number to hexadecimal

Financial

ACCRINT

Returns the accrued interest for a security that pays periodic interest.

CUMIPMT

Returns the cumulative interest paid between two periods.

CUMPRINC

Returns the cumulative principal paid on a loan between two periods.

DB

Returns the depreciation of an asset for a specified period by using the fixed-declining balance method.

DDB

Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify.

DOLLARDE

Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.

DOLLARFR

Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction.


EFFECT

Returns the effective annual interest rate.


FV

Returns the future value of an investment.


FVSCHEDULE

Returns the future value of an initial principal after applying a series of compound interest rates.


IPMT

Returns the interest payment for an investment for a given period.



IRR

Returns the internal rate of return for a series of cash flows



ISPMT

Calculates the interest paid during a specific period of an investment.



MIRR

Returns the internal rate of return where positive and negative cash flows are financed at different rates



NOMINAL

Returns the annual nominal interest rate



NPER

Returns the number of periods for an investment



NPV

Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.


PDURATION

Returns the number of periods required by an investment to reach a specified value



PMT

Returns the periodic payment for an annuity



PPMT

Returns the payment on the principal for an investment for a given period.


PV

Returns the present value of an investment.



RATE

Returns the interest rate per period of an annuity.



RRI

Returns an equivalent interest rate for the growth of an investment



SLN

Returns the straight-line depreciation of an asset for one period



SYD

Returns the sum-of-years' digits depreciation of an asset for a specified period



TBILLEQ

Returns the bond-equivalent yield for a Treasury bill.


TBILLPRICE

Returns the price per $100 face value for a Treasury bill.


TBILLYIELD

Returns the yield for a Treasury bill.



XIRR

Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic


XNPV

Returns the net present value for a schedule of cash flows that is not necessarily periodic.

Logical

AND

Returns TRUE if all of its arguments are TRUE


CHOOSE

[need info]

IF

Specifies a logical test to perform



IFERROR

Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula



IFNA

Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression



NOT

Reverses the logic of its argument.


OR

Returns TRUE if any argument is TRUE.


SWITCH

Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.


XOR

Returns a logical exclusive OR of all arguments


FALSE

Returns the logical value FALSE


TRUE

Returns the logical value TRUE


NULL

Returns a logical value TRUE if the reference is null. 

General

HLOOKUP

Looks in the top row of an array and returns the value of the indicated cell.


VLOOKUP

Looks in the first column of an array and moves across the row to return the value of a cell.


XLOOKUP

Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match.

MATH

ABS

Returns the absolute value of a number.


ACOS

Returns the arccosine of a number.


ACOSH

Returns the inverse hyperbolic cosine of a number.


ACOT

Returns the arccotangent of a number.


ACOTH

Returns the hyperbolic arccotangent of a number.


AGGREGATE

Returns an aggregate in a list or database.


ARABIC

Converts a Roman number to Arabic, as a number.


ASIN

Returns the arcsine of a number.


ASINH

Returns the inverse hyperbolic sine of a number.


ATAN

Returns the arctangent of a number.


ATAN2

Returns the arctangent from x- and y-coordinates.


ATANH

Returns the inverse hyperbolic tangent of a number.


BASE

Converts a number into a text representation with the given radix (base).


CEILING

Rounds a number to the nearest integer or to the nearest multiple of significance.


CEILINGMATH

Rounds a number up, to the nearest integer or to the nearest multiple of significance.


CEILINGPRECISE

Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.


COMBIN

Returns the number of combinations for a given number of objects.


COMBINA

Returns the number of combinations with repetitions for a given number of items.


COS

Returns the cosine of a number.


COSH

Returns the hyperbolic cosine of a number.


COT

Returns the hyperbolic cosine of a number.


COTH

Returns the cotangent of an angle.


CSC

Returns the cosecant of an angle.


CSCH

Returns the hyperbolic cosecant of an angle.


DECIMAL

Converts a text representation of a number in a given base into a decimal number.


DEGREES

Converts radians to degrees


DIVIDE

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



EVEN

Rounds a number up to the nearest even integer



EXP

Returns e raised to the power of a given number



FACT

Returns the factorial of a number



FACTDOUBLE

Returns the double factorial of a number


FLOOR

Rounds a number down, toward zero In Excel 2007 and Excel 2010, this is a Math and trigonometry function.


FLOORMATH

Rounds a number down, to the nearest integer or to the nearest multiple of significance



FLOORPRECISE

Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.



GCD

Returns the greatest common divisor



INT

Rounds a number down to the nearest integer



ISEVEN

Returns TRUE if the number is even


ISOCEILING

Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.


ISODD

Returns TRUE if the number is odd

LCM

Returns the least common multiple



LN

Returns the natural logarithm of a number



LOG

Returns the logarithm of a number to a specified base



LOG10

Returns the base-10 logarithm of a number



MDETERM

Returns the matrix determinant of an array




MOD

Returns the remainder from division



MROUND

Returns a number rounded to the desired multiple



MULTINOMIAL

Returns the multinomial of a set of numbers



ODD

Rounds a number up to the nearest odd integer



PI

Returns the value of pi



POWER

Returns the result of a number raised to a power



PRODUCT

Multiplies its arguments



QUOTIENT

Returns the integer portion of a division



RADIANS

Converts degrees to radians



RAND

Returns a random number between 0 and 1



RANDARRAY

Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values.



RANDBETWEEN

Returns a random number between the numbers you specify.



ROUND

Rounds a number to a specified number of digits



ROUNDDOWN

Rounds a number down, toward zero



ROUNDUP

Rounds a number up, away from zero



SEC

Returns the secant of an angle



SECH

Returns the hyperbolic secant of an angle


SERIESSUM

Returns the sum of a power series based on the formula



SIGN

Returns the sign of a number



SIN

Returns the sine of the given angle



SINH

Returns the hyperbolic sine of a number



SQRT

Returns a positive square root



SQRTPI

Returns the square root of (number * pi)



SUBTOTAL

Returns a subtotal in a list or database


SUBTRACT

Subtracts its argu

SUM

Adds its arguments



SUMIF

Adds the cells specified by a given criteria



SUMIFS

Adds the cells in a range that meet multiple criteria



SUMPRODUCT

Returns the sum of the products of corresponding array components



SUMSQ

Returns the sum of the squares of the arguments



SUMX2MY2

Returns the sum of the difference of squares of corresponding values in two arrays



SUMX2PY2

Returns the sum of squares of corresponding values in two arrays



SUMXMY2

Returns the sum of squares of differences of corresponding values in two arrays



TAN

Returns the tangent of a number



TANH

Returns the hyperbolic tangent of a number



TRUNC

Truncates a number to an integer.

Statistical


AVEDEV

Returns the average of the absolute deviations of data points from their mean



AVERAGE

Returns the average of its arguments



AVERAGEA

Returns the average of its arguments, including numbers, text, and logical values



AVERAGEIF

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria



AVERAGEIFS

Returns the average (arithmetic mean) of all cells that meet multiple criteria.



BETADIST

Returns the beta cumulative distribution function



BETAINV

Returns the inverse of the cumulative distribution function for a specified beta distribution



BINOMDIST

Returns the individual term binomial distribution probability



BINOMDISTRANGE

Returns the probability of a trial result using a binomial distribution



BINOMINV

Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value



CHISQDIST

Returns the cumulative beta probability density function



CHISQDISTRT

Returns the one-tailed probability of the chi-squared distribution



CHISQINV

Returns the cumulative beta probability density function



CHISQINVRT

Returns the inverse of the one-tailed probability of the chi-squared distribution



CHISQTEST

Returns the test for independence



CONFIDENCE.NORM

Returns the confidence interval for a population mean



CONFIDENCET

Returns the confidence interval for a population mean, using a Student's t distribution



CORREL

Returns the correlation coefficient between two data sets



COUNT

Counts how many numbers are in the list of arguments



COUNTA

Counts how many values are in the list of arguments



COUNTBLANK

Counts the number of blank cells within a range



COUNTIF

Counts the number of cells within a range that meet the given criteria


COUNTUNIQUE

Counts the number of unique values in a list of specified values and ranges 


COUNTIFS

Counts the number of cells within a range that meet multiple criteria



COVARIANCEP

Returns covariance, the average of the products of paired deviations



COVARIANCES

Returns the sample covariance, the average of the products deviations for each data point pair in two data sets



DEVSQ

Returns the sum of squares of deviations



EXPONDIST

Returns the exponential distribution



FDIST

Returns the F probability distribution.



FINV

Returns the inverse of the F probability distribution



F.INV.RT

Returns the inverse of the F probability distribution



FINV

Returns the inverse of the F probability distribution



FISHER

Returns the Fisher transformation



FISHERINV

Returns the inverse of the Fisher transformation



FORECAST

Returns a value along a linear trend. 



FREQUENCY

Returns a frequency distribution as a vertical array



GAMMA

Returns the Gamma function value



GAMMADIST

Returns the gamma distribution



GAMMAINV

Returns the inverse of the gamma cumulative distribution



GAMMALN

Returns the natural logarithm of the gamma function, Γ(x)



GAUSS

Returns 0.5 less than the standard normal cumulative distribution



GEOMEAN

Returns the geometric mean



GROWTH

Returns values along an exponential trend



HARMEAN

Returns the harmonic mean



HYPGEOMDIST

Returns the hypergeometric distribution



INTERCEPT

Returns the intercept of the linear regression line



KURT

Returns the kurtosis of a data set



LARGE

Returns the k-th largest value in a data set



LINEST

Returns the parameters of a linear trend



LOGNORMDIST

Returns the cumulative lognormal distribution



LOGNORMINV

Returns the inverse of the lognormal cumulative distribution



MAX

Returns the maximum value in a list of arguments



MAXA

Returns the maximum value in a list of arguments, including numbers, text, and logical values



MEDIAN

Returns the median of the given numbers



MIN

Returns the minimum value in a list of arguments



MINA

Returns the smallest value in a list of arguments, including numbers, text, and logical values.




MODEMULT

Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data



MODESNGL

Returns the most common value in a data set



NEGBINOMDIST

Returns the negative binomial distribution



NORMDIST

Returns the normal cumulative distribution



NORMSDIST

Returns the standard normal cumulative distribution



NORMSINV

Returns the inverse of the standard normal cumulative distribution



NORMINV

Returns the inverse of the normal cumulative distribution



PEARSON

Returns the Pearson product-moment correlation coefficient



PERCENTILEEXC

Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive



PERCENTILEINC

Returns the k-th percentile of values in a range



PERCENTRANKEXC

Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set



PERCENTRANKINC

Returns the percentage rank of a value in a data set



PERMUT

Returns the number of permutations for a given number of objects



PERMUTATIONA

Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects



PHI

Returns the value of the density function for a standard normal distribution



POISSONDIST

Returns the Poisson distribution



PROB

Returns the probability that values in a range are between two limits



QUARTILEEXC

Returns the quartile of the data set, based on percentile values from 0..1, exclusive



QUARTILEINC

Returns the quartile of a data set



RANKAVG

Returns the rank of a number in a list of numbers



RANKEQ

Returns the rank of a number in a list of numbers



RSQ

Returns the square of the Pearson product moment correlation coefficient



SKEW

Returns the skewness of a distribution



SKEWP

Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean



SLOPE

Returns the slope of the linear regression line



SMALL

Returns the k-th smallest value in a data set



STANDARDIZE

Returns a normalized value



STDEVP

Calculates standard deviation based on the entire population



STDEVS

Estimates standard deviation based on a sample



STDEVA

Estimates standard deviation based on a sample, including numbers, text, and logical values



STDEVPA

Calculates standard deviation based on the entire population, including numbers, text, and logical values



STEYX

Returns the standard error of the predicted y-value for each x in the regression



TDIST

Returns the Percentage Points (probability) for the Student t-distribution


TINV

Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom



TREND

Returns values along a linear trend



TRIMMEAN

Returns the mean of the interior of a data set



VARP

Calculates variance based on the entire population



VARS

Estimates variance based on a sample



VARA

Estimates variance based on a sample, including numbers, text, and logical values


VARPA

Calculates variance based on the entire population, including numbers, text, and logical values


WEIBULLDIST

Returns the Weibull distribution


ZTEST

Returns the one-tailed probability-value of a z-test


Text

CHAR

Returns the character specified by the code number



CLEAN

Removes all nonprintable characters from the text



CODE

Returns a numeric code for the first character in a text string



CONCAT

Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.



CONCATENATE

Joins several text items into one text item




DOLLAR

Converts a number to text, using the $ (dollar) currency format



EXACT

Checks to see if two text values are identical



FIND

Finds one text value within another (case-sensitive)



FIXED

Formats a number as text with a fixed number of decimals



LEFT

Returns the leftmost characters from a text value



LEN

Returns the number of characters in a text string



LOWER

Converts text to lowercase



MID

Returns a specific number of characters from a text string starting at the position you specify



NUMBERVALUE

Converts text to number in a locale-independent manner



PROPER

Capitalizes the first letter in each word of a text value



REPLACE

Replaces characters within text


REGEXEXTRACT

Extracts matching substrings according to a regular expression 


REGEXMATCH

Whether a piece of text matches a regular expression 


REGEXREPLACE

Replaces part of a text string with a different text string using regular expressions 


ROMAN

Converts an Arabic numeral to roman, as text


REPT

Repeats text a given number of times



Returns the rightmost characters from a text value



Finds one text value within another (not case-sensitive)



SUBSTITUTE

Substitutes new text for old text in a text string



T

Converts its arguments to text



TEXT

Formats a number and converts it to te



TRIM

Removes spaces from text



UNICHAR

Returns the Unicode character that is referenced by the given numeric value



UNICODE

Returns the number (code point) that corresponds to the first character of the text



UPPER

Converts text to uppercase



VALUE

Converts a text argument to a number