Math Formulas

Formulas

  1. 1.
    ​Add​
  2. 2.
    ​Ceiling​
  3. 3.
    ​Divide​
  4. 4.
    ​Floor​
  5. 5.
    ​Max​
  6. 6.
    ​Min​
  7. 7.
    ​Multiply​
  8. 8.
    Round
  9. 9.
    ​Subtract​
  10. 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
​