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

QUOTIENT function

Returns the whole number part of a division.

Syntax

=QUOTIENT(numerator, denominator)

Arguments

ArgumentRequiredDescription
numeratorRequiredThe number to divide
denominatorRequiredThe number to divide by

How to use QUOTIENT

QUOTIENT takes 2 required arguments. Type =QUOTIENT( 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.

=QUOTIENT(5, 2)Result 2
=QUOTIENT(4.5, 3.1)Result 1
=QUOTIENT(-10, 3)Result -3

Every formula, right in your browser

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