Math |
Top Previous Next |
This function category includes anything related to basic mathematical operations.
| Function: | Abs |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Absolute value of nValue |
| Function: | ATan |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Arc Tangent (geometry function) |
| Function: | Ceiling |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Returns a value representing the smallest integer that is greater than or equal to nValue |
| Function: | Cos |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Cosine (geometry function) |
| Function: | Exp |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Exponential value (e ^ nValue) |
| Function: | Floor |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Returns a value representing the largest integer that is less than or equal to nValue |
| Function: | Int |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Truncates a number to an integer |
| Function: | Log |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Logarithm base e (math function) |
| Function: | Log10 |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Logarithm base 10 (math function) |
| Function: | LoopAvg |
| Result-type: | Numeric |
| Arguments: | nStart, nEnd, cPlaceholder, cQuotedExpression [, cQuotedCondition] |
| Description: | For each number from nStart to nEnd, executes the quoted expression (with the number replacing the placeholder) and returns the average value of all results. Optionally a condition can be specified so that the expression is only evaluated if the condition is met for a given number. |
| Function: | LoopMax |
| Result-type: | Numeric |
| Arguments: | nStart, nEnd, cPlaceholder, cQuotedExpression [, cQuotedCondition] |
| Description: | For each number from nStart to nEnd, executes the quoted expression (with the number replacing the placeholder) and returns the maximum value of all results. Optionally a condition can be specified so that the expression is only evaluated if the condition is met for a given number. |
| Function: | LoopMin |
| Result-type: | Numeric |
| Arguments: | nStart, nEnd, cPlaceholder, cQuotedExpression [, cQuotedCondition] |
| Description: | For each number from nStart to nEnd, executes the quoted expression (with the number replacing the placeholder) and returns the minimum value of all results. Optionally a condition can be specified so that the expression is only evaluated if the condition is met for a given number. |
| Function: | LoopSum |
| Result-type: | Numeric |
| Arguments: | nStart, nEnd, cPlaceholder, cQuotedExpression [, cQuotedCondition] |
| Description: | For each number from nStart to nEnd, executes the quoted expression (with the number replacing the placeholder) and adds the value to the result (for boolean expressions, adds 1 for TRUE, 0 for FALSE). Optionally a condition can be specified so that the expression is only evaluated and added if the condition is met for a given number. |
| Function: | Max |
| Result-type: | Unknown |
| Arguments: | e1, e2 [,e3 ...] |
| Description: | Returns the maximum of any number of arguments. May be used for numbers, dates, boolean or text (case sensitive), as long as all arguments are the same type |
| Function: | Min |
| Result-type: | Unknown |
| Arguments: | e1, e2 [,e3 ...] |
| Description: | Returns the minimum of any number of arguments. May be used for numbers, dates, boolean or text (case sensitive), as long as all arguments are the same type |
| Function: | Mod |
| Result-type: | Numeric |
| Arguments: | nDividend, nDivisor |
| Description: | Modulus math function (remainder after division). Calculates the floating-point remainder of (nDividend / nDivisor) such that nDividend = i * nDivisor + remainder, where i is an integer, remainder has the same sign as nDividend, and the absolute value of the remainder is less than the absolute value of nDivisor. |
| Function: | Pi |
| Result-type: | Numeric |
| Arguments: | (none) |
| Description: | Returns the mathematical value of Pi (3.14159265358979...) |
| Function: | Round |
| Result-type: | Numeric |
| Arguments: | nValue, nDecimalPlaces |
| Description: | Rounds a value to the given number of decimal places |
| Function: | Sign |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Returns -1 if the value is less than 0, 1 if the value is greater than 0, or 0 if it's exactly 0 |
| Function: | Sin |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Sine (geometry function) |
| Function: | Sqrt |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Square root (math function) |
| Function: | Tan |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Tangent (Geometry function) |