Creation of Worlds — Appendices. Worksheet Functions in LO Calc

Functions in LO Calc (and similar functions in MO Excel) Functions Mathematical (Math&Trig)

LO Calc function (English)	Description	MO Excel function (Russian)
ABS	Returns the absolute value of a number	ABS
ACOS	Returns the arccosine of a number. To convert the result from radians to degrees, multiply it by 180/PI()	ACOS
ACOSH	Returns the inverse hyperbolic cosine of a number	ACOSH
ASIN	Returns the arcsine of a number	ASIN
ASINH	Returns the inverse hyperbolic sine of a number	ASINH
ATAN	Returns the arctangent of a number	ATAN
ATAN2	Returns the arctangent for given X and Y coordinates	ATAN2
ATANH	Returns the inverse hyperbolic tangent of a number	ATANH
COS	Returns the cosine of a given angle	COS
COSH	Returns the hyperbolic cosine of a number	COSH
EXP	Returns the number e raised to the specified power	EXP
LN	Returns the natural logarithm of a number	LN
LOG	Returns the logarithm of a number to the specified base. If the base is omitted, it defaults to 10	LOG
LOG10	Returns the base-10 logarithm of a number	LOG10
SIN	Returns the sine of a given angle	SIN
SINH	Returns the hyperbolic sine of a number	SINH
TAN	Returns the tangent of a given angle	TAN
TANH	Returns the hyperbolic tangent of a number	TANH
DEGREES	Converts radians to degrees	DEGREES
SIGN	Returns 1 if the number is positive, 0 if the number equals 0, and -1 if the number is negative	SIGN
SQRT	Returns the positive square root of a non-negative number	SQRT
MINVERSE	Returns the inverse matrix	MINVERSE
MDETERM	Returns the determinant of a matrix	MDETERM
MMULT	Returns the matrix product	MMULT
ODD	Returns the number rounded up to the nearest odd integer	ODD
CEILING	Returns a number rounded up to the nearest multiple of significance	OKPBBEPX
FLOOR	Returns a number rounded down to the nearest multiple of significance	FLOOR
ROUND	Rounds a number to the specified number of decimal places	ROUND
ROUNDUP	Rounds a number up, away from zero, to the nearest integer	ROUNDUP
ROUNDDOWN	Rounds a number down, toward zero, to the nearest integer	FLOOR
MOD	Returns the remainder from division of a number by a divisor	MOD
TRUNC	Truncates a number to an integer by removing its fractional part	TRUNC
PI( )	Returns the value of the mathematical constant pi	PI
PRODUCT	Returns the product of the numbers given as arguments	PRODUCT
SUBTOTAL	Returns a subtotal in a spreadsheet	SUBTOTAL
RADIANS	Converts degrees to radians	RADIANS
ROMAN	Converts an Arabic numeral to a Roman numeral	ROMAN
RAND	Returns a uniformly distributed random number greater than or equal to 0 and less than 1	RAND
POWER	Returns the result of a number raised to a power	POWER
SUM	Returns the sum of all numbers in the argument list	SUM
SUMIF	Returns the sum of values in cells that meet a specified criterion	SUMIF
SUMSQ	Returns the sum of the squares of the arguments	SUMSQ
SUMXMY2	Returns the sum of squares of differences between corresponding values in two arrays	SUMXMY2
SUMPRODUCT	Returns the sum of products of corresponding elements in the arrays	SUMPRODUCT
SUMX2MY2	Returns the sum of differences of squares of corresponding values in two arrays	SUMX2MY2
SUMX2PY2	Returns the sum of sums of squares of corresponding elements in two arrays	SUMX2PY2
COUNTIF	Returns the number of non-empty cells in a specified range that satisfy a given criterion	COUNTIF
COUNTBLANK	Returns the number of empty cells in a specified range	COUNTBLANK
FACT	Returns the factorial of a number	FACT
INT	Returns the number rounded down to the nearest integer	INT
EVEN	Returns the number rounded up to the nearest even integer	EVEN
COMBIN	Returns the number of combinations for a given number of objects	COMBIN

Functions Statistical (Statistical)

Calc function (English)	Description	Excel function (Russian)
FDISP	Returns the F-probability distribution	FDIST
FINV	Returns the inverse of the F-probability distribution	FINV
ZTEST	Returns the two-tailed P-value of a z-test	ZTECT
BETAINV	Returns the inverse of the cumulative beta probability density function	BETAINV
BETADIST	Returns the cumulative beta probability density function	BETADIST
BINOMDIST	Returns the individual term of the binomial distribution	BINOMDIST
WEIBULL	Returns the Weibull distribution	WEIBULL
PROB	Returns the probability that the value from of the interval is within the specified limits	PROB
GAMMALN	Returns the natural logarithm of the gamma function, G(x)	GAMMALN
GAMMAINV	Returns the inverse of the gamma distribution	GAMMAINV
GAMMADIST	Returns the gamma distribution	GAMMADIST
HYFGEOMDIST	Returns the hypergeometric distribution	HYPGEOMDIST
VAR	Returns the variance based on a sample	VAR
VARP	Returns the variance for the entire population	VARP
CONFIDENCE	Returns the confidence interval for the population mean	CONFIDENCE
DEVSQ	Returns the sum of squares of deviations of data points from their mean	DEVSQ
QUARTILE	Returns the quartile of a data set	QUARTILE
RSQ	Returns the square of the Pearson correlation coefficient	RSQ
COVAR	Returns the covariance, i.e. the average of the products of deviations for each pair of data points	COVAR
CORREL	Returns the correlation coefficient	CORREL
CRITBINOM	Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criterion	CRITBINOM
LOGEST	Returns the parameters of an exponential regression equation	LOGEST
LINEST	Returns the parameters of a linear regression equation	LINEST
LOGINV	Returns the inverse of the lognormal cumulative distribution function	LOGINV
LOGNORMDIST	Returns the cumulative lognormal distribution	LOGNORMDIST
MAX	Returns the maximum value from of the argument list	MAX
MEDIAN	Returns the median of the given set of numbers	MEDIAN
MIN	Returns the minimum value in the argument list	MIN
MODE	Returns the most frequently occurring value in a data set	MODE
LARGE	Returns the k-th largest value in a data set	LARGE
SMALL	Returns the k-th smallest value in a data set	SMALL
SLOPE	Returns the slope of the linear regression line	SLOPE
STANDARDIZE	Returns a normalized value for a distribution characterised by a given mean and standard deviation	STANDARDIZE
NORMINV	Returns the inverse of the normal distribution for a specified mean and standard deviation	NORMINV
NOPMDIST	Returns the normal distribution function for a specified mean and standard deviation	NORMDIST
NORMSINV	Returns the inverse of the standard normal distribution	NORMSINV
NORMSDIST	Returns the standard normal cumulative distribution	NORMSDIST
NEGBIMOMDIST	Returns the negative binomial distribution	NEGBINOMDIST
INTERCEPT	Returns the intercept of the linear regression line	INTERCEPT
PERMUT	Returns the number of permutations for a given number of objects selected from the total number of objects	PERMUT
PERCENTILE	Returns the k-th percentile of values in a range	PERCENTILE
PEARSON	Returns the Pearson correlation coefficient	PEARSON
FORECAST	Returns a predicted value at a given point based on the linear regression equation	FORECAST
PERCENTRANK	Returns the percentage rank of a value in a data set	PERCENTRANK
POISSON	Returns the Poisson distribution	POISSON
RANK	Returns the rank of a number in a list of numbers. The rank of a number is its magnitude relative to other values in the list	RANK
GROWTH	Returns values according to the exponential regression equation	GROWTH
SKEW	Returns the skewness of a distribution	SKEW
HARMEAN	Returns the harmonic mean of a data set	HARMEAN
GEOMEAN	Returns the geometric mean of the values	GEOMEAN
AVERAGE	Returns the arithmetic mean	AVERAGE
AVEDEV	Returns the average of the absolute deviations of data points from their mean	AVEDEV
STDEV	Returns the standard deviation based on a sample	STDEV
STDEVP	Returns the standard deviation for the entire population	STDEVP
STEXY	Returns the standard error of predicted y-values for each x in a regression	STEXY
TDIST	Returns Student's t-distribution	TDIST
TINV	Returns the inverse of Student's t-distribution for a specified number of degrees of freedom	TINV
COUNT	Returns the count of numbers in the argument list	COUNT
COUNTA	Returns the count of non-empty values in the argument list	COUNTA
TREND	Returns values according to the linear regression equation	TREND
TTEST	Returns the probability associated with Student's t-test	TTEST
TRIMMEAN	Returns the trimmed mean of a data set	TRIMMEAN
FISHER	Returns the Fisher transformation	FISHER
FISHERINV	Returns the inverse of the Fisher transformation	FISHERINV
FTEST	Returns the result of an F-test	FTEST
CHIINV	Returns the inverse of the chi-squared distribution	CHIINV
CHIDIST	Returns the one-tailed probability of the chi-squared distribution	CHIDIST
CHITEST	Returns the test of independence	CHITEST
FREQUENCY	Returns a frequency distribution as a vertical array	FREQUENCY
EXPONDIST	Returns the exponential distribution	EXPONDIST
KURT	Returns the kurtosis of a data set	KURT

Functions Date & Time (Date & Time)

Calc function (English)	Description	Excel function (Russian)
TIMEVALUE	Returns the serial number for a time given as a text string	TIMEVALUE
TIME	Returns the serial number for a given time	TIME
YEAR	Returns the year corresponding to the specified date	YEAR
DATE	Returns the serial number of the specified date	DATE
DATEVALUE	Returns the serial number of the specified date given as a text string	DATEVALUE
DAY	Returns the day of the month for the specified date	DAY
WEEKDAY	Returns the day of the week for the specified date	WEEKDAY
DAYS360	Returns the number of days between two dates based on a 360-day year	DAYS360
MONTH	Returns the month corresponding to the specified date	MONTH
MINUTE	Returns the minutes corresponding to the specified time	MINUTE
TODAY	Returns the current date as a serial number	TODAY
SECOND	Returns the seconds corresponding to the specified time	SECOND
NOW	Returns the current date and time as a serial number	NOW
HOUR	Returns the hour corresponding to the specified time	HOUR

Functions Logical (Logical)

Calc function (English)	Description	Excel function (Russian)
IF	Returns the first value if the logical expression evaluates to TRUE, and the second value if it evaluates to FALSE	IF
AND	Returns TRUE if all arguments are TRUE; returns FALSE if at least one argument is FALSE	AND
OR	Returns TRUE if at least one argument is TRUE; returns FALSE if all arguments are FALSE	OR
TRUE	Returns the logical value TRUE	TRUE
FALSE	Returns the logical value FALSE	FALSE
NOT	Reverses the logical value of its argument	NOT

Functions Reference & Arrays (Reference)

Calc function (English)	Description	Excel function (Russian)
ADDRESS	Returns a cell address as text, using a row number and a column number	ADDRESS
VLOOKUP	Searches the leftmost column of an array for a specific value and returns a value from the specified cell	VLOOKUP
CHOOSE	Returns a value from an argument list based on a given index number	CHOOSE
HLOOKUP	Searches the top row of an array for a specific value and returns a value from the specified cell	HLOOKUP
INDIRECT	Returns the value of the cell referenced by the cell address stored in the specified cell	INDIRECT
INDEX	Returns the value of the specified cell or an array of values in the array argument	INDEX
AREAS	Returns the number of areas in a reference	AREAS
MATCH	Returns the relative position of an array element that matches a specified value in a specified manner	MATCH
LOOKUP	Searches for values in a vector or array. The LOOKUP function has two syntactic forms: vector and array	LOOKUP
OFFSET	Returns a reference of a specified height and width, offset from another reference by a given number of rows and columns	OFFSET
COLUMN	Returns the column number of a given reference	COLUMN
ROW	Returns the row number of a given reference	ROW
TRANSPOSE	Returns a transposed array	TRANSPOSE
COLUMNS	Returns the number of columns in a reference	COLUMNS
ROWS	Returns the number of rows in a reference	ROWS

Functions Text (Text)

Calc function (English)	Description	Excel function (Russian)
LEN	Returns the number of characters in a text string	LEN
REPLACE	Replaces part of a text string with another text string	REPLACE
VALUE	Converts text to a number	VALUE
CODE	Returns the numeric code of the first character in a text string	CODE
LEFT	Returns the first characters of a text string	LEFT
FIND	Finds the occurrence of one text string within another and returns the character number, with at which the first occurrence of the sought string begins	FIND
CLEAN	Removes all non-printable characters from text	CLEAN
REPT	Repeats text a specified number of times	REPT
SUBSTITUTE	Substitutes text within a string	SUBSTITUTE
SEARCH	Returns the position of the first occurrence of a character or text string, searching from left to right	SEARCH
RIGHT	Returns the last characters of a text string	RIGHT
UPPER	Converts all letters in a text string to uppercase	UPPER
PROPER	Capitalises the first letter in a text string and all first letters following any character other than a letter. Converts all other letters to lowercase	PROPER
MID	Returns a specified number of characters from a text string, starting at the specified position	MID
DOLLAR	Converts a number to text using currency format with rounding to the specified number of decimal places	DOLLAR
TRIM	Removes all spaces from text except for single spaces between words	TRIM
CHAR	Returns the character with the given code	CHAR
EXACT	Compares two text strings and returns the value TRUE if they match exactly and FALSE otherwise	EXACT
LOWER	Converts all characters in a text string from uppercase to lowercase	LOWER
CONCATENATE	Joins several text elements into one	CONCATENATE
T	If the value is text or refers to text, the function T returns that value itself. If the value is not text and does not refer to text, the function T returns an empty string	T
TEXT	Converts a value to text in the specified numeric format	TEXT
FIXED	Rounds a number to a specified number of decimal digits, formats the number in decimal format using commas and of points and returns the result as text	FIXED

Functions Financial (Finance)

Calc function (English)	Description	Excel function (Russian)
SYD	Returns the sum-of-years digits depreciation of an asset for a specified period	SYD (cost; salvage; life; period)
SLN	Returns the straight-line depreciation of an asset for one period	SLN (cost; salvage; life)
FV	Returns the future value of an investment based on periodic constant payments and a constant interest rate	FV (rate; nper; pmt; pv; type)
IRR	Returns the internal rate of return for a series of consecutive cash flows represented by numeric values	IRR (values; guess)
DDB	Returns the depreciation of an asset for a specified period using the double-declining balance method or another explicitly specified method	DDB (cost; salvage; life; period; factor)
DB	Returns the depreciation of an asset for a given period using the fixed-declining balance method	DB (cost; salvage; life; period; month)
NPER	Returns the total number of payment periods for an investment based on periodic constant payments and a constant interest rate	NPER (rate; pmt; pv; fv; type)
MIRR	Returns the modified internal rate of return for a series of consecutive periodic cash flows	MIRR (values; finance_rate; reinvest_rate)
RATE	Returns the interest rate per period of an annuity	RATE (nper; pmt; pv; fv; type; guess)
NPV	Returns the net present value of an investment based on a series of periodic cash flows and a discount rate	NPV (rate; value1; value2; ...)
PPMT	Returns the payment on the principal for a given period, based on periodic constant payments and a constant interest rate	PPMT (rate; per; nper; pv; fv; type)
VDB	Returns the depreciation of an asset for any period including partial periods, using the double-declining balance method or another explicitly specified method	VDB (cost; salvage; life; start_period; end_period; factor; no_switch)
PV	Returns the present value of an investment	PV (rate; nper; pmt; fv; type)
IFMT	Returns the interest payment for a given period, based on periodic constant payments and a constant interest rate	IPMT (rate; per; nper; pv; fv; type)
PMT	Returns the periodic payment for an annuity based on constant payments and a constant interest rate	PMT (rate; nper; pv; fv; type)

Functions Database (Database)

Calc function (English)	Description	Excel function (Russian)
DVAR	Estimates the variance of a population based on a sample, using the numbers in the specified field of all database records that satisfy the criterion	DVAR
DVARP	Calculates the variance of the entire population, using the numbers in the specified field of all database records that satisfy the criterion	DVARP
DPRODUCT	Multiplies the values in the specified field of all records that satisfy the criterion	DPRODUCT
DSUM	Sums the numbers in the specified field of all database records that satisfy the criterion	DSUM
DGET	Extracts a single value from a database that satisfies the criterion	DGET
DCOUNT	Counts the number of cells containing numbers in all database records that satisfy the criterion	DCOUNT
DC0UNTA	Counts non-empty cells in the specified field of all database records that satisfy the criterion	DCOUNTA
DMAX	Returns the largest number in the specified field of all database records that satisfy the criterion	DMAX
DMIN	Returns the smallest number in the specified field of all database records that satisfy the criterion	DMIN
DAVERAGE	Returns the average value in the specified field of all records that satisfy the criterion	DAVERAGE
DSTDEV	Returns the standard deviation for a sample from the population, using the numbers in the specified field of all database records that satisfy the criterion	DSTDEV
DSTDEVP	Returns the standard deviation of the entire population, using the numbers in the specified field of all database records that satisfy the criterion	DSTDEVP

Functions Information (Information)

Calc function (English)	Description	Excel function (Russian)
ISLOGICAL	Returns TRUE if the value being tested is a logical value; otherwise returns FALSE	ISLOGICAL
ISNA	Returns TRUE if the value being tested is the #N/A error value; otherwise returns FALSE	ISNA
ISNOTEXT	Returns TRUE if the value being tested is not text; otherwise returns FALSE	EHETEKCT
ISERR	Returns TRUE if the value being tested is any error value except #N/A; otherwise returns FALSE	ISERR
ISERROR	Returns TRUE if the value being tested is any error value in Calc; otherwise returns FALSE	ISERROR
ISBLANK	Returns TRUE if the value being tested is a reference to an empty cell; otherwise returns FALSE	ISBLANK
ISREF	Returns TRUE if the value being tested is a reference; otherwise returns FALSE	ISREF
ISTEXT	Returns TRUE if the value being tested is text; otherwise returns FALSE	ISTEXT
ISNUMBER	Returns TRUE if the value being tested is a number; otherwise returns FALSE	ISNUMBER
INFO	Returns information about the current operating environment	INFO
NA	Returns the error value #N/A, which means that no value is available	NA
TYPE	Returns the type of a value	TYPE
ERROR.TYPE	Returns a number corresponding to one of the possible error values in Calc	ERROR.TYPE
N	Returns a value converted to a number	N
CELL	Returns information about the format, location, or contents of the upper-left cell in a reference	CELL