1. Home
  2. Functions
  3. Math
  4. DIVIDE

DIVIDE function

Returns one number divided by another, like the / operator.

Syntax

=DIVIDE(dividend, divisor)

Arguments

ArgumentRequiredDescription
dividendRequiredThe first number
divisorRequiredThe second number

How to use DIVIDE

DIVIDE takes 2 required arguments. Type =DIVIDE( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.

Examples

Each result below was calculated by the SheetsBat formula engine.

=DIVIDE(10, 4)Result 2.5
=DIVIDE(1, 0)Result #DIV/0!

Every formula, right in your browser

SheetsBat calculates 536 functions, with charts, pivot tables and live collaboration. Free to start.