Mathematical Functions
ROUNDRounds a number to a specified number of digits. number ROUND( number [, num_digits = 0 ] ) Note: The default value of the optional parameter num_digits is zero. Examples: %=ROUND( 20.567, 1 )% Returns the number 20.6 ROUND_UPRounds a number up, away from zero. number ROUND_UP( number [, num_digits = 0 ] ) Note: The default value of the optional parameter num_digits is zero. Examples: %=ROUND_UP( 20.267, 1 )% Returns the number 20.3 ROUND_DOWNRounds a number down, toward zero. number ROUND_DOWN( number [, num_digits = 0 ] ) Note: The default value of the optional parameter num_digits is zero. Examples: %=ROUND_DOWN( 20.567, 1 )% Returns the number 20 CINTRounds a number down to the nearest integer. number CINT( number ) CEILINGRounds a number to the nearest integer or to the nearest multiple of significance. number CEILING( number, num_base ) Examples: %=CEILING( 20.567, 0.5 )% Returns the number 21 FLOORRounds number down, toward zero, to the nearest multiple of significance. number FLOOR( number, num_base ) Examples: %=FLOOR( 20.567, 0.5 )% Returns the number 20.5 ABSReturns the absolute value of a number. number ABS( number ) MAXReturns the maximum value from the list of value arguments. number MAX( number1, number2 [, number3,...] ) Examples: %=MAX( 20, 30 )% Returns the number 30 MINReturns the minimum value from the list of value arguments. number MIN( number1, number2 [, number3,...] ) Examples: %=MIN( 20, 30 )% Returns the number 20 SUMReturns the total sum of arguments. number SUM( number1, number2 [, number3,...] ) Examples: %=SUM( 20, 30 )% Returns the number 50 AVERAGEReturns the average (arithmetic mean) of arguments. number AVERAGE( number1, number2 [, number3,...] ) Examples: %=AVG( 20, 30 )% Returns the number 25 SIGNReturns the sign of a number. boolean SIGN( number ) Note: This function returns FALSE if the number is less than zero, otherwise, it returns TRUE. FMODReturns the remainder from division. number FMOD( number [, divisor = 1 ] ) Note: The default value of the optional parameter divisor is 1. This function uses the following formula: FMOD( number, divisor ) = number - divisor * CINT( number / divisor ). Examples: %=FMOD( 20.567 )% Returns the number 0.567 POWERReturns the result of a number raised to a power. number POWER( number, num_power ) EXPReturns e raised to the power of a given number. number EXP( num_power ) LOGReturns the logarithm of a number to a specified base. number LOG( number, num_base ) LOG10Returns the base-10 logarithm of a number. number LOG10( number ) SQRTReturns a positive square root. number SQRT( number ) SINReturns the sine of the given angle. number SIN( number ) ASINReturns the arcsine of a number. number ASIN( number ) SINHReturns the hyperbolic sine of a number. number SINH( number ) ASINHReturns the inverse hyperbolic sine of a number. number ASINH( number ) COSReturns the cosine of a number. number COS( number ) ACOSReturns the arccosine of a number. number ACOS( number ) COSHReturns the hyperbolic cosine of a number. number COSh( number ) ACOSHReturns the inverse hyperbolic cosine of a number. number ACOSH( number ) TANReturns the tangent of a number. number TAN( number ) ATANReturns the hyperbolic tangent of a number. number ATAN( number ) TANHReturns the arctangent of a number. number TANH( number ) ATANHReturns the inverse hyperbolic tangent of a number. number ATANH( number ) | |
|