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

Use DIVIDE to divide one number by another.

You could use DIVIDE to determine the average monthly bonus of your sales team.

Syntax

DIVIDE(Dividend, Divisor)

Arguments

ArgumentData typeDescription
DividendNumber The number to divide. 
DivisorNumber The number to divide by.

Syntax example

DIVIDE(Commission, 7)


LeeSmithChoAkoKhanKnorPatel
Sales Revenue50,00068,00062,50088,00098,60092,00074,230
Commission Ratio      .05       .05     .08     .07      .05     .06    .07
Commission 2,500  3,4005,000  6,160   4,930 5,520  5,196
Ave. monthly
commission
  208.3   283.3  416.6   513.3     410.8   460    433

Excel equivalent

/ (divide)

Detailed Examples


Result
DIVIDE
(50,5)
      10

DIVIDE
(750,000,200)

3,750
DIVIDE
(30,0)

Infinity
DIVIDE
(-45,0)

-Infinity