QUOTIENT function takes two arguments, numerator and denominator. Numerator is the number that should be divided, and denominator is the number to divide numerator by.


The number 5 divided by 2 returns 2.5, since 2 goes into 5 two and a half times: With the QUOTIENT function, the decimal portion is discarded: Other examples:


If denominator is zero (0) or a reference to an empty cell, QUOTIENT returns #DIV! To return only the remainder, use the MOD function.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.