Math Formulas and Operators
Last updated
Last updated
Formula
=abs(<number>)
Description
Returns the absolute value of a given number.
Arguments
| Argument | Required (Y/N) | Description |
|---|---|---|
Examples
=abs(5) => 5
=abs(-5) => 5
=abs(0) => 0
=add(<input 1>, <input 2>...,[input n])
=<Input1>+<Input2>...+[input n]
Adds all given numeric inputs.
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
Formula
=ceiling(<input>)
Description
Rounds a number up. Negative numbers are rounded towards 0. Calling this function without any input will return 0.
Arguments
Examples
Example 1:
=ceiling(5.99999) => 6.0
Example 2:
=ceiling(5.11115) => 6.0
Example 3:
=ceiling(-5.11115) => -5.0
=divide(<input1>, <input2>...,[input n])
=<input1>/<input2>
Divides all given inputs from left to right
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
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
Examples
Example 1:
=floor(5.99999) => 5.0
Example 2:
=floor(5.11115) => 5.0
Example 3:
=floor(-5.11115) => -6.0
=max(<input>,... [input n])
Finds the maximum value in a list of values.
Examples
Example 1:
=max($"International Sales, $"Domestic Sales")
Example 2:
=max(100, multiply(5,25), 90) = 125
=min(<input1>, [input2], ...)
Finds the minimum value in a list of values.
Example 1:
=min(currentdate(), $"Date of Purchase")
Example 2:
=min(100, multiply(5, 25)) = 100
=multiply(<input1>, [input2], ...)
= <input1>*[input2]
Multiplies all given inputs.
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
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
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(<input1>, [input2], ...)
=<input1>-<input2>...
Subtracts the inputs from left to right.
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(<input1>, [input2], ...)
=<input1>+[input2]...
Adds all given inputs
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
| Argument | Required (Y/N) | Description |
|---|---|---|
| Argument | Required (Y/N) | Description |
|---|---|---|
| Argument | Required (Y/N) | Description |
|---|---|---|
number
Y
The number to get the absolute value of
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
input
Y
The number to be rounded
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
input
Y
The number to be rounded
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
Argument
Required (Y/N)
Description
Input
Y
The first input to be evaluated
[Input,....]
N
The second and any additional inputs to be evaluated
Argument
Required (Y/N)
Description
Input
Y
The first input to be evaluated
[Input,...]
N
The second and any additional inputs to be evaluated
input
Y
The number to be rounded
precision
Y
The number of significant digits to keep. Defaults to 2 if nothing is provided
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
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