Group Math

Minus operator (unary): reverses sign of operand (multiplies operand by -1). Minus operator (binary): numeric subtraction or string concatenation.

<nValue1> - <nValue2> // subtraction <dDate1> - <dDate2> // subtraction <dDate> - <nValue> // subtraction <cString1> - <cString2> // string concatenation

Decrement operator (unary): subtracts one from a numeric or date value.

--<VarName> // Prefix decrementing <VarName>-- // Postfix decrementing

Modulus operator (binary): determines the remainder of a division.

<nValue1> % <nValue2>

Multiplication operator (binary): performs numeric multiplication.

<nValue1> * <nValue2>

Exponential operator (binary): exponentiation of a numeric value.

<nValue> ** <nExponent> // or <nValue> ^ <nExponent>

Division operator (binary): performs numeric division.

<nValue1> / <nValue2>

Plus operator (unary): defines the sign of numeric values. Plus operator (binary): numeric addition or string concatenation.

<nValue1> + <nValue2> // addition <dDate> + <nValue> // addition <nValue> + <dDate> // addition <cString1> + <cString2> // string concatenation

Increment operators (unary): increase numeric or date value by one.

++<VarName> // Prefix incrementing <VarName>++ // Postfix incrementing

Determines the absolute value of a numeric expression.

Abs( <nExpression> ) --> nPositive

Calculates the arc cosine.

Acos( <nCosine> ) --> nArcCosine

Calculates the arc sine.

Asin( <nSine> ) --> nArcSine

Calculates the arc tangent.

Atan( <nTangent> ) --> nArcTangent

Calculates the radiant of an angle from sine and cosine.

Atn2( <nSine>, <nCosine> ) --> nRadiant

Calculates the result of a bitwise AND operation.

BAnd( <nVa1>, <nVal2>, [<nVal3>,...] ) -> nBitwiseAnd

Calculates the result of a bitwise OR operation.

BOr( <nVa1>, <nVal2>, [<nVal3>,...] ) -> nBitwiseOr

Calculates the result of a bitwise XOR operation.

BXOr( <nVa1>, <nVal2>, [<nVal3>,...] ) -> nBitwiseXOr

Calculates the cosine for an angle.

Cos( <nRadiant> ) --> nCosine

Calculates the cotangent.

Cot( <nRadiant> ) --> nCotangent

Gives an inverted index key value for sorting in descending order.

Descend( <Expression> [,<lCompatible>] ) --> DescendValue

Converts an angle from degrees to radiant.

DtoR( <nDegree> ) --> nRadiant

Calculates the value of e to the power of x

Exp( <nExponent> ) --> nAntilogarithm

Calculates the factorial of a number.

Fact( <nNumber> ) --> nFactorial

Rounds a number to the next smaller integer.

Floor( <nNumber> ) --> nInteger

Calculates a Future Value.

Fv( <nPayment>, <nInterestRate>, <nNumberOfPayments> ) --> nFutureValue

Converts a numeric value to an integer numeric value.

Int( <nExpression> ) --> nInteger

Calculates the natural logarithm of a numeric value.

Log( <nExpression> ) --> nNaturalLog

Calculates the base 10 logarithm.

Log10( <nNumber> ) --> nLog10

Determines the larger of two numeric or two date values.

Max( <ndExpression1>, <ndExpression2> ) --> ndMax

Determines the smaller of two numeric or two date values.

Min( <ndExpression1>, <ndExpression2> ) --> ndMin

Determines the modulus of two numbers in the same manner as dBASE III PLUS.

Mod( <nDividend>, <nDivisor> ) --> nRest

Calculates a periodical payment for loans.

Payment( <nLoanedCapital>, <nInterestRate>, <nNumberOfPayments> ) --> nPayment

Calculates the number of payments for a loan at fixed interest rate and payments.

Periods( <nLoanedCapital>, <nPayment>, <nInterestRate> ) --> nNumberOfPayments

Returns Pi at maximum precision.

Pi() --> nPi

Calculates the Present value of a loan at fixed interest rate.

Pv( <nPayment>, <nInterestRate>, <nNumberOfPayments> ) --> nPresentValue

Calculates the interest rate for a loan.

Rate( <nLoanedCapital>, <nPayment>, <nNumberOfPayments> ) --> nInterestRate

Rounds a numeric value to a specific number of decimal places.

Round( <nValue>, <nDecimals>) --> nRoundedValue

Converts angles from radiant to degrees.

RtoD( <nRadiant> ) --> nDegree

Calculates the sine.

Sin( <nRadiant> ) --> nSine

Calculates square root of a positive number.

Sqrt( <nValue> ) --> nSquareRoot

Calculates the tangent.

Tan( <nRadiant> ) --> nTangent