Links

Math Formulas and Operators

Abs

Formula
=abs(<number>)
Description
Returns the absolute value of a given number.
Arguments
Argument
Required (Y/N)
Description
number
Y
The number to get the absolute value of
Examples
=abs(5) => 5
=abs(-5) => 5
=abs(0) => 0

Add +

Formula

=add(<input 1>, <input 2>...,[input n])
=<Input1>+<Input2>...+[input n]

Description

Adds all given numeric inputs.

Arguments

Argument
Required (Y/N)
Description
Input1
Y
The first input to be added
input2
Y
The second and any additional inputs to be added
input n
N
Any number of additional inputs

Examples

Example 1:
=add($"New Users", $"Current Users")
=$"New Users"+$"Current Users"
Example 2:
=add($"Q1 Orders", $"Q2 Orders", $"Q3 Orders, $"Q4 Orders")
=$"Q1 Orders"+$"Q2 Orders"+$"Q3 Orders+$"Q4 Orders" Example 3: =add(1, 1) will return 2
=1+1 will return 2

Ceiling

Formula
=ceiling(<input>)
Description
Rounds a number up. Negative numbers are rounded towards 0. Calling this function without any input will return 0.
Arguments
Argument
Required (Y/N)
Description
input
Y
The number to be rounded
Examples
Example 1:
=ceiling(5.99999) => 6.0
Example 2:
=ceiling(5.11115) => 6.0
Example 3:
=ceiling(-5.11115) => -5.0

Divide /

Formula

=divide(<input1>, <input2>...,[input n])
=<input1>/<input2>

Description

Divides all given inputs from left to right

Arguments

Argument
Required (Y/N)
Description
Input1
Y
The first input to be divided
Input2
Y
The first input to divide by, and any additional inputs to divide by
Input n
N
Any additional number of inputs

Examples

Example 1:
=divide($"Annual Cost", 12)
=$"Annual Cost"/12
Example 2:
=divide(10, 2, 2) will return 2.5
=10/2/2 will return 2.5

Floor

Formula
=floor(<input>)
Description
Rounds a number down. Negative numbers are rounded away from 0. Calling this function without any inputs will return 0.
Arguments
Argument
Required (Y/N)
Description
input
Y
The number to be rounded
Examples
Example 1:
=floor(5.99999) => 5.0
Example 2:
=floor(5.11115) => 5.0
Example 3:
=floor(-5.11115) => -6.0

Max

Formula

=max(<input>,... [input n])

Description

Finds the maximum value in a list of values.

Arguments

Argument
Required (Y/N)
Description
Input
Y
The first input to be evaluated
[Input n]
N
The second and any additional inputs to be evaluated
Examples
Example 1:
=max($"International Sales, $"Domestic Sales")
Example 2:
=max(100, multiply(5,25), 90) = 125

Min

Formula

=min(<input1>, [input2], ...)

Description

Finds the minimum value in a list of values.

Arguments

Argument
Required (Y/N)
Description
Input
Y
The first input to be evaluated
[Input,....]
N
The second and any additional inputs to be evaluated

Examples

Example 1:
=min(currentdate(), $"Date of Purchase")
Example 2:
=min(100, multiply(5, 25)) = 100

Multiply *

Formula

=multiply(<input1>, [input2], ...)
= <input1>*[input2]

Description

Multiplies all given inputs.

Arguments

Argument
Required (Y/N)
Description
Input
Y
The first input to be evaluated
[Input,...]
N
The second and any additional inputs to be evaluated

Examples

Example 1:
=multiply($"Unit Cost", $"Monthly Purchases")
=$"Unit Cost"*$"Monthly Purchases"
Example 2:
=multiply(100, divide(25, 5)) will return 500
=100*(25/5) will return 500

Round

Formula
=round(<input>, <precision>)
Description
Rounds a number to the specified number of significant digits. Rounds halfway numbers away from 0. Calling this function without any inputs will return 0.
Arguments
Argument
Required (Y/N)
Description
input
Y
The number to be rounded
precision
Y
The number of significant digits to keep. Defaults to 2 if nothing is provided
Examples
Example 1:
=round(5.99999, 2) => 6.00
Example 2:
=round(5.11115, 2) => 5.11
Example 3:
=round(5.11115, 4) => 5.1112
Example 4:
=round(5.11114, 4) => 5.1111

Subtract -

Formula

=subtract(<input1>, [input2], ...)
=<input1>-<input2>...

Description

Subtracts the inputs from left to right.

Arguments

Argument
Required (Y/N)
Description
Input
Y
The first input to be subtracted from
[Input,...]
N
The first input to subtract from the first input, and any additional inputs to subtract from the previous inputs

Examples

Example 1:
=subtract("$Worldwide Sales", $"Domestic Sales")
="$Worldwide Sales"-$"Domestic Sales"
Example 2:
=subtract(100, 60, 30, 20) will return -10
=100-60-30-20 will return -10

Sum "+"

Formula

=sum(<input1>, [input2], ...)
=<input1>+[input2]...

Descriptions

Adds all given inputs

Arguments

Argument
Required (Y/N)
Description
Input
Y
The first input to be added
[Input,...]
N
The second and any additional inputs to add to the first input

Examples

Example 1:
=sum($"International Sales", $"Domestic Sales")
=$"International Sales"+$"Domestic Sales"
Example 2:
=sum(100, divide(100, 20)) will return 105
=100+(100/20) will return 105