Excel QUOTIENT Function: Divide Numbers Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office
How to Divide in Excel With the QUOTIENT Function
Learn how to divide without showing the remainder
By Ted French Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. lifewire's editorial guidelines Updated on January 18, 2022 Tweet Share Email Tweet Share Email MS Office Excel Word Powerpoint Outlook What to Know
The syntax for the QUOTIENT function is =QUOTIENT (Numerator, Denominator).Select the cell where you want the quotient to appear and go to Formulas > Math & Trig > QUOTIENT.In Excel Online, go to Insert > Function > Math & Trig > QUOTIENT, then select the function and its arguments. This article explains how to divide numbers in Excel without displaying the remainder. Use the QUOTIENT function to return the integer portion (whole number only) as a result — not the remainder. Information in this article applies to Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2019 for Mac, Excel 2016 for Mac, Excel for Mac 2011, and Excel Online. The QUOTIENT Function' s Syntax and Arguments
The syntax for the QUOTIENT function is: =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: The function first divides the numbers in each array:100/2 (answer of 50)4/2 (answer of 2)Numerator: 50Denominator: 2The function then uses the results of the first step for its arguments in a division operation (50/2) to get a final answer of 25. 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). Use Excel' s QUOTIENT Function
The steps show how to enter the QUOTIENT function and its arguments located in cell B6 of the image above. 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. When entering the function manually, separate all arguments with commas. Enter the QUOTIENT Function
These steps cover entering the QUOTIENT function in cell B6 using the function's dialog box. Select cell B6 to make it the active cell. This is the location where the formula results will be displayed. Select Formulas. Select Math & Trig to open the function drop-down list. Choose QUOTIENT in the list to bring up the function's dialog box. In the dialog box, select the Numerator line. Select cell A1 in the worksheet to enter this cell reference into the dialog box. In the dialog box, select the Denominator line. Select cell B1 in the worksheet. Select OK in the dialog box to complete the function and return to the worksheet. 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. Select cell B6 to make it the active cell. This is the location where the formula results will be displayed. Select the Insert > Function to open the Insert Function dialog box. Select Math & Trig in the Pick a Category list. Select QUOTIENT in the Pick a Function list. Select OK. Select cell A1 to select the Numerator and type a comma ( , ). Select cell B1 to select the Denominator and type a close parenthesis ( ) ). Press Enter. 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. Other Ways to Divide in Excel
To carry out regular division operations where the whole number and remainder are returned, use a division formula. To return only the remainder, the fractional or decimal portion of a division operation, use the MOD function. To remove the fractional portion of a division formula and round numbers down to the nearest whole number, use the INT function. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Round Numbers Down in Excel With the ROUNDDOWN Function Excel SUMIFS: Sum Only Values Meeting Multiple Criteria How to Combine the ROUND and SUM Functions in Excel Use Excel's EOMONTH Function to Add or Subtract Months How to Use Excel's MROUND Function How to Use the Round Function in Excel Use the Excel RIGHT Function to Extract Characters How to Subtract Dates in Excel Round up Numbers in Excel With the ROUNDUP Function How to Use the DAY function in Excel How to Count Data in Selected Cells With Excel's COUNTIF Function How to Divide in Google Sheets How to Use the Excel TRUNC Function Excel Math: How to Add, Subtract, Divide, and Multiply How to Use the Google Spreadsheets AVERAGE Function How to Use a Dynamic Range in Excel With COUNTIF and INDIRECT Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies