Math Formulas

Formulas
1.​Add​
2.​Ceiling​
3.​Divide​
4.​Floor​
5.​Max​
6.​Min​
7.​Multiply​
8.Round
9.​Subtract​
10.​Sum​
Add
Formula
=add(input, [input, ...])
Description
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 be added
Examples
Example 1:
=add(quot;New Users", quot;Current Users") 
Example 2:
=add(quot;Q1 Orders", quot;Q2 Orders", quot;Q3 Orders, quot;Q4 Orders") 

Example 3:
=add(1, 1) = 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
N
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(input, [input, ...])
Description
Divides all given inputs from left to right
Arguments
Argument
Required (Y/N)
Description
Input
Y
The first input to be divided
[Input,...]
N
The first input to divide by, and any additional inputs to divide by
Examples
Example 1:
=divide(quot;Annual Cost", 12) 
Example 2:
=divide(10, 2, 2) = 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
N
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, ...])
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
The second and any additional inputs to be evaluated
Examples
Example 1:
=max(quot;International Sales, quot;Domestic Sales") 
Example 2:
=max(100, multiply(5,25), 90) = 125
Min
Formula
=min(input, [input, ...])
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(), quot;Date of Purchase")
Example 2:
=min(100, multiply(5, 25)) = 100
Multiply
Formula
=multiply(input, [input, ...])
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(quot;Unit Cost", quot;Monthly Purchases")
Example 2:
=multiply(100, divide(25, 5)) = 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
N
The number to be rounded
precision
N
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(input, [input, ...])
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", quot;Domestic Sales") 
Example 2:
=subtract(100, 60, 30, 20) = -10
Sum
Formula
=sum(input, [input, ...])
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(quot;International Sales", quot;Domestic Sales")
Example 2:
=sum(100, divide(100, 20)) = 105
​

Timezone specifiers

Logical Formulas

Last modified 9d ago

Copy link

Outline