﻿ Reference > Functions

 Functions JR Viewer    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