FPSpreadsheet: List of formulas

This is a list of the formulas supported by FPSpreadsheet:

Calling prototye	Meaning	Argument types	Arguments	Result type
Mathematical functions
ABS(num)	Returns the absolute value of a number	float or cell reference	1	float
ACOS(num)	Returns the arccosine (in radians) of a number	float or cell reference (>= -1 and <= +1)	1	float
ACOSH(num)	Returns the inverse hyperbolic cosine of a number	float or cell reference (>=1)	1	float
ASIN(num)	Returns the arcsine (in radians) of a number	float or cell reference (>= -1 and <=+1)	1	float
ASINH(num)	Returns the inverse hyperbolic sine of a number	float or cell reference	1	float
ATAN(num)	Returns the arctangent (in radians) of a number	float or cell reference	1	float
ATANH(num)	Returns the inverse hyperbolic tangent of a number	float or cell reference (> -1 and < +1)	1	float
COS(num)	Returns the cosine of an angle (in radians)	float or cell reference	1	float
COSH(num)	Returns the hyperbolic cosine of a number	float or cell reference	1	float
DEGREES(num)	Converts an angle from radians to degrees	float or cell reference	1	float
EXP(num)	Calculates the exponential function of a number	float or cell reference	1	float
INT(num)	Returns the integer portion of a number (like "floor()")	float or cell reference	1	integer
LN(num)	Calculates the natural logarithm of a number	float or cell reference (> 0)	1	float
LOG(num [, base])	Calculates the logarithm of a number to a specified base. base, if omitted, is 10.	float or cell reference (> 0)	1 or 2	float
LOG10(num)	Calculates the base-10 logarithm of a number	float or cell reference (> 0)	1	float
PI()	Returns the mathematical constant π (3.14159265358979)	none	0	float
POWER(num, exponent)	Returns the result of a number raised to a given power	float or cell reference	2	float
RADIANS(num)	Converts an angle from degrees to radians	float or cell reference	1 or 2	float
RAND()	Returns a random number between 0 and 1	none	0	float
ROUND(num, digits)	Returns a number rounded to a specified number of digits	float or cell reference	2	float
SIGN(num)	Returns the sign of a number	float or cell reference	1	integer
SIN(num)	Returns the sine of an angle (in radians)	float or cell reference	1	float
SINH(num)	Returns the hyperbolic sine of a number	float or cell reference	1	float
TAN(num)	Returns the tangent of an angle (in radians)	float or cell reference ( <> k*π/2)	1	float
TANH(num)	Returns the hyperbolic tangent of a number	float or cell reference	1	float
Statistical functions
AVEDEV(num1 [, num2, ...] )	Average value of absolute deviations of data from their mean.	float or cell reference	any	float
AVERAGE(num1 [, num2, ...] )	Average value of a series of numbers	float or cell reference	any	float
COUNT(value1 [, value2, ...] )	Counts cells and arguments containing numbers	any	any	integer
COUNTA(value1 [, value2, ...] )	Counts the number of non-empty cells and arguments	any	any	integer
COUNTBLANK(range)	Counts the number of empty cells in a range	any	any	integer
MAX(num1 [, num2, ...] )	Returns the largest value from the numbers provided	float or cell reference	any	float
MIN(num1 [, num2, ...] )	Returns the smallest value from the numbers provided	float or cell reference	any	float
PRODUCT(num1 [, num2, ...] )	Calculates the product of the numbers provided	float or cell reference	any	float
STDEV(num1 [, num2, ...] )	Returns the standard deviation of a population based on a ample of numbers	float or cell reference	any	float
STDEVP(num1 [, num2, ...] )	Returns the standard deviation of a population based on an entire population	float or cell reference	any	float
SUM(num1 [, num2, ...] )	Calculates the sum of the numbers provided	float or cell reference	any	float
SUMSQ(num1 [, num2, ...] )	Returns the sum of the squares of a series of numbers	float or cell reference	any	float
VAR(num1 [, num2, ...] )	Returns the variance of a population based on a ample of numbers	float or cell reference	any	float
VARP(num1 [, num2, ...] )	Returns the variance of a population based on an entire population	float or cell reference	any	float
Date/time functions
DATE(year, month, day)	Calculates a serial date number from year, month and day	integer or cell reference	3	date/time
String functions
CHAR(ascii_value)	Returns the character based on its ASCII value	integer	1	string
Logical functions
AND(condition1 [, condition2, ...])	Calculates the logical AND of several boolean values	boolean	any	boolean
OR(condition1 [, condition2, ...])	Calculates the logical OR of several boolean values	boolean	any	boolean
Info functions
ISBLANK(value)	Checks for blank or null values.	any	boolean	boolean