OpenOffice Calc Formula Page

Click here to edit subtitle

List of All OpenOffice Calc Formulae

-

official OpenOffice formulae descriptions

Add In

BESSELI

BESSELJ

BESSELK

BESSELY

BIN2DEC

BIN2HEX

BIN2OCT

COMPLEX

CONVERT_ADD

DEC2BIN

DEC2HEX

DEC2OCT

DELTA

ERF

ERFC

FACTDOUBLE

GESTEP

HEX2BIN

HEX2DEC

HEX2OCT

IMABS

IMAGINARY

IMARGUMENT

IMCONJUGATE

IMCOS

IMCOSH

IMCOT

IMCSC

IMCSCH

IMDIV

IMEXP

IMLN

IMLOG10

IMLOG2

IMPOWER

IMPRODUCT

IMREAL

IMSEC

IMSECH

IMSIN

IMSINH

IMSQRT

IMSUB

IMSUm

IMTAN

OCT2BIN

OCT2DEC

OCT2HEX

  • Calculates the modified Bessel function of the first kind. 
  • Calculates the Bessel function of the first kind. 
  • Calculates the modified Bessel function of the second kind. 
  • Calculates the Bessel function of the second kind (the Neumann or Weber function). 
  • Converts a binary number to decimal. 
  • Converts a binary number to hexadecimal. 
  • Converts a binary number to octal. 
  • Returns a complex number, given real and imaginary parts as numbers. 
  • Converts a number from one measurement system to another.  * No Excel equivalent.
  • Converts a decimal number to binary. 
  • Converts a decimal number to hexadecimal. 
  • Converts a decimal number to octal. 
  • Returns 1 if two numbers are equal, and 0 otherwise. 
  • Calculates the error function (Gauss error function). 
  • Calculates the complementary error function (complementary Gauss error function). 
  • Returns the double factorial of a number, n!!. 
  • Returns 1 if a number is greater than or equal to a step number, or 0 otherwise. 
  • Converts a hexadecimal number to binary. 
  • Converts a hexadecimal number to decimal. 
  • Converts a hexadecimal number to octal. 
  • Returns the absolute value of a complex number. 
  • Returns the imaginary part of a complex number. 
  • Returns the argument of a complex number. 
  • Returns the complex conjugate of a complex number. 
  • Returns the cosine of a complex number. 
  • Returns the hyperbolic cosine of a complex number.  * No Excel equivalent.
  • Returns the cotangent of a complex number.  * No Excel equivalent.
  • Returns the cosecant of a complex number.  * No Excel equivalent.
  • Returns the hyperbolic cosecant of a complex number.  * No Excel equivalent.
  • Returns the result of dividing one complex number by another. 
  • Returns e to the power of a complex number. 
  • Returns the natural logarithm of a complex number. 
  • Returns the base-10 logarithm of a complex number. 
  • Returns the base-2 logarithm of a complex number. 
  • Returns a complex number raised to a power. 
  • Returns the product of complex numbers. 
  • Returns the real part of a complex number. 
  • Returns the secant of a complex number.  * No Excel equivalent.
  • Returns the hyperbolic secant of a complex number.  * No Excel equivalent.
  • Return the sine of a complex number. 
  • Returns the hyperbolic sine of a complex number.  * No Excel equivalent.
  • Returns the square root of a complex number. 
  • Returns the difference between 2 complex numbers. 
  • Returns the sum of complex numbers. 
  • Returns the tangent of a complex number.  * No Excel equivalent.
  • Converts an octal number to binary. 
  • Converts an octal number to decimal. 
  • Converts an octal number to hexadecimal

Array 

FREQUENCY 

GROWTH

GROWTH 

LINEST 

LOGEST 

MDETERM 

MINVERSE 

MMULT

MMULT 

MUNIT 

SUMPRODUCT 

SUMX2MY2 

SUMX2PY2 

SUMXMY2 

TRANSPOSE 

TREND

  • Returns an array, categorising values of a data set into given intervals. 
  • Returns an array of values for an exponential least squares fit to known data pairs. 
  • Calculates points on the exponential regression function. * No Excel equivalent.
  • Returns an array of statistics for a straight line that best fits a data set. 
  • Returns an array of statistics for an exponential curve that best fits a data set. 
  • Returns the determinant of a matrix (array). 
  • Returns the inverse of a matrix (array). 
  • Multiplies two matrices (arrays). 
  • Array multiplication. Returns the product of two arrays. * No Excel equivalent.
  • Returns the unitary square array of a certain size. * No Excel equivalent.
  • Returns the sum of the products of corresponding array elements. 
  • Returns the sum of the differences between corresponding squared elements of two matrices (arrays). 
  • Returns the sum of the squares of all elements of two matrices (arrays). 
  • Returns the sum of the squared differences between corresponding elements of two matrices (arrays). 
  • Returns an array with its rows and columns transposed. 
  • Fits a straight line to a data set using linear regression and returns points on that line. 

Database 

DAVERAGE

DCOUNT

DCOUNTA

DGET

DMAX

DMIN

DPRODUCT

DSTDEV


DSTDEVP


DSUM

DVAR


DVARP

  • Returns the average of the entries in a column of a database table, in rows that meet the criteria. 
  • Counts the numerical entries in a column of a database table, that are in rows meeting the criteria. 
  • Counts the non-empty cells in a column of a database table, that are in rows meeting the criteria. 
  • Returns the contents of a cell in a column of a database table, in the unique row meeting the criteria. 
  • Returns the largest value in a column of a database table, in rows that meet the criteria. 
  • Returns the smallest value in a column of a database table, in rows that meet the criteria. 
  • The product of the entries in a column of a database table, in rows that meet the criteria. 
  • Calculates the standard deviation of the entries in a column of a database table, in rows that meet the criteria. The records are treated as a sample, not as the whole population. 
  • Calculates the standard deviation of the entries in a column of a database table, in rows that meet the criteria. The records are treated as the whole population, not as a sample of the population. 
  • Returns the total of the entries in a column of a database table, in rows that meet the criteria. 
  • Returns the variance of the entries in a column of a database table, in rows that meet the criteria. The records are treated as a sample, not as the whole population. 
  • Calculates the variance of the entries in a column of a database table, in rows that meet the criteria. The records are treated as the whole population, not as a sample of the population.

Date and Time

DATE

DATEDIF

DAVEVALUE

DAY

DAYS

DAYS360

DAYSINMONTH

DAYSINYEAR

EASTERSUNDAY

EDATE

EOMONTH

HOUR

ISLEAPYEAR

MINUTE

MONTH

MONTHS

NETWORKDAYS

NOW

SECOND

TIME

TIMEVALUE

TODAY

WEEKDAY

WEEKNUM

WEEKNUM_ADD

WEEKS

WEEKSINYEAR

WORKDAY

YEAR

YEARFRAC

YEARS

  • Returns the date, given the year, month and day of the month. 
  • Returns the number of whole days, months or years between 'start date' and 'end date' * No Excel equivalent.
  • Returns a date-time serial number from a text date. 
  • Returns the day of a given date. 
  • Returns the number of days between two dates.  * No Excel equivalent.
  • Returns the number of days between two dates, using the 360 day year. 
  • Returns the number of days in the month of the given date.  * No Excel equivalent.
  • Returns the number of days in the year of the given date.  * No Excel equivalent.
  • Returns the date of Easter Sunday in a given year.  * No Excel equivalent.
  • Returns a date a number of months away. 
  • Returns the date of the last day of a month. 
  • Returns the hour of a given time. 
  • Tests if a date is in a leap year.  * No Excel equivalent.
  • Returns the minute of a given time. 
  • Returns the month of a given date. 
  • Returns the number of months between two dates.  * No Excel equivalent.
  • Returns the number of workdays between two dates. 
  • Returns the current date and time. 
  • Returns the seconds of a given time. 
  • Returns the time, given hours, minutes and seconds. 
  • Returns a date-time serial number from a text time. 
  • Returns today's date. 
  • Returns the day of the week for a given date. 
  • Returns the ISO week number of a given date. 
  • Returns the non-ISO week number of a given date.  * No Excel equivalent.
  • Returns the number of weeks between two dates.  * No Excel equivalent.
  • Returns the number of weeks in the year of the given date.  * No Excel equivalent.
  • Returns a date a given number of workdays away. 
  • Returns the year of a given date. 
  • Returns the number of years including fraction between two dates. 
  • Returns the number of years between two dates.  * No Excel equivalent.

Financial

ACCRINT

ACCRINTM

AMORDEGRC

AMORLINC

COUPDAYBS

COUPDAYS

COUPDAYSBS

COUPDAYSNC

COUPNCD

COUPNUM

COUPPCD

CUMIPMT

CUMIPMT_ADD

CUMPRINC

CUMPRINC_ADD

DB

DDB

DISC

DOLLARDE

DOLLARFR

DOLLRFR

DURATION

DURATION_ADD

EFFECT_ADD

EFFECTIVE

FV

FVSCEDULE

INTRATE

IPMT

IRR

ISPMT

MDURATION

MIRR

NOMINAL

NOMINAL_ADD

NPER

NPV

ODDFPRICE

ODDFYIELD

ODDLPRICE

ODDLYIELD

OPT_BARRIER

OPT_PROB_HIT

OPT_PROB_INMONEY

OPT_TOUCH

PMT

PPMT

PRICE

PRICEDISC

PRICEMAT

PV

RATE

RECEIVED

RRI

SLN

SYD

TBILLEQ

TBILLPRICE

TBILLYIELD

TBILLYIELD

VDB

XIRR

XNPV

YIELD

YIELDDISC

YIELDMAT

  • Calculates the accrued interest for a security with periodic interest payments. 
  • Calculates the accrued interest for a security that pays at maturity. 
  • Returns depreciation for a period using degressive depreciation (French system). 
  • Returns depreciation for a period using linear depreciation (French system). 
  • Returns the number of days between the coupon date preceding the settlement, and the settlement date. 
  • Returns the number of days in the coupon period that contains the settlement date. 
  • Returns the number of days from the beginning of the coupon period to the settlement date. * No Excel equivalent.
  • Returns the number of days between the settlement date and the next coupon date. 
  • Returns the coupon date next after the settlement date. 
  • Returns the number of coupons (interest payments) between the settlement date and maturity. 
  • Returns the coupon (interest payment) date which precedes the settlement date. 
  • Returns the total interest paid on a loan in specified periodic payments. 
  • Returns the total interest paid on a loan in specified periodic payments.  * No Excel equivalent.
  • Returns the total capital repaid on a loan in specified periodic payments. 
  • Returns the total capital repaid on a loan in specified periodic payments.  * No Excel equivalent.
  • Returns the depreciation of an asset for a given year using the fixed rate declining-balance method. 
  • Returns the depreciation of an asset for a given year using the double (or other factor) declining-balance method. 
  • Returns the discount rate of a security. 
  • Converts a fractional number representation of a number into a decimal number. 
  • Converts a price expressed as a decimal into a price expressed as a fraction.
  • Coverts a price expressed as a decimal into a price epressed as a fraction. * No Excel equivalent.
  • Returns the number of periods needed for an investment to reach a certain value. 
  • Returns the Macaulay duration of a security.  * No Excel equivalent.
  • Returns the effective compounded interest rate given a nominal interest rate.  * No Excel equivalent.
  • Returns the effective compounded interest rate given a nominal interest rate.  * Excel equivalent: EFFECT
  • Returns the future value of an initial sum with a subsequent stream of payments. 
  • Returns the future value of an initial sum, with changing future interest rates. 
  • Returns the equivalent annual interest rate for an investment bought at one price and sold at another. 
  • Returns the portion of the periodic payment which is interest for a fixed rate loan or annuity. 
  • Calculates the internal rate of return of a series of cash flows. 
  • Returns the interest paid in a period for a fixed rate loan. 
  • Returns the modified Macaulay duration of a security. 
  • Returns the modified internal rate of return of a series of cash flows. 
  • Returns a nominal interest rate given the effective compounded interest rate. 
  • Returns a nominal interest rate given the effective compounded interest rate.  * No Excel equivalent.
  • Returns the number of payment periods for an annuity. 
  • Returns the net present value of an investment with regular cash payments. 
  • Returns the value of a security per 100 currency units of face value, where the time to the first interest payment is not a whole period. 
  • Returns the yield of a security, where the time to the first interest payment is not a whole period. 
  • Returns the value of a security per 100 currency units of face value, where the last interest payment is not a whole period. 
  • Returns the yield of a security, where the last interest payment is not a whole period. 
  • Pricing of a barrier option. * No Excel equivalent.
  • Probability that an asset hits a barrier assuming it follows dS/S=mu dt+vol dW * No Excel equivalent.
  • Probablity that an asset will at maturity end up between two barrier levels, assuming it follows dS/S=mu dt+vol dW * No Excel equivalent.
  • Pricing of a touch/no-touch option. * No Excel equivalent.
  • Returns the payment per period for a fixed rate loan. 
  • Returns the portion of the periodic payment which is repaid capital for a fixed rate loan or annuity. 
  • Calculates a quoted price for an interest paying security, per 100 currency units par value. 
  • Calculates a price for a non-interest paying discounted bond. 
  • Calculates a price (per 100 currency units par value) for a bond that pays interest on maturity. 
  • Returns the present value of a stream of future payments with a final lump sum. 
  • Calculates the interest rate for an annuity. 
  • Calculates the amount received at maturity for a zero coupon bond. 
  • Returns an equivalent interest rate when an investment increases in value.  * No Excel equivalent.
  • Returns the depreciation of an asset in a single period using the straight-line depreciation method. 
  • Returns the depreciation of an asset for a given year using the sum-of-years'-digits method. 
  • Returns the bond-equivalent-yield (BEY) for a US Treasury bill. 
  • Returns the issue price for a US Treasury bill, per $100 par value, given a discount rate. 
  • Returns the yield for a treasury bill. * No Excel equivalent.
  • Returns the yield for a US Treasury bill. 
  • Returns the depreciation of an asset for a given year using a variable declining-balance method. 
  • Calculates the internal rate of return of a series of irregular cash flows. 
  • Returns the net present value of an investment with irregular cash payments. 
  • Calculates the yield for an interest paying security. 
  • Calculates the yield for a non-interest paying discounted bond. 
  • Calculates the yield for a bond that pays interest on maturity. 


Information 

CELL

CURRENT

FORMULA

INFO

ISBLANK

ISERR

ISERROR

ISEVEN_ADD

ISFORMULA

ISLOGICAL

ISNA

ISNONTEXT

ISNUMBER

ISODD_ADD

ISREF

ISTEXT

N

NA

TYPE

  • Returns information about the address, formatting or contents of a cell 
  • Returns the current (to date) result of evaluating the formula.  * No Excel equivalent.
  • Returns the formula used in a cell as a text string.  * No Excel equivalent.
  • Returns information about the current working environment. 
  • Tests if the cell is blank (empty). 
  • Tests for an error value other than #N/A (Not Available). 
  • Tests for any error value. 
  • Returns 1 if the value is an even number, or 0 if the value is odd.  * No Excel equivalent.
  • Tests if a cell contains a formula.  * No Excel equivalent.
  • Tests if a cell contains a logical value, TRUE or FALSE. 
  • Tests if a cell contains the #N/A (Not Available) error value. 
  • Tests if a cell contains non-text. 
  • Tests if a cell contains a number. 
  • Returns 1 if the value is an odd number, or 0 if the value is even.  * No Excel equivalent.
  • Tests if the argument is a reference to a cell or range of cells. 
  • Tests if a cell contains text. 
  • Returns the numeric value. 
  • Returns the #N/A (Not Available) error value . 
  • Returns the type of value (number, text, etc.). 

Logical

AND

FALSE

IF

IFERROR

IFNA

NOT

OR

TRUE

XOR

  • Returns TRUE if all the arguments are TRUE. 
  • Returns the logical value FALSE. 
  • Returns one of two values, depending on a test condition. 
  • Returns value if not an error value, else alternative. * No Excel equivalent.
  • Returns value if not a #N/A error, else alternative. * No Excel equivalent.
  • Returns TRUE if the argument is FALSE, and FALSE if the argument is TRUE. 
  • Returns TRUE if any of the arguments are TRUE. 
  • Returns the logical value TRUE. 
  • Returns TRUE if an odd number of arguments evaluates to TRUE. * No Excel equivalent.

Mathematical

ABS

ACOS

ACOSH

ACOT

ACOTH

ASIN

ASINH

ATAN

ATAN2

ATANH

BITAND

BITLSHIFT

BITOR

BITRSHIFT

BITXOR

CEILING

COMBIN

COMBINA

CONVERT

COS

COSH

COT

COTH

CSC

CSCH

DEGREES

EUROCONVERT

EVEN

EXP

FACT

FACTDOUBLE

FLOOR

GCD

GCD_ADD

INT

ISEVEN

ISODD

LCM

LCM_ADD

LN

LOG

LOG10

MOD

MROUND

MULTINOMIAL

ODD

PI

POWER

PRODUCT

QUOTIENT

RADIANS

RAND

RANDBETWEEN

ROUND

ROUNDDOWN

ROUNDUP

SEC

SECH

SERIESSUM

SIGN

SIN

SINH

SQRT

SQRTPI

SUBTOTAL

SUM

SUMIF

SUMIFS

SUMSQ

TAN

TANH

TRUNC

  • Returns the absolute value of a number. 
  • Returns the inverse cosine of a number. 
  • Returns the inverse hyperbolic cosine of a number. 
  • Returns the inverse cotangent of a number.  * No Excel equivalent.
  • Returns the inverse hyperbolic cotangent of the given number.  * No Excel equivalent.
  • Returns the inverse sine of a number. 
  • Returns the inverse hyperbolic sine of a number. 
  • Returns the inverse tangent of a number. 
  • Returns the inverse tangent for specified x and y coordinates. 
  • Returns the inverse hyperbolic tangent of a number. 
  • Bitwise "AND" of two integers. * No Excel equivalent.
  • Bitwise left shift of an integer value. * No Excel equivalent.
  • Bitwise "OR" of two integers. * No Excel equivalent.
  • Bitwise right shift of an integer value. * No Excel equivalent.
  • Bitwise "exclusive OR" of two integers. * No Excel equivalent.
  • Returns a number rounded up to a multiple of another number. 
  • Returns the number of combinations of a subset of items. 
  • Returns the number of ordered combinations of a subset of items.  * No Excel equivalent.
  • Converts between legacy European currencies and Euros. 
  • Returns the cosine of an angle. 
  • Returns the hyperbolic cosine of an angle. 
  • Returns the cotangent of an angle.  * No Excel equivalent.
  • Returns the hyperbolic cotangent of a given number (angle).  * No Excel equivalent.
  • Return the cosecant of an angle. CSC(X)=1/SIN(X) * No Excel equivalent.
  • Return the hyperbolic cosecant of a hyperbolic angle. CSCH(X)=1/SINH(X) * No Excel equivalent.
  • Converts radians into degrees. 
  • Converts a value from one to another old European national currency of euro.
  • Rounds a number to the next even integer away from zero. 
  • Returns e raised to the power of a number. 
  • Returns the factorial of a number, n!. 
  • Returns the double factorial of a number, n!!. 
  • Rounds a number down to the nearest multiple of another number. 
  • Returns the greatest common divisor of two or more integers. 
  • Returns the greatest common divisor of a list of numbers.  * No Excel equivalent.
  • Rounds a number down to the nearest integer. 
  • Returns TRUE if the value is an even number. 
  • Returns TRUE if the value is an odd number. 
  • Returns the least common multiple of one or more integers. 
  • Returns the lowest common multiple of a list of numbers.  * No Excel equivalent.
  • Returns the logarithm of a number to the specified base. 
  • Returns the natural logarithm of a number. 
  • Returns the base-10 logarithm of a number. 
  • Returns the remainder when one integer is divided by another. 
  • Returns a number rounded to the nearest multiple of another number. 
  • Returns the factorial of the sum divided by the product of the factorials. 
  • Rounds a number up to the next highest odd integer. 
  • Returns the value of PI. 
  • Returns a number raised to a power. 
  • Multiplies all the numbers given as arguments and returns the product. 
  • Returns the integer result of a division operation. 
  • Converts degrees into radians. 
  • Returns a random number between 0 and 1. 
  • Returns an integer random number in a specified range. 
  • Rounds a number to a certain precision. 
  • Rounds a number down, toward zero, to a certain precision. 
  • Rounds a number up, away from zero, to a certain precision. 
  • Returns the secant of an angle. SEC(X)=1/COS(X) * No Excel equivalent.
  • Returns the hyperbolic secant of a hyperbolic angle. SECH(X)=1/COSH(X) * No Excel equivalent.
  • Sums the first terms of a power series. 
  • Returns the sign of a number. 
  • Returns the sine of an angle. 
  • Returns the hyperbolic sine of an angle. 
  • Returns the positive square root of a number. 
  • Returns the square root of (PI times a number). 
  • Returns SUM, AVERAGE, STDDEV, etc. results for filtered data. 
  • Sums the contents of cells. 
  • Conditionally sums the contents of cells in a range. 
  • Totals the arguments that meet the conditions. * No Excel equivalent.
  • Returns the sum of the squares of numbers. 
  • Returns the tangent of an angle. 
  • Returns the hyperbolic tangent of an angle. 
  • Truncates a number by removing decimal places. 

Spreadsheet

ADDRESS

AREAS

CHOOSE

COLUMN

COLUMNS

DDE

ERRORTYPE

HLOOKUP

HYPERLINK

INDEX

INDIRECT

LOOKUP

MATCH

OFFSET

ROW

ROWS

SHEET

SHEETS

STYLE

VLOOKUP

  • Returns a text representation of a cell reference, given row and column numbers. 
  • Returns the number of areas in a given reference. 
  • Returns a value from a list, given an index number. 
  • Returns the column number(s), given a reference. 
  • Returns the number of columns in a given reference. 
  • Returns information from other documents and applications, using the "DDE" protocol.  * No Excel equivalent.
  • Returns the number corresponding to an error value.  * Excel equivalent: ERROR.TYPE
  • Returns a value from a table row, in the column found by lookup in the first row. 
  • Sets a cell to open a hyperlink (in another application) when clicked. 
  • Returns a value from a table, given a row and column number. 
  • Returns a reference, given a text string. 
  • Returns result from one single-cell-wide table, corresponding to a lookup search in another. 
  • Returns the position of a search item in a single row or column table. 
  • Returns a modified reference, given a reference, an offset, and a desired size. 
  • Returns the row number(s), given a reference. 
  • Returns the number of rows in a given reference. 
  • Returns the sheet number, given a reference.  * No Excel equivalent.
  • Eeturns the number of sheets in a given reference.  * No Excel equivalent.
  • Applies a style (for example a colour) to a cell.  * No Excel equivalent.
  • Returns a value from a table column, in the row found by lookup in the first column. 

Statistical

AVEDEV

AVERAGE

AVERAGEA

AVERAGEIF

AVERAGEIFS

B

BETA.DIST

BETA.INV

BETADIST

BETAINV

BINOMDIST

CHIDIST

CHIINV

CHISQ.DIST


CHISQ.DIST.RT

CHISQ.INV

CHISQ.INV.RT

CHISQ.TEST

CHISQDIST

CHISQINV

CHITEST

CONFIDENCE

CONFIDENCE.NORM

CONFIDENCE.T

CORREL

COUNT

COUNTA

COUNTBLANK

COUNTIF

COUNTIFS

COVAR

COVARIANCE.P

COVARIANCE.S

CRITBINOM

DEVSQ

EXPON.DIST

EXPONDIST

F.DIST

F.DIST.RT

F.INV

F.INV.RT

F.TEST

FDIST

FINV

FISHER

FISHERINV

FORECAST

FTEST

GAMMA

GAMMADIST

GAMMAINV

GAMMALN

GAUSS

GEOMEAN

HARMEAN

HYPGEOM.DIST

HYPGEOMDIST

INTERCEPT

KURT

LARGE

LOGINV

LOGNORMDIST

MAX

MAXA

MEDIAN

MIN

MINA

MODE

NEGBINOMDIST

NORMDIST

NORMINV

NORMSDIST

NORMSINV

PEARSON

PERCENTILE

PERCENTRANK

PERMUT

PERMUTATIONA

PHI

POISSON

PROB

QUARTILE

RANK

RSQ

SKEW

SLOPE

SMALL

STANDARDIZE

STDEV

STDEV.P

STDEV.S

STDEVA

STDEVP

STDEVPA

STEYX

TDIST

TINV

TRIMMEAN

TTEST

VAR

VAR.P

VAR.S

VARA

VARP

VARPA

WEIBULL

WEIBULL.DIST

ZTEST

  • Returns the average of the absolute deviations of values from their mean. 
  • Returns the average of the arguments, ignoring text. 
  • Returns the average of the arguments, including text (valued as 0). 
  • Averages the arguments that meet the conditions. * No Excel equivalent.
  • Averages the value of the cells that meet multiple criteria in multiple ranges. * No Excel equivalent.
  • Calculates probabilities for a binomial distribution.  * No Excel equivalent.
  • Values of the beta distribution. * No Excel equivalent.
  • Values of the inverse beta distribution. * No Excel equivalent.
  • Calculates the cumulative distribution function of a beta distribution. 
  • Calculates the inverse of the BETADIST function. 
  • Calculates probabilities for a binomial distribution. 
  • Calculates right-tail values for a cumulative χ2-distribution. 
  • Calculates the inverse of the CHIDIST function. 
  • Returns the left-tail probability of the cumulative distribution funcion or values of the probability density function of the chi-square distribution. * No Excel equivalent.
  • Returns the right-tail probability of the chi-square distribution. * No Excel equivalent.
  • Values of the inverse of CHISQ.DIST(x;DegreesOfFreedom;TRUE()) * No Excel equivalent.
  • Values of the inverse of CHISQDIST(x;DegreesOfFreedom) * No Excel equivalent.
  • Returns the chi-square independent test. * No Excel equivalent.
  • Calculates left-tail values for a cumulative χ2-distribution or values for the density function.  * No Excel equivalent.
  • Calculates the inverse of the CHISQDIST function.  * No Excel equivalent.
  • Returns a measure of χ2 'goodness of fit'. 
  • Returns a confidence interval. 
  • Returns a (1 alpha) confidence interval for a normal distribution. * No Excel equivalent.
  • Returns a (1 alpha) confidence interval for a Student's distribution. * No Excel equivalent.
  • Returns the correlation coefficient between two data sets. 
  • Counts the numbers in the list of arguments, ignoring text entries. 
  • Counts the non-empty values in the list of arguments. 
  • Returns the number of empty cells. 
  • Counts the number of cells in a range that meet a specified condition. 
  • Counts the cells that meet multiple criteria in multiple ranges. * No Excel equivalent.
  • Returns the covariance of the product of paired deviations. 
  • Calculates the population covariance. * No Excel equivalent.
  • Calculates the sample covariance. * No Excel equivalent.
  • Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. 
  • Returns the sum of squares of deviations from the mean. 
  • Calculates values for an exponential distribution.  * No Excel equivalent.
  • Calculates values for an exponential distribution. 
  • Values of the left tail F probability distribution. * No Excel equivalent.
  • Values of the right tail F probability distribution. * No Excel equivalent.
  • Values of the inverse left tail F distribution. * No Excel equivalent.
  • Values of the inverse right tail F distribution. * No Excel equivalent.
  • Calculates the F-test. * No Excel equivalent.
  • Calculates the values of an F distribution. 
  • Returns the inverse of the F probability distribution. 
  • Calculates values for the Fisher transformation. 
  • Calculates the inverse of the FISHER transformation. 
  • Extrapolates future values based on existing x and y values. 
  • Returns the result of an F test. 
  • Calculates the GAMMA function; not a statical function, but actually in this category.  * No Excel equivalent.
  • Calculates values for a gamma distribution. 
  • Calculates the inverse of the cumulative GAMMADIST function. 
  • Returns the natural logarithm of the gamma function. 
  • Returns the standard normal cumulative distribution.  * No Excel equivalent.
  • Returns the geometric mean of the arguments. 
  • Returns the harmonic mean of the arguments. 
  • Values of the hypergeometric distribution. * No Excel equivalent.
  • Calculates values for a hypergeometric distribution. 
  • Calculates the point at which a line will intersect the y-values by using known x-values and y-values. 
  • Returns the kurtosis, a measure of how peaked or flat a distribution is. 
  • Returns the nth largest value in a list of numbers. 
  • Returns the inverse of the lognormal distribution. 
  • Returns the cumulative lognormal distribution. 
  • Returns the maximum value in a list of arguments. 
  • Returns the maximum value in a list of arguments including text. 
  • Returns the median of a set of numbers. 
  • Returns the minimum value in a list of arguments. 
  • Returns the minimum value in a list of arguments, including text. 
  • Returns the most common value in a set of numbers. 
  • Calculates probabilities for a negative binomial distribution. 
  • Calculates values for a normal distribution. 
  • Returns the inverse of the normal cumulative distribution. 
  • Calculates values for the standard normal cumulative distribution. 
  • Returns the inverse of the standard normal cumulative distribution. 
  • Returns the Pearson product moment correlation coefficient r. 
  • Returns a specified percentile in a list of numbers. 
  • Returns the percentage rank of a number in a list of numbers. 
  • Returns the number of permutations for a given number of objects. 
  • Returns the number of permutations for a given number of objects (repetition allowed).  * No Excel equivalent.
  • Calculates values for the standard normal probability distribution.  * No Excel equivalent.
  • Calculates values for a Poisson distribution. 
  • Returns a result from a list of probabilities. 
  • Returns a specified quartile in a list of numbers. 
  • Returns the rank of a number in a list of numbers. 
  • Returns the square of the Pearson correlation coefficient based on the given values. 
  • Returns a measure of how skewed a distribution is. 
  • Returns the slope of the linear regression line for a data set. 
  • Returns the nth smallest value in a list of numbers. 
  • Converts a random variable to a normalized value. 
  • Returns the sample standard deviation. 
  • Calculates the standard deviation based on the entire population. * No Excel equivalent.
  • Calculates the standard deviation based on a sample. * No Excel equivalent.
  • Returns the sample standard deviation (allowing text and logical values). 
  • Returns the population standard deviation. 
  • Returns the population standard deviation (allowing text and logical values). 
  • Returns the standard error of the predicted y value for each x in the regression. 
  • Returns the t-distribution. 
  • Returns the inverse of the t-distribution. 
  • Returns the mean of a set of numbers, ignoring a proportion of high and low values. 
  • Returns the probability associated with a Student's t-Test. 
  • Returns the sample variance. 
  • Calculates variance based on the entire population. * No Excel equivalent.
  • Calculates variance based on a sample. * No Excel equivalent.
  • Returns the sample variance (allowing text and logical values). 
  • Returns the population variance. 
  • Returns the population variance (allowing text and logical values). 
  • Returns the values of the Weibull distribution. 
  • Returns the values of the Weibull distribution.  * No Excel equivalent.
  • Returns the two-tailed P value of a z test with standard distribution. 

Text

ARABIC

ASC

BAHTTEXT

BASE

CHAR

CLEAN

CODE

CONCATENATE

DECIMAL

DOLLAR

EXACT

FILERXML

FIND

FIXED

JIS

LEFT

LEFTB

LEN

LENB

LOWER

MID

MIDB

NUMBERVALUE

PROPER

REPLACE

REPT

RIGHT

RIGHTB

ROMAN

SEARCH

SUBSTITUTE

T

TEXT

TRIM

UNICHAR

UNICODE

UPPER

VALUE

WEBSERVICE

  • Returns an Arabic number (eg 14), given a Roman number (eg XIV).  * No Excel equivalent.
  • Converts full-width ASCII and katakana characters to half-width.
  • Returns Thai text, given a number. 
  • Returns a text representation of a number, in a specified base radix.  * No Excel equivalent.
  • Returns a single text character, given a character code. 
  • Returns a text string with non-printing characters removed. 
  • Returns the numeric code for the first character in a text string. 
  • Combines several text strings into one string. 
  • Returns a decimal number, given a text representation and its base radix.  * No Excel equivalent.
  • Returns text representing a number in your local currency format. 
  • Returns TRUE if two text strings are identical 
  • Apply an XPath expression to an XML document. * No Excel equivalent.
  • Returns the position of a string of text within another string. 
  • Returns a number as text with a specified format. 
  • Converts half-width ASCII and katakana characters to full-width.
  • Returns text from the beginning of a text string. 
  • Returns text from the beginning of a text string, with DBCS.
  • Returns the length of a text string. 
  • Returns the length of a text string, with DBCS.
  • Converts a text string to lowercase. 
  • Returns text from the middle of a text string. 
  • Returns text from the middle of a text string, with DBCS.
  • Converts a text string to a number, in a locale-independent way. * No Excel equivalent.
  • Returns text with words in lowercase after a capitalised first letter. 
  • Replaces part of a text string with a different text string. 
  • Returns a text string comprised of copies of another text string. 
  • Returns text from the end of a text string. 
  • Returns text from the end of a text string, with DBCS.
  • Returns a Roman numeral (eg XIV), given a number. 
  • Returns the position of a text segment within a text string.  * Excel equivalent: SEARCH, SEARCHB
  • Substitutes new text for old text in a text string. 
  • Returns the given text, or an empty text string if the target is not text. 
  • Converts a number into text according to a given format. 
  • Removes excess spaces from a text string. 
  • Converts a code number into a Unicode character or letter. * No Excel equivalent.
  • Returns the numberic code for the first Unicode character in a text string. * No Excel equivalent.
  • Converts a text string to uppercase. 
  • Returns a number, given a text representation. 
  • Get some webcontent from an URI. * No Excel equivalent.