Skip to content
Google Sheets

QUOTIENT function in Google Sheets

Returns one number divided by another.

=QUOTIENT(dividend, divisor)

QUOTIENT syntax and parameters

Two arguments, two required.

  • dividendnumberRequired

    The number to be divided.

  • divisornumberRequired

    The number to divide by (cannot equal 0).

QUOTIENT examples

Formulas you'll actually reuse.

  1. Full boxes of 12 — the integer part of the division:

    =QUOTIENT(B2, 12)

    Result8

  2. Minutes shown as hours and minutes:

    =QUOTIENT(B2, 60) & "h " & MOD(B2, 60) & "m"

    Result"2h 15m"

QUOTIENT in Excel

Same name — your formula ports as-is.

Try QUOTIENT in the playground

Edit the example — nothing to install.

Preloaded with the QUOTIENT formula from Example 1 — change anything and watch it respond.

Loading the editor…

QUOTIENT errors

What they mean — and the fixes.

  • #DIV/0!

    The denominator is 0 or an empty cell.

Related functions

More ways Google Sheets gets this done.