This table provides a brief description of the functions available in the Y=f(X) command and similar commands. For a more detailed description of each function, click on the function name. Function names are not case specific.
For functions that take multiple arguments, the arguments must be separated by a comma, or, if the decimal symbol is set to a comma, by a semicolon.
Please note: All dates taken as input arguments to these functions are Excel 1900 date system serial numbers, the internal date format used throughout DPlot.
Absolute value |
|
Arccosine (inverse cosine) |
|
Inverse hyperbolic cosine |
|
Bitwise AND |
|
Arcsine (inverse sine) |
|
Inverse hyperbolic sine |
|
Arctangent (inverse tangent) |
|
Arctangent |
|
Inverse hyperbolic tangent |
|
Bessel function of the first kind |
|
Bessel function of the second kind |
|
Cumulative distribution function |
|
Rounds a number up |
|
Cosine |
|
Hyperbolic cosine |
|
Excel 1900 date system serial number that represents the input year, month, and day |
|
Day of the month from a date (1-31) |
|
Error function |
|
Complementary error function |
|
Exponent (inverse of log) |
|
Factorial |
|
Rounds a number down |
|
Raises a number to a fractional power |
|
Greatest common divisor |
|
Least common multiple |
|
Natural (base-e) logarithm |
|
Base-10 logarithm |
|
Maximum of two values |
|
Minimum of two values |
|
Remainder after division |
|
from a date (1=January) |
|
Rounds a number to a specified multiple |
|
Normal distribution |
|
Cumulative distribution function for the specified mean and standard deviation. |
|
Inverse of the cumulative distribution function |
|
Normally-distributed random number for a distribution with a specified mean and standard deviation. |
|
Bitwise NOT |
|
Bitwise OR |
|
Calculates the payment for a loan based on constant payments and a constant interest rate. |
|
number between specified limits |
|
Rounds a number to a specified number of digits |
|
Random whole number |
|
of a number |
|
Sine |
|
Hyperbolic sine |
|
Positive square root |
|
Add result of expression to previous result (Taylor series, for example) |
|
Tangent |
|
Hyperbolic tangent |
|
Day of the week from a date (1=Sunday, 7=Saturday) |
|
Number of weeks since start of year for a given date |
|
Bitwise XOR |
|
Year from a date |
Page url:
https://www.dplot.com/help/index.htm?functions.htm