Difference between revisions of "FPSpreadsheet: List of formulas"
From Lazarus wiki
Jump to navigationJump to search (Initial version (incomplete)) |
m |
||
| Line 40: | Line 40: | ||
| <code>LOG10(number)</code> || calculates the base-10 logarithm of a number || float or cell reference (> 0) || 1 || float | | <code>LOG10(number)</code> || calculates the base-10 logarithm of a number || float or cell reference (> 0) || 1 || float | ||
|- | |- | ||
| − | | <code>PI()</code> || returns the mathematical constant pi (3.14159265358979) || none || 0 || float | + | | <code>PI()</code> || returns the mathematical constant π (3.14159265358979) || none || 0 || float |
|- | |- | ||
| <code>POWER(number, exponent)</code> || returns the result of a number raised to a given power || float or cell reference || 2 || float | | <code>POWER(number, exponent)</code> || returns the result of a number raised to a given power || float or cell reference || 2 || float | ||
| Line 56: | Line 56: | ||
| <code>SINH(number)</code> || returns the hyperbolic sine of a number || float or cell reference || 1 || float | | <code>SINH(number)</code> || returns the hyperbolic sine of a number || float or cell reference || 1 || float | ||
|- | |- | ||
| − | | <code>TAN(number)</code> || returns the tangent of an angle (in radians) || float or cell reference ( <> | + | | <code>TAN(number)</code> || returns the tangent of an angle (in radians) || float or cell reference ( <> k*π/2) || 1 || float |
|- | |- | ||
| <code>TANH(number)</code> || returns the hyperbolic tangent of a number || float or cell reference || 1 || float | | <code>TANH(number)</code> || returns the hyperbolic tangent of a number || float or cell reference || 1 || float | ||
|- | |- | ||
|} | |} | ||
Revision as of 00:44, 31 August 2014
This is a list of the formulas supported by FPSpreadsheet:
| Calling prototye | Meaning | Argument types | Argument count | Result type |
|---|---|---|---|---|
| Mathematical functions | ||||
ABS(number) |
returns the absolute value of a number | float or cell reference | 1 | float |
ACOS(number) |
returns the arccosine (in radians) of a number | float or cell reference (>= -1 and <= +1) | 1 | float |
ACOSH(number) |
returns the inverse hyperbolic cosine of a number | float or cell reference (>=1) | 1 | float |
ASIN(number) |
returns the arcsine (in radians) of a number | float or cell reference (>= -1 and <=+1) | 1 | float |
ASINH(number) |
returns the inverse hyperbolic sine of a number | float or cell reference | 1 | float |
ATAN(number) |
returns the arctangent (in radians) of a number | float or cell reference | 1 | float |
ATANH(number) |
returns the inverse hyperbolic tangent of a number | float or cell reference (> -1 and < +1) | 1 | float |
COS(number) |
returns the cosine of an angle (in radians) | float or cell reference | 1 | float |
COSH(number) |
returns the hyperbolic cosine of a number | float or cell reference | 1 | float |
DEGREES(number) |
converts an angle from radians to degrees | float or cell reference | 1 | float |
EXP(number) |
calculates the exponential function of a number | float or cell reference | 1 | float |
INT(number) |
returns the integer portion of a number (like "floor()") | float or cell reference | 1 | integer |
LN(number) |
calculates the natural logarithm of a number | float or cell reference (> 0) | 1 | float |
LOG(number [, 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(number) |
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(number, exponent) |
returns the result of a number raised to a given power | float or cell reference | 2 | float |
RADIANS(number) |
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(number, digits) |
returns a number rounded to a specified number of digits | float or cell reference | 2 | float |
SIGN(number) |
returns the sign of a number | float or cell reference | 1 | integer |
SIN(number) |
returns the sine of an angle (in radians) | float or cell reference | 1 | float |
SINH(number) |
returns the hyperbolic sine of a number | float or cell reference | 1 | float |
TAN(number) |
returns the tangent of an angle (in radians) | float or cell reference ( <> k*π/2) | 1 | float |
TANH(number) |
returns the hyperbolic tangent of a number | float or cell reference | 1 | float |
