=QUOTIENT ( Numerator , Denominator ) Numerator (required). This is the dividend. It is the number written before the forward slash ( / ) in a division operation. This argument can be an actual number or a cell reference to the location of data in a worksheet. Denominator (required). This is the divisor. It is the number written after the forward slash in a division operation. This argument can be an actual number or a cell reference to the location of data in a worksheet.
Excel QUOTIENT Function Examples
In the image above, the examples show a number of different ways that the QUOTIENT function is used to divide two numbers compared to a division formula. The results of the division formula in cell B4 shows both the quotient (2) and the remainder (0.4) while the QUOTIENT function in cells B5 and B6 returns only the whole number even though both examples are dividing the same two numbers.
Use Arrays as Arguments
Another option is to use an array for one or more of the function’s arguments as shown in row 7 above. The order followed by the function when using arrays is:
QUOTIENT Function Errors
#DIV/0! occurs if the denominator argument is equal to zero or references a blank cell (see row 9 in the example above).#VALUE! occurs if either argument is not a number (see row 8 in the example).
Options for entering the function and its arguments include:
Typing the complete function =QUOTIENT(A1,B1) into cell B6. Selecting the function and its arguments using the QUOTIENT function dialog box.
Although it is possible to just type the complete function in by hand, many people find it easier to use the dialog box to enter a function’s arguments.
Enter the QUOTIENT Function
These steps cover entering the QUOTIENT function in cell B6 using the function’s dialog box. The answer 2 appears in cell B6, since 12 divided by 5 has a whole number answer of 2. The remainder is discarded by the function. When you select cell B6, the complete function =QUOTIENT(A1,B1) appears in the formula bar above the worksheet. Excel Online The Formulas tab is not available in Excel Online. However, you can enter the QUOTIENT function manually. The answer 2 appears in cell B6, since 12 divided by 5 has a whole number answer of 2. The remainder is discarded by the function.
