• Login

DataSoft Corporation

Math Functions

FunctionDescriptionExample
Abs(Value) Returns the given numeric expression's absolute, positive value. Abs(1 - [Discount])
Acos(Value) Returns a number's arccosine (the angle in radians, whose cosine is the given float expression). Acos([Value])
Asin(Value) Returns a number's arcsine (the angle in radians, whose sine is the given float expression). Asin([Value])
Atn(Value) Returns a number's arctangent (the angle in radians, whose tangent is the given float expression). Atn([Value])
Atn2(Value1, Value2) Returns the angle whose tangent is the quotient of two specified numbers in radians. Atn2([Value1], [Value2])
BigMul(Value1, Value2) Returns an Int64 containing the full product of two specified 32-bit numbers. BigMul([Amount], [Quantity])
Ceiling(Value) Returns the smallest integer that is greater than or equal to the numeric expression. Ceiling([Value])
Cos(Value) Returns the angle's cosine, in radians. Cos([Value])
Cosh(Value) Returns the angle's hyperbolic cosine, in radians. Cosh([Value])
Exp(Value) Returns the float expression's exponential value. Exp([Value])
Floor(Value) Returns the largest integer less than or equal to the numeric expression. Floor([Value])
Log(Value) Returns a specified number's natural logarithm. Log([Value])
Log(Value, Base) Returns the logarithm of a specified number in a specified Base. Log([Value], 2)
Log10(Value) Returns a specified number's base 10 logarithm. Log10([Value])
Max(Value1, Value2) Returns the maximum value from the specified values. Max([Value1], [Value2])
Min(Value1, Value2) Returns the minimum value from the specified values. Min([Value1], [Value2])
Power(Value, Power) Returns a specified number raised to a specified power. Power([Value], 3)
Rnd() Returns a random number that is less than 1, but greater than or equal to zero. Rnd()*100
Round(Value) Rounds the given value to the nearest integer. Round([Value])
Round(Value, Precision) Rounds the given value to the nearest integer, or to a specified number of decimal places. Round([Value], 2)
Sign(Value) Returns the positive (+1), zero (0), or negative (-1) sign of the given expression. Sign([Value])
Sin(Value) Returns the sine of the angle defined in radians. Sin([Value])
Sinh(Value) Returns the hyperbolic sine of the angle defined in radians. Sinh([Value])
Sqr(Value) Returns the square root of a given number. Sqr([Value])
Tan(Value) Returns the tangent of the angle defined in radians. Tan([Value])
Tanh(Value) Returns the hyperbolic tangent of the angle defined in radians. Tanh([Value])
ToDecimal(Value) Converts Value to an equivalent decimal number. ToDecimal([Value])
ToDouble(Value) Converts Value to an equivalent 64-bit double-precision floating-point number. ToDouble([Value])
ToFloat(Value) Converts Value to an equivalent 32-bit single-precision floating-point number. ToFloat([Value])
ToInt(Value) Converts Value to an equivalent 32-bit signed integer. ToInt([Value])
ToLong(Value) Converts Value to an equivalent 64-bit signed integer. ToLong([Value])

Related Links

Found in Category: Related Articles
Thursday, 27 December 2018 Posted in Expressions Constants, Operators, and Functions