MathPoint includes over 200 functions covering basic math, powers and logs, trig, calculus, tables and matrices, date math, programmer math, finance and more. To access these function select ∆ on the keypad or manually type them in with the keypad.
Each function is documented inline. This reference defines which functions are in each category by name and symbol. Also, addition (+), subtraction (-), multiplication (*) and division (/) are only available on the keypad.
Reciprocal: 1/
Power: ^
Square: ^2
Cube: ^3
Inverse: ^-1
Square Root: sqrt(
Cubed Root: cbrt(
Root: root(
Natural Log: ln(
Logarithm: log(
Exponential: exp(
Antilogarithm: alog(
Ceiling: ceil(
Floor: floor(
Integer Part: ipart(
Fractional Part: fpart(
Absolute Value: abs(
Modulo: mod(
Greatest Common Divisor: gcd(
Least Common Multiple: lcm(
Polynomial: poly(
Degrees to DMS: degs(
DMS to Degrees: dms(
Sigma: sigma(
Sequence: seq(
To Boolean: toBool(
To Integer: toInt(
To Real: toReal(
Fraction Separator: /
Feet Indicator: '
Table Indicator: { }
Matrix Indicator: [ ]
Complex Rectangular Format: (;)
Complex Polar Format: (;@)
Real Number Variable Setting: #
Engineering Notation Variable Setting: #E
Scientific Notation Variable Setting: #S
Fraction Variable Setting: #FR
Feet-Inch Variable Setting: #FT
Complex Auto Variable Setting: #C
Complex Rectangular Variable Setting: #CR
Complex Polar Variable Setting: #CP
Binary Variable Setting: #b
Octal Variable Setting: #o
Decimal Variable Setting: #d
Hexadecimal Variable Setting: #h
Cosine: cos(
Tangent: tan(
Arc-Sine: asin(
Arc-Cosine: acos(
Arc-Tangent: atan(
Hyperbolic Sine: sinh(
Hyperbolic Cosine: cosh(
Hyperbolic Tangent: tanh(
Hyperbolic Arc-Sine: asinh(
Hyperbolic Arc-Cosine: acosh(
Hyperbolic Arc-Tangent: atanh(
Secant: sec(
Cosecant: csc(
Cotangent: cot(
Degrees to Radians: radians(
Radians to Degrees: degrees(
Is Degrees?: isDegrees(
PI: pi
Choose: choose(
And: &&
Or: ||
Exclusive Or: ##
Not: !
Equals: ==
Less Than: <
Less Than or Equal To: <=
Greater Than: >
Greater Than or Equal To: >=
Not Equal: <> or !=
Sign: sign(
Octal: _o
Decimal: _d
Hexadecimal: _h
Bitwise And: &
Bitwise Or: |
Bitwise Exclusive Or: #
Bitwise Not: ~
Shift Left: <<
Shift Right: >>
Binary Variable Setting: #b
Octal Variable Setting: #o
Decimal Variable Setting: #d
Hexadecimal Variable Setting: #h
Complex Polar Format: (;@)
Conjugate: conj(
Imaginary Portion: imag(
Real Portion: real(
Theta: theta(
To Rectangular: toRect(
To Polar: toPolar(
Complex Auto Variable Setting: #C
Complex Rectangular Variable Setting: #CR
Complex Polar Variable Setting: #CP
Matrix Indicator: [ ]
Inverse: ^-1
Determinant: det(
Row-Echelon Form: ref(
Reduced Row Echelon Form: rref(
Transpose: trans(
Identity: identity(
Cumulative Sum: cumSum(
Frobenius Norm: norm(
Row Norm: rNorm(
Column Norm: cNorm(
Condition: cond(
Cross Product: cross(
Dot Product: dot(
Minimum: min(
Maximum: max(
Row Swap: rowSwap(
Row Addition: rowA(
Row Multiplication: rowM(
Row Multiply & Add: rowMA(
Product: prod(
Fill: fill(
Augment: augment(
Append: append(
Sublist: subList(
Redimension: redim(
Dimension: dim(
Number of Columns: numCols(
Number of Rows: numRows(
Get Item: getItem(
Get Row: getRow(
Get Column: getCol(
Sort Ascending: sortA(
Sort Descending: sortD(
To Table: toTable(
To Matrix: toMatrix(
Combination: comb(
Permutation: perm(
Random Number: rand(
Random Integer: randInt(
Random Table: randT(
Random Table of Integers: randTInt(
Count: count(
Summation: sumCol(
Summation Squared: sumCol2(
Sum of XY: sumXY(
Mean: mean(
Minimum: minCol(
First Quartile: quartile1(
Median: median(
Third Quartile: quartile3(
Maximum: maxCol(
Range: range(
Standard Deviation [Sample]: stdDev(
Standard Deviation [Population]: stdDevP(
Variance [Sample]: var(
Variance [Population]: varP(
Y-Intercept: regA(
Slope: regB(
Correlation Coefficient: regCoef(
Coefficient of Determination: regDet(
Predictive X: predX(
Predictive Y: predY(
Inverse Cumulative Normal Distribution: invNorm(
Second Derivative: nDeriv2(
Integral: fnInt(
Function Maximum: fMax(
Function Minimum: fMin(
Future Value: tvmfv(
Payment: tvmpmt(
Interest Rate: tvmi(
Periods: tvmn(
Amortization End Balance: amEndBal(
Amortization Interest Paid: amSumInt(
Amortization Principal Paid: amSumPrn(
Single Payment Present Value: sppv(
Single Payment Future Value: spfv(
Uniform Series Present Value: uspv(
Uniform Series Future Value: usfv(
Effective Interest rate: intEff(
Nominal Interest Rate: intNom(
Count [Cash Flows]: cfoCount(
Net Present Value: cfoNPV(
Internal Rate of Return: cfoIRR(
Net Future Value: cfoNFV(
Net Uniform Series: cfoNUS(
Modified Internal Rate of Return: cfoMIRR(
Payback: cfoPbk(
Profitability Index: cfoProf(
Total [Cash Flows]: cfoTot(
Bond Accumulated Interest: bondA(
Bond Price: bondP(
Bond Yield: bondY(
Straight Line Book Value: depSLBV(
Straight Line Depreciation Amount: depSLDA(
Straight Line Depreciation Value: depSLDV(
Declining Balance Book Value: depDBBV(
Declining Balance Depreciation Amount: depDBDA(
Declining Balance Depreciation Value: depDBDV(
Declining Balance Crossover Book Value: depDBSLBV(
Declining Balance Crossover Depreciation Amount: depDBSLDA(
Declining Balance Crossover Depreciation Value: depDBSLDV(
Sum of Year's Digits Book Value: depSOYDBV(
Sum of Year's Digits Depreciation Amount: depSOYDDA(
Sum of Year's Digits Depreciation Value: depSOYDDV(
Days Between Dates: ddays(
Adjust Date: adjdate(
Weekday: wkday(
Time in Decimal Format: hrs(
Time in HMS Format: hms(
Assignment Variable Notation/Full Precision: ::
Input Variable Notation: <:
Output Variable Notation: :>
Output Variable Notation/Full Precision: ::>
Comment Block: /* */
Comment Line: //
Replace: \\
Retain: ()
Bracketing: [:]
Boundaries: /# #/
Each function is documented inline. This reference defines which functions are in each category by name and symbol. Also, addition (+), subtraction (-), multiplication (*) and division (/) are only available on the keypad.
Math
Percent: %Reciprocal: 1/
Power: ^
Square: ^2
Cube: ^3
Inverse: ^-1
Square Root: sqrt(
Cubed Root: cbrt(
Root: root(
Natural Log: ln(
Logarithm: log(
Exponential: exp(
Antilogarithm: alog(
Number
Round: round(Ceiling: ceil(
Floor: floor(
Integer Part: ipart(
Fractional Part: fpart(
Absolute Value: abs(
Modulo: mod(
Greatest Common Divisor: gcd(
Least Common Multiple: lcm(
Polynomial: poly(
Degrees to DMS: degs(
DMS to Degrees: dms(
Sigma: sigma(
Sequence: seq(
To Boolean: toBool(
To Integer: toInt(
To Real: toReal(
Formatting
Whole Separator: &Fraction Separator: /
Feet Indicator: '
Table Indicator: { }
Matrix Indicator: [ ]
Complex Rectangular Format: (;)
Complex Polar Format: (;@)
Real Number Variable Setting: #
Engineering Notation Variable Setting: #E
Scientific Notation Variable Setting: #S
Fraction Variable Setting: #FR
Feet-Inch Variable Setting: #FT
Complex Auto Variable Setting: #C
Complex Rectangular Variable Setting: #CR
Complex Polar Variable Setting: #CP
Binary Variable Setting: #b
Octal Variable Setting: #o
Decimal Variable Setting: #d
Hexadecimal Variable Setting: #h
Trig
Sine: sin(Cosine: cos(
Tangent: tan(
Arc-Sine: asin(
Arc-Cosine: acos(
Arc-Tangent: atan(
Hyperbolic Sine: sinh(
Hyperbolic Cosine: cosh(
Hyperbolic Tangent: tanh(
Hyperbolic Arc-Sine: asinh(
Hyperbolic Arc-Cosine: acosh(
Hyperbolic Arc-Tangent: atanh(
Secant: sec(
Cosecant: csc(
Cotangent: cot(
Degrees to Radians: radians(
Radians to Degrees: degrees(
Is Degrees?: isDegrees(
PI: pi
Logic
If: if(Choose: choose(
And: &&
Or: ||
Exclusive Or: ##
Not: !
Equals: ==
Less Than: <
Less Than or Equal To: <=
Greater Than: >
Greater Than or Equal To: >=
Not Equal: <> or !=
Sign: sign(
Developer
Binary: _bOctal: _o
Decimal: _d
Hexadecimal: _h
Bitwise And: &
Bitwise Or: |
Bitwise Exclusive Or: #
Bitwise Not: ~
Shift Left: <<
Shift Right: >>
Binary Variable Setting: #b
Octal Variable Setting: #o
Decimal Variable Setting: #d
Hexadecimal Variable Setting: #h
Complex
Complex Rectangular Format: (;)Complex Polar Format: (;@)
Conjugate: conj(
Imaginary Portion: imag(
Real Portion: real(
Theta: theta(
To Rectangular: toRect(
To Polar: toPolar(
Complex Auto Variable Setting: #C
Complex Rectangular Variable Setting: #CR
Complex Polar Variable Setting: #CP
Matrix/Table
Table Indicator: { }Matrix Indicator: [ ]
Inverse: ^-1
Determinant: det(
Row-Echelon Form: ref(
Reduced Row Echelon Form: rref(
Transpose: trans(
Identity: identity(
Cumulative Sum: cumSum(
Frobenius Norm: norm(
Row Norm: rNorm(
Column Norm: cNorm(
Condition: cond(
Cross Product: cross(
Dot Product: dot(
Minimum: min(
Maximum: max(
Row Swap: rowSwap(
Row Addition: rowA(
Row Multiplication: rowM(
Row Multiply & Add: rowMA(
Product: prod(
Fill: fill(
Augment: augment(
Append: append(
Sublist: subList(
Redimension: redim(
Dimension: dim(
Number of Columns: numCols(
Number of Rows: numRows(
Get Item: getItem(
Get Row: getRow(
Get Column: getCol(
Sort Ascending: sortA(
Sort Descending: sortD(
To Table: toTable(
To Matrix: toMatrix(
Probability
Factorial: fact(Combination: comb(
Permutation: perm(
Random Number: rand(
Random Integer: randInt(
Random Table: randT(
Random Table of Integers: randTInt(
Statistics
Table Indicator: { }Count: count(
Summation: sumCol(
Summation Squared: sumCol2(
Sum of XY: sumXY(
Mean: mean(
Minimum: minCol(
First Quartile: quartile1(
Median: median(
Third Quartile: quartile3(
Maximum: maxCol(
Range: range(
Standard Deviation [Sample]: stdDev(
Standard Deviation [Population]: stdDevP(
Variance [Sample]: var(
Variance [Population]: varP(
Y-Intercept: regA(
Slope: regB(
Correlation Coefficient: regCoef(
Coefficient of Determination: regDet(
Predictive X: predX(
Predictive Y: predY(
Distribution
Cumulative Standard Normal Distribution: normSDist(Inverse Cumulative Normal Distribution: invNorm(
Calculus
Derivative: nDeriv(Second Derivative: nDeriv2(
Integral: fnInt(
Function Maximum: fMax(
Function Minimum: fMin(
Finance
Present Value: tvmpv(Future Value: tvmfv(
Payment: tvmpmt(
Interest Rate: tvmi(
Periods: tvmn(
Amortization End Balance: amEndBal(
Amortization Interest Paid: amSumInt(
Amortization Principal Paid: amSumPrn(
Single Payment Present Value: sppv(
Single Payment Future Value: spfv(
Uniform Series Present Value: uspv(
Uniform Series Future Value: usfv(
Effective Interest rate: intEff(
Nominal Interest Rate: intNom(
Count [Cash Flows]: cfoCount(
Net Present Value: cfoNPV(
Internal Rate of Return: cfoIRR(
Net Future Value: cfoNFV(
Net Uniform Series: cfoNUS(
Modified Internal Rate of Return: cfoMIRR(
Payback: cfoPbk(
Profitability Index: cfoProf(
Total [Cash Flows]: cfoTot(
Bond Accumulated Interest: bondA(
Bond Price: bondP(
Bond Yield: bondY(
Straight Line Book Value: depSLBV(
Straight Line Depreciation Amount: depSLDA(
Straight Line Depreciation Value: depSLDV(
Declining Balance Book Value: depDBBV(
Declining Balance Depreciation Amount: depDBDA(
Declining Balance Depreciation Value: depDBDV(
Declining Balance Crossover Book Value: depDBSLBV(
Declining Balance Crossover Depreciation Amount: depDBSLDA(
Declining Balance Crossover Depreciation Value: depDBSLDV(
Sum of Year's Digits Book Value: depSOYDBV(
Sum of Year's Digits Depreciation Amount: depSOYDDA(
Sum of Year's Digits Depreciation Value: depSOYDDV(
Dates
Today: today()Days Between Dates: ddays(
Adjust Date: adjdate(
Weekday: wkday(
Time in Decimal Format: hrs(
Time in HMS Format: hms(
Extras
Assignment Variable Notation: :Assignment Variable Notation/Full Precision: ::
Input Variable Notation: <:
Output Variable Notation: :>
Output Variable Notation/Full Precision: ::>
Comment Block: /* */
Comment Line: //
Replace: \\
Retain: ()
Bracketing: [:]
Boundaries: /# #/