Math Formulas and Operators
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(<input 1>, <input 2>...,[input n])=<Input1>+<Input2>...+[input n]Adds all given numeric inputs.
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 |
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
Argument | Required (Y/N) | Description |
|---|---|---|
input | Y | The number to be rounded |
Examples
Example 1:=ceiling(5.99999) => 6.0Example 2:=ceiling(5.11115) => 6.0Example 3:=ceiling(-5.11115) => -5.0
=divide(<input1>, <input2>...,[input n])=<input1>/<input2>Divides all given inputs from left to right
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 |
Example 1:=divide($"Annual Cost", 12)=$"Annual Cost"/12Example 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
Argument | Required (Y/N) | Description |
|---|---|---|
input | Y | The number to be rounded |
Examples
Example 1:=floor(5.99999) => 5.0Example 2:=floor(5.11115) => 5.0Example 3:=floor(-5.11115) => -6.0
=max(<input>,... [input n])Finds the maximum value in a list of values.
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(<input1>, [input2], ...)Finds the minimum value in a list of values.
Argument | Required (Y/N) | Description |
Input | Y | The first input to be evaluated |
[Input,....] | N | The second and any additional inputs to be evaluated |
Example 1:=min(currentdate(), $"Date of Purchase")Example 2:=min(100, multiply(5, 25)) = 100
=multiply(<input1>, [input2], ...)= <input1>*[input2]Multiplies all given inputs.
Argument | Required (Y/N) | Description |
Input | Y | The first input to be evaluated |
[Input,...] | N | The second and any additional inputs to be evaluated |
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
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.00Example 2:=round(5.11115, 2) => 5.11Example 3:=round(5.11115, 4) => 5.1112Example 4:=round(5.11114, 4) => 5.1111
=subtract(<input1>, [input2], ...)=<input1>-<input2>...Subtracts the inputs from left to right.
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 |
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
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 |
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
Last modified 1mo ago