Use DIVIDE to divide one number by another.

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

DIVIDE(Dividend, Divisor)

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

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

/ (divide)


Result
DIVIDE
(50,5)
      10

DIVIDE
(750,000,200)

3,750
DIVIDE
(30,0)

Infinity
DIVIDE
(-45,0)

-Infinity