QUOTIENT Function

Returns the whole-number part of a division.

Category

Math & Trig

Available in

All versions, Microsoft 365

Returns

A whole number

Want to practice QUOTIENT in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

QUOTIENT divides and throws away the remainder: QUOTIENT(30, 12) is 2.

Pair it with MOD to split a number into “how many whole” and “how many left over”.

Syntax

=QUOTIENT(numerator, denominator) Explain

Arguments

ArgumentRequired?What it does
numeratorYesThe number to divide.
denominatorYesThe number to divide by.

Examples

Example 1 — Weeks and days

Turn a number of days into whole weeks plus days.

B2fx=QUOTIENT(A2, 7)&" wk "&MOD(A2, 7)&" d"
AB
1DaysWeeks + days
2304 wk 2 d
3142 wk 0 d
4456 wk 3 d
=QUOTIENT(A2, 7)&" wk "&MOD(A2, 7)&" d" Explain

Common mistakes

  • Negatives. QUOTIENT truncates towards zero: QUOTIENT(−7, 2) is −3, while INT(−7/2) is −4.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.