Mathematical Functions
Mathematical functions are listed by their name, description, and syntax.
ABS
Returns the absolute value of a number.
ABS(<expression>)
Example model equation:
V Change in Sales = ABS(-100)
Example result: 100
ACOS
Returns the arc cosine (in radians) of a number.
ACOS(<expression>)
Example model equation:
V Angle = ACOS(.5)
Example result: 1.047198
ASIN
Returns the arc sine (in radians) of a number.
ACOS(<expression>)
Example model equation:
V Angle = ASIN(.5)
Example result: .523599
ATAN
Returns the arc tangent (in radians) of a number.
ATAN(<expression>)
Example model equation:
V Angle = ATAN(.5)
Example result: .463548
CEILING
Returns number rounded up, away from zero, to the nearest multiple of significance.
CEILING(<expression>, <significance>)
Example model equation:
V Capacity Needed = CEILING(44.2, 10)
Example result: 50
Other examples:
CEILING(2.5, 1) equals 3
CEILING(-2.5, -2) equals -4
CEILING(-2.5, 2) equals NaN
CEILING(1.5, 0.1) equals 1.5
CEILING(0.234, 0.01) equals 0.24
COS
Returns the cosine of the given angle (given in radians).
COS(<expression>)
Example model equation:
V Cosign Value = COS(0.78)
Example result: 0.7109
COSH
Returns the hyperbolic cosine of the given number. Equal to the expression (e^x + e^(-x)) / 2
COSH(<expression>)
Example model equation:
V Result = COSH(0)
Example result: 1
E
Returns the value of E
E
Example model equation:
V E Value = E
Example result: 2.718281828459045
EXP
Returns a power of E
EXP(<expression>)
Example model equation:
V Power of E Value = EXP(0.5)
Example result: 1.6487
FLOOR
Rounds number down, toward zero, to the nearest multiple of significance.
FLOOR(<expression>, <significance>)
Example model equation:
V Machinery Needed = FLOOR(112.7, 10)
Example result: 110
Other examples:
FLOOR(2.5, 1) equals 2
FLOOR(-2.5, -2) equals -2
FLOOR(-2.5, 2) equals NaN
FLOOR(1.5, 0.1) equals 1.5
FLOOR(0.234, 0.01) equals 0.23
FRAC
Returns the fractional part of a number. If the argument is negative, then the result will be negative.
FRAC(<expression>)
Example model equation:
V Population = FRAC(444.9)
Example result: 0.9
INT
Rounds a number down (towards negative infinity) to the nearest integer.
INT (<expression>)
Example model equation:
V Population = INT(444.9)
Example result: 444
LN
Returns the natural logarithm of a number.
LN (<expression>)
Example model equation:
V Natural Log Value = LN(5.3)
Example result: 1.6677
LOG10
Returns the base-10 logarithm of a number.
LOG10 (<expression>)
Example model equation:
V Log 10 Value = LOG10(5.3)
Example result: 0.72427
MOD
Returns the remainder after number is divided by divisor.
MOD (<expression>, <divisor>)
Example model equation:
V Remainder = MOD(8,3)
Example result: 2
NAN
Returns the value NaN or "Not a Number"
NAN
Example model equation:
V No Value = NAN
Example result: ?
PCT
Converts a fraction into a percentage (equivalent to multiplying by 100)
PCT (<expression>)
Example model equation:
V Profitability = PCT(0.34)
Example result: 34
PI
Returns the value of PI
PI
Example model equation:
V Value of PI = PI
Example result: 3.141592653589793
ROUND
Rounds to a specified number of digits. If <num_digits> is 0, then number is rounded to the nearest integer. If <num_digits> is less than 0, then number is rounded to the left of the decimal point.
ROUND (<expression>)
ROUND (<expression>, <num_digits>)
Example model equation:
V New Hires = ROUND(45.7, -1)
Example result: 50
Other Examples:
ROUND(2.15, 1) equals 2.2
ROUND(2.149, 1) equals 2.1
ROUND(-1.475, 2) equals -1.48
ROUND(21.5, -1) equals 20
ROUNDDOWN
Rounds down to a specified number of digits. If <num_digits> is greater than 0 (zero), then number is rounded to the specified number of decimal places. If <num_digits> is 0, then number is rounded to the nearest integer. If <num_digits> is less than 0, then number is rounded to the left of the decimal point.
ROUNDDOWN (<expression>)
ROUNDDOWN (<expression>, <num_digits>)
Example model equation:
V New Hires = ROUNDDOWN(45.7, -1)
Example result: 40
Other Examples:
ROUNDDOWN(3.2, 0) equals 3
ROUNDDOWN(76.9, 0) equals 76
ROUNDDOWN(3.14159, 3) equals 3.141
ROUNDDOWN(-3.14159, 1) equals -3.1
ROUNDDOWN(31415.92654, -2) equals 31,400
ROUNDUP
Rounds up to a specified number of digits. If <num_digits> is greater than 0 (zero), then number is rounded to the specified number of decimal places. If <num_digits> is 0, then number is rounded to the nearest integer. If <num_digits> is less than 0, then number is rounded to the left of the decimal point.
ROUNDUP(<expression>)
ROUNDUP(<expression>, <num_digits>)
Example model equation:
V New Hires = ROUNDUP(43.3, -1)
Example result: 50
Other Examples:
ROUNDUP(3.2, 0) equals 4
ROUNDUP(76.9, 0) equals 77
ROUNDUP(3.14159, 3) equals 3.142
ROUNDUP(-3.14159, 1) equals -3.2
ROUNDUP(31415.92654, -2) equals 31,500
SAFEDIV0
Divides A by B. If B is 0, returns 0.
SAFEDIV0(A, B)
Example model equation:
V Profitability = SAFEDIV0(500, 0)
Example result: 0
SAFEDIVX
Divides A by B. If B is 0, returns X.
SAFEDIVX(A, B, X)
Example model equation:
V Product Attractiveness = SAFEDIVX(5.4, 0, 1)
Example result: 1
SIGN
Determines the sign of a number. Returns 1 if positive, 0 if 0, and -1 if negative.
SIGN(
Example model equation:
V Is It Profitable = SIGN(-10000)
Example result: -1
SIN
Returns the sine of the given angle (given in radians).
SIN(<angle>)
Example model equation:
V SINE VALUE = SIN(0.73)
Example result: 0.66686
SINH
Returns the hyperbolic sine of the given number. Equal to the expression (e^x - e^(-x)) / 2.
SINH(<expression>)
Example model equation:
V Result = SINH(0)
Example result: 0
SQRT
Returns a positive square root.
SQRT(<expression>)
Example model equation:
V Square Root of a Million = SQRT(1000000)
Example result: 1000
Other examples:
SQRT(16) equals 4
SQRT(-16) equals NAN
TAN
Returns the tangent of the given angle (given in radians).
TAN(<angle>)
Example model equation:
V Tangent Value = TAN(0.35)
Example result: 0.365028
SINH
Returns the hyperbolic tangent of the given number. Equal to the expression (e^x - e^(-x)) / (e^x + e^(-x)).
TANH(
Example model equation:
V Result = TANH(0)
Example result: 0
TRUNC
Truncates a number to an integer by removing the fractional part of the number.
TRUNC(<expression>)
Example model equation:
V Truncated Number = TRUNC(45.764321)
Example result: 45
Other Examples:
TRUNC(8.9) equals 8
TRUNC(-8.9) equals -8
