ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
Original Table
New Columns
2
3
#OperatorargsReturns (old)Type of function (old)ReturnsType of FunctionWikipedia Linkhttps://dlmf.nist.gov/idx/
4
1**ABS**1 1abs (A)ArithmeticAbsolute value of AArithmetichttps://en.wikipedia.org/wiki/Absolute_value
5
2**ACOS**1 1acos (A)TrigonometricInverse cosine (result in radians)Calculushttps://en.wikipedia.org/wiki/Inverse_trigonometric_functions
6
3**ACOSD**1 1acosd (A)TrigonometricInverse cosine (result in degrees)Calculushttps://en.wikipedia.org/wiki/Inverse_trigonometric_functions
7
4**ACOSH**1 1acosh (A)TrigonometricInverse hyperbolic cosineCalculushttps://en.wikipedia.org/wiki/Hyperbolic_functions
8
7**ACOT**1 1acot (A)TrigonometricInverse of cotangent (result in radians)Calculushttps://en.wikipedia.org/wiki/Inverse_trigonometric_functions
9
8**ACOTD**1 1acotd (A)TrigonometricInverse of cotangent (result in degrees)Calculushttps://en.wikipedia.org/wiki/Inverse_trigonometric_functions
10
5**ACSC**1 1acsc (A)TrigonometricInverse of cosecant (result in radians)Calculushttps://en.wikipedia.org/wiki/Inverse_trigonometric_functions
11
6**ACSCD**1 1acscd (A)TrigonometricInverse of cosecant (result in degrees)Calculushttps://en.wikipedia.org/wiki/Inverse_trigonometric_functions
12
9**ADD**2 1A + BArithmeticA + B (addition)Arithmetic
13
10**AND**2 1B if A == NaN, else ALogicalB if A equals NaN, else ALogic
14
11**ASEC**1 1asec (A)TrigonometricInverse of secant (result in radians)Calculushttps://en.wikipedia.org/wiki/Inverse_trigonometric_functions
15
12**ASECD**1 1asecd (A)TrigonometricInverse of secant (result in degrees)Calculushttps://en.wikipedia.org/wiki/Inverse_trigonometric_functions
16
13**ASIN**1 1asin (A)TrigonometricInverse of sine (result in radians)Calculushttps://en.wikipedia.org/wiki/Inverse_trigonometric_functions
17
14**ASIND**1 1asind (A)TrigonometricInverse of sine (result in degrees)Calculushttps://en.wikipedia.org/wiki/Inverse_trigonometric_functions
18
15**ASINH**1 1asinh (A)TrigonometricInverse of hyperbolic sineCalculushttps://en.wikipedia.org/wiki/Hyperbolic_functions
19
16**ATAN**1 1atan (A)TrigonometricInverse of tangent (result in radians)Calculushttps://en.wikipedia.org/wiki/Inverse_trigonometric_functions
20
18**ATAN2**2 1atan2 (A, B)TrigonometricInverse of tangent of A/B (result in radians)Calculushttps://en.wikipedia.org/wiki/Atan2
21
19**ATAN2D**2 1atan2d (A, B)TrigonometricInverse of tangent of A/B (result in degrees)Calculushttps://en.wikipedia.org/wiki/Atan2
22
17**ATAND**1 1atand (A)TrigonometricInverse of tangent (result in degrees)Calculushttps://en.wikipedia.org/wiki/Inverse_trigonometric_functions
23
20**ATANH**1 1atanh (A)TrigonometricInverse of hyperbolic tangentCalculushttps://en.wikipedia.org/wiki/Inverse_trigonometric_functions
24
21**BCDF**3 1Binomial cumulative distribution function for p = A, n = B, and x = CProbability distribution
Binomial cumulative distribution function for p = A, n = B, and x = C
Probabilityhttps://en.wikipedia.org/wiki/Binomial_distribution
25
23**BEI**1 1Kelvin function bei (A)KelvinKelvin function bei (A)Special Functions
26
24**BER**1 1Kelvin function ber (A)KelvinKelvin function ber (A)Special Functions
27
25**BITAND**2 1A & B (bitwise AND operator)Computer programmingA & B (bitwise AND operator)Logichttps://en.wikipedia.org/wiki/Bitwise_operation#AND
28
26**BITLEFT**2 1A << B (bitwise left-shift operator)Computer programmingA << B (bitwise left-shift operator)Arithmetichttps://en.wikipedia.org/wiki/Bitwise_operation#Arithmetic_shift
29
27**BITNOT**1 1~A (bitwise NOT operator, i.e., return two’s complement)Computer programming~A (bitwise NOT operator, i.e., return two’s complement)Logichttps://en.wikipedia.org/wiki/Bitwise_operation#NOT
30
28**BITOR**2 1A | B (bitwise OR operator)Computer programmingA | B (bitwise OR operator)Logichttps://en.wikipedia.org/wiki/Bitwise_operation#OR
31
29**BITRIGHT**2 1A >> B (bitwise right-shift operator)Computer programmingA >> B (bitwise right-shift operator)Arithmetichttps://en.wikipedia.org/wiki/Bitwise_operation#Arithmetic_shift
32
30**BITTEST**2 11 if bit B of A is set, else 0 (bitwise TEST operator)Computer programming1 if bit B of A is set, else 0 (bitwise TEST operator)Logic
33
31**BITXOR**2 1A ^ B (bitwise XOR operator)Computer programmingA ^ B (bitwise XOR operator)Logichttps://en.wikipedia.org/wiki/Bitwise_operation#XOR
34
22**BPDF**3 1Binomial probability density function for p = A, n = B, and x = CProbability distribution
Binomial probability density function for p = A, n = B, and x = C
Probabilityhttps://en.wikipedia.org/wiki/Binomial_distribution
35
32**CEIL**1 1ceil (A) (smallest integer >= A)Logicalceil (A) (smallest integer >= A)Logichttps://en.wikipedia.org/wiki/Floor_and_ceiling_functions
36
34**CHICDF**2 1Chi-squared cumulative distribution function for chi2 = A and nu = BProbability distribution
Chi-squared cumulative distribution function for chi2 = A and nu = B
Probability
37
33**CHICRIT**2 1Chi-squared distribution critical value for alpha = A and nu = BProbability distribution
Chi-squared distribution critical value for alpha = A and nu = B
Probability
38
35**CHIPDF**2 1Chi-squared probability density function for chi2 = A and nu = BProbability distribution
Chi-squared probability density function for chi2 = A and nu = B
Probability
39
36**COL**1 1Places column A on the stackStack operationPlaces column A on the stackSpecial Operators
40
37**COMB**2 1Combinations n_C_r, with n = A and r = BCombinatoricsCombinations n_C_r, with n = A and r = BProbability
41
38
**CORRCOEFF**
2 1Correlation coefficient r(A, B)Statistical / ProbabilisticCorrelation coefficient r(A, B)Probability
42
39**COS**1 1cos (A) (A in radians)TrigonometricCosine of A (A in radians)Calculus
https://en.wikipedia.org/wiki/Trigonometry#Trigonometric_ratios
43
40**COSD**1 1cos (A) (A in degrees)TrigonometricCosine of A (A in degrees)Calculus
https://en.wikipedia.org/wiki/Trigonometry#Trigonometric_ratios
44
41**COSH**1 1cosh (A)TrigonometricHyperbolic cosine of ACalculushttps://en.wikipedia.org/wiki/Hyperbolic_functions
45
42**COT**1 1cot (A) (A in radians)TrigonometricCotangent of A (A in radians)Calculus
https://en.wikipedia.org/wiki/Trigonometry#Trigonometric_ratios
46
43**COTD**1 1cot (A) (A in degrees)TrigonometricCotangent of A (A in degrees)Calculus
https://en.wikipedia.org/wiki/Trigonometry#Trigonometric_ratios
47
44**CSC**1 1csc (A) (A in radians)TrigonometricCosecant of A (A in radians)Calculus
https://en.wikipedia.org/wiki/Trigonometry#Trigonometric_ratios
48
45**CSCD**1 1csc (A) (A in degrees)TrigonometricCosecant of A (A in degrees)Calculus
https://en.wikipedia.org/wiki/Trigonometry#Trigonometric_ratios
49
47**D2DT2**1 1d^2(A)/dt^2 2nd derivativeCalculusd^2(A)/dt^2 2nd derivativeCalculus
50
48**D2R**1 1Converts degrees to radiansConvertionConverts degrees to radiansSpecial Operators
51
46**DDT**1 1d(A)/dt Central 1st derivativeCalculusd(A)/dt Central 1st derivativeCalculus
52
49**DEG2KM**1 1Converts spherical degrees to kilometersConvertionConverts spherical degrees to kilometersSpecial Operators
53
50**DENAN**2 1Replace NaNs in A with values from BLogicalReplace NaNs in A with values from BLogic
54
52**DIFF**1 1Forward difference between adjacent elements of A (A[1]-A[0], A[2]-A[1], …, NaN)Arithmetic
Forward difference between adjacent elements of A (A[1]-A[0], A[2]-A[1], …, NaN)
Arithmetic
55
51**DILOG**1 1dilog (A)particle physics ?Dilogarithm (Spence's) functionSpecial Functions
56
53**DIV**2 1A / BArithmeticA / B (division)Arithmetic
57
54**DUP**1 2Places duplicate of A on the stackStack operationPlaces duplicate of A on the stackSpecial Operators
58
55**ECDF**2 1Exponential cumulative distribution function for x = A and lambda = BProbability distribution
Exponential cumulative distribution function for x = A and lambda = B
Probability
59
56**ECRIT**2 1Exponential distribution critical value for alpha = A and lambda = BProbability distribution
Exponential distribution critical value for alpha = A and lambda = B
Probability
60
57**EPDF**2 1Exponential probability density function for x = A and lambda = BProbability distribution
Exponential probability density function for x = A and lambda = B
Probability
61
61**EQ**2 11 if A == B, else 0Logical1 if A equals B, else 0Logic
62
58**ERF**1 1Error function erf (A)Statistical / ProbabilisticError function erf (A)Probability
63
59**ERFC**1 1Complementary Error function erfc (A)Statistical / ProbabilisticComplementary Error function erfc (A)Probability
64
60**ERFINV**1 1Inverse error function of AStatistical / ProbabilisticInverse error function of AProbability
65
62**EXCH**2 2Exchanges A and B on the stackStack operationExchanges A and B on the stackSpecial Operators
66
63**EXP**1 1exp (A)ArithmeticE raised to a power.Arithmetic
67
64**FACT**1 1A! (A factorial)ArithmeticA! (A factorial)Arithmetichttps://en.wikipedia.org/wiki/Factorial
68
65**FCDF**3 1F cumulative distribution function for F = A, nu1 = B, and nu2 = CProbability distribution
F cumulative distribution function for F = A, nu1 = B, and nu2 = C
Probability
69
66**FCRIT**3 1F distribution critical value for alpha = A, nu1 = B, and nu2 = CProbability distribution
F distribution critical value for alpha = A, nu1 = B, and nu2 = C
Probability
70
67**FLIPUD**1 1Reverse order of each columnStack operation ?Reverse order of each columnSpecial Operators
71
68**FLOOR**1 1floor (A) (greatest integer <= A)Logicalgreatest integer less than or equal to ALogichttps://en.wikipedia.org/wiki/Floor_and_ceiling_functions
72
69**FMOD**2 1A % B (remainder after truncated division)ArithmeticA % B (remainder after truncated division)Arithmetichttps://en.wikipedia.org/wiki/Remainder
73
70**FPDF**3 1F probability density function for F = A, nu1 = B, and nu2 = CProbability distributionF probability density function for F = A, nu1 = B, and nu2 = CProbability
74
71**GE**2 11 if A >= B, else 0Logical1 if A >= (greater or equal than) B, else 0Logic
75
72**GT**2 11 if A > B, else 0Logical1 if A > (greater than) B, else 0Logic
76
73**HSV2LAB**3 3Convert h,s,v triplets to l,a,b triplets, with h = A (0-360), s = B and v = C (0-1)Convertion
Convert h,s,v triplets to l,a,b triplets, with h = A (0-360), s = B and v = C (0-1)
Special Operators
77
74**HSV2RGB**3 3Convert h,s,v triplets to r,g,b triplets, with h = A (0-360), s = B and v = C (0-1)Convertion
Convert h,s,v triplets to r,g,b triplets, with h = A (0-360), s = B and v = C (0-1)
Special Operators
78
75**HSV2XYZ**3 3Convert h,s,v triplets to x,t,z triplets, with h = A (0-360), s = B and v = C (0-1)Convertion
Convert h,s,v triplets to x,t,z triplets, with h = A (0-360), s = B and v = C (0-1)
Special Operators
79
76**HYPOT**2 1hypot (A, B) = sqrt (A*A + B*B)Trigonometric
Hypotenuse of a right triangle of sides A and B (= sqrt (A^2 + B^2))
Calculushttps://en.wikipedia.org/wiki/Hypotenuse
80
77**I0**1 1Modified Bessel function of A (1st kind, order 0)BesselModified Bessel function of A (1st kind, order 0)Special Functions
81
78**I1**1 1Modified Bessel function of A (1st kind, order 1)BesselModified Bessel function of A (1st kind, order 1)Special Functions
82
79**IFELSE**3 1B if A != 0, else CLogicalB if A is not equal to 0, else CLogic
83
80**IN**2 1Modified Bessel function of A (1st kind, order B)BesselModified Bessel function of A (1st kind, order B)Special Functions
84
81**INRANGE**3 11 if B <= A <= C, else 0Logical1 if B <= A <= C, else 0Logic
85
82**INT**1 1Numerically integrate ACalculusNumerically integrate ACalculus
86
83**INV**1 11 / AArithmeticInvert (1/A)Arithmetic
87
84**ISFINITE**1 11 if A is finite, else 0Logical1 if A is finite, else 0Logic
88
85**ISNAN**1 11 if A == NaN, else 0Logical1 if A equals NaN, else 0Logic
89
86**J0**1 1Bessel function of A (1st kind, order 0)BesselBessel function of A (1st kind, order 0)Special Functions
90
87**J1**1 1Bessel function of A (1st kind, order 1)BesselBessel function of A (1st kind, order 1)Special Functions
91
88**JN**2 1Bessel function of A (1st kind, order B)BesselBessel function of A (1st kind, order B)Special Functions
92
89**K0**1 1Modified Kelvin function of A (2nd kind, order 0)KelvinModified Kelvin function of A (2nd kind, order 0)Special Functions
93
90**K1**1 1Modified Bessel function of A (2nd kind, order 1)BesselModified Bessel function of A (2nd kind, order 1)Special Functions
94
93**KEI**1 1Kelvin function kei (A)KelvinKelvin function kei (A)Special Functions
95
94**KER**1 1Kelvin function ker (A)KelvinKelvin function ker (A)Special Functions
96
91**KM2DEG**1 1Converts kilometers to spherical degreesConvertionConverts kilometers to spherical degreesSpecial Operators
97
92**KN**2 1Modified Bessel function of A (2nd kind, order B)BesselModified Bessel function of A (2nd kind, order B)Special Functions
98
95**KURT**1 1Kurtosis of AStatisticalKurtosis of AProbability
99
96**LAB2HSV**3 3Convert l,a,b triplets to h,s,v tripletsConvertionConvert l,a,b triplets to h,s,v tripletsSpecial Operators
100
97**LAB2RGB**3 3Convert l,a,b triplets to r,g,b tripletsConvertionConvert l,a,b triplets to r,g,b tripletsSpecial Operators