FPSpreadsheet: List of formulas
From Lazarus wiki
Jump to navigationJump to search
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 |
