1. Calculation functions
  2. All Functions
  3. Numeric Functions
  4. DIVIDE

Use the DIVIDE function to divide one number by another.

Syntax

DIVIDE(dividend, divisor)

The DIVIDE function has the following arguments:

Argument Data type Description
dividend (required)

Number

The number you want to divide.

divisor (required)

Number

The number you want to divide the dividend by.

Note:

The DIVIDE function is similar to the / operator, or divide operator, except when dividing numbers by zero:

Function Positive Number Negative Number Zero
DIVIDE

(1, 0) returns Infinity.

(-1, 0) returns -Infinity.

(0, 0) returns NaN (Not a Number).

divide operator

(1/0) returns 0.

(-1/0) returns 0.

(0/0) returns 0.

Operators and Constants contains the full list of operators, including the divide operator, along with examples of best practice.

Constraints

The DIVIDE function has no constraints.

Examples

The following table shows some example formulas using the DIVIDE function.

You can enter values directly into your formula, or reference line items or list properties.

Formula Description Result
DIVIDE(50, 5)

This example shows how you can enter values directly into your formula.

10

DIVIDE(Southwest.Income, Southwest.Population)

This example shows how you can reference line items or list properties in your formula.

Here, the value of Southwest.Income is 750,000, and the value of Southwest.Population is 200.

3,750

Excel equivalent