Reference > Functions

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.

ABS	Absolute value
ACOS	Arccosine (inverse cosine)
ACOSH	Inverse hyperbolic cosine
AND	Bitwise AND
ASIN	Arcsine (inverse sine)
ASINH	Inverse hyperbolic sine
ATAN	Arctangent (inverse tangent)
ATAN2	Arctangent
ATANH	Inverse hyperbolic tangent
BESSELJ	Bessel function of the first kind
BESSELY	Bessel function of the second kind
CDF	Cumulative distribution function
CEIL	Rounds a number up
COS	Cosine
COSH	Hyperbolic cosine
DATE	Excel 1900 date system serial number that represents the input year, month, and day
DAY	Day of the month from a date (1-31)
ERF	Error function
ERFC	Complementary error function
EXP	Exponent (inverse of log)
FACT	Factorial
FLOOR	Rounds a number down
FPOWER	Raises a number to a fractional power
GCD	Greatest common divisor
LCM	Least common multiple
LOG	Natural (base-e) logarithm
LOG10	Base-10 logarithm
MAX	Maximum of two values
MIN	Minimum of two values
MOD	Remainder after division
MONTH	from a date (1=January)
MROUND	Rounds a number to a specified multiple
NORMDIST	Normal distribution
NORMDISTCDF	Cumulative distribution function for the specified mean and standard deviation.
NORMINV	Inverse of the cumulative distribution function
NORMRAND	Normally-distributed random number for a distribution with a specified mean and standard deviation.
NOT	Bitwise NOT
OR	Bitwise OR
PMT	Calculates the payment for a loan based on constant payments and a constant interest rate.
RANDBETWEEN	number between specified limits
ROUND	Rounds a number to a specified number of digits
RND	Random whole number
SIGN	of a number
SIN	Sine
SINH	Hyperbolic sine
SQRT	Positive square root
SUM	Add result of expression to previous result (Taylor series, for example)
TAN	Tangent
TANH	Hyperbolic tangent
WEEKDAY	Day of the week from a date (1=Sunday, 7=Saturday)
WEEKNUM	Number of weeks since start of year for a given date
XOR	Bitwise XOR
YEAR	Year from a date

Page url: https://www.dplot.com/help/index.htm?functions.htm