Math Functions

Last modified: October 29, 2019

A math function performs mathematical calculations. Math functions can only be used with Number data types.

ABS(x): Absolute value of (x). It is the distance between 0 and a number. The value is always positive.


ABS(32) returns 32

ABS(-32) returns 32

ACOS(x): Arc - Cosine of (x)

Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is (x). The returned angle is given in radians in the range 0 (zero) to pi. The number (x) must be between -1 and 1.


ACOS(0.5) returns 1.047198

ASIN(x): Arc - Sine of (x)

Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is (x). The returned angle is given in radians in the range -pi/2 to pi/2.


ASIN(0.5) returns 0.523599

ATAN(x): Arc - Tangent of (x)

Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is (x). The returned angle is given in radians in the range -pi/2 to pi/2.


ATAN(0.8) returns 0.674741

ATAN2(y, x): Arc - Tangent of (y/x)

Returns the arctangent of y and x.


ATAN2(4, -3) returns 2.2143

Average(n1,...): Average of a list of numbers.


Average(20,30,55) returns 35 since [(20+30+55)/3]= 35

CEIL(x): Returns smallest integer greater than or equal to (x). Works like the RoundUp function in Excel.


CEIL(1.1) returns 2

CEIL (6.54) returns 7

CEIL(-30.42) returns -30

COS(x): Cosine of (x)

COSH(x) : Hyperbolic Cosine of (x)

DISTANCE(from_Lat,from_Lon, to_Lat, to_Lon): Returns distance from (lat1,Lon1) to (lat2,lon2)


DISTANCE(42,-90, 43, -80) returns a value of 513.473706 miles

EXP(x): Returns e^x

FLOOR(x): Returns largest integer less than or equal to (x)


FLOOR(1.1) returns 1

FLOOR(6.54) returns 6

FLOOR(-30.42) returns -31

LOG(x): Natural logarithm of (x)


LOG(1) returns 0

LOG(14) returns 2.639057

LOG10(x): Base 10 logarithm of (x)


LOG10(1) returns 0

LOG10(14) returns 1.146128

Median(...): Calculates the median out of one or more (possibly unsorted) values.


Median (5, 4, 3, 7, 6) returns 5

Mod(n,d): Modulo of n divided by d (integer operation)

The Modulo operation finds the remainder of one integer (n) divided by a divisor integer (d). If (n) is positive, the result is positive. If (n) is negative, the result is negative.

If decimal values are used, the decimal is truncated. This can result in a "Divided by 0" error if the divisor is a decimal less than 1.


MOD(6,4) returns 2

MOD(6,-4) returns 2

MOD(-6,4) returns -2

MOD(-6,-4) returns -2

MOD(6,.4) returns [Null]

PI(): Returns the value of the constant PI to 15 digits of accuracy


PI() returns  3.141593

POW(x, e): Returns (x) raised to the (e) power


POW(2, 3) is equivalent to 2 3 and returns 8

RAND(): Returns a random number between 0 and 1


RAND() returns a random number like 0.256

RandInt(n): Returns a random integer between 0 and the specified parameter


RandInt(10) returns 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 or 10

RandInt(5000) returns a random whole number between 0 and 5000, such as 741

Round(x, mult): Returns (x) rounded to nearest multiple of (mult)


Round(55.34, 2) returns a value of 56

Round(39.88, 10) returns a value of 40

Round(41.1, 10) returns a value of 40

Round(1.25, 0.1) returns a value of 1.3

Round(1.227, 0.01) returns a value of 1.23

SIN(x): Sine of (x)

SINH(x): Hyperbolic Sine of (x)

SmartRound(x): Returns (x) rounded to nearest multiple of a value determined dynamically based on the size of (x)

SQRT(x): Square root of (x)


SQRT(100) returns a value of 10

TAN(x): Tangent of (x)

TANH(x): Hyperbolic Tangent of (x)

Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.