Math Formulas

Formulas

  1. Add

  2. Divide

  3. Max

  4. Min

  5. Multiply

  6. Subtract

  7. 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($"New Users", $"Current Users")

Example 2:

=add($"Q1 Orders", $"Q2 Orders", $"Q3 Orders, $"Q4 Orders") Example 3: =add(1, 1) = 2

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($"Annual Cost", 12)

Example 2:

=divide(10, 2, 2) = 2.5

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($"International Sales, $"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(), $"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($"Unit Cost", $"Monthly Purchases")

Example 2:

=multiply(100, divide(25, 5)) = 500

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", $"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($"International Sales", $"Domestic Sales")

Example 2:

=sum(100, divide(100, 20)) = 105