Function Problems

Why Excel QUOTIENT Returns an Integer and How to Get Decimal Results

Maira Mehtab Sep 22, 2026 872 views

Question details

The user wants to know why dividing 550 by 7 using the QUOTIENT function yields 78 instead of the expected decimal value (such as 78.6 or 78.5714), and how to fix this formula to show decimals.

Product: Excel
Device & OS: not provided
Scenario: Performing mathematical division in a spreadsheet where a precise decimal result is required.
Observed behavior: The QUOTIENT function truncates the mathematical output, returning only the integer portion (78) and completely discarding the remainder of the division.

Before you start

Check your target cell's number formatting to ensure it is set to 'General' or 'Number' so that decimal places will actually be visible once you correct the formula.

Solution 1Recommended

Use the Standard Division Operator (/)

To retain the remainder and get a precise decimal result, replace the QUOTIENT function with the standard mathematical division operator.

The QUOTIENT function is specifically designed by default to return only the integer portion of a division operation, intentionally dropping any remainder. It is not broken, but it is the wrong tool for exact decimal math. To get the full calculation, you must use the forward slash (/) symbol.

Select the target cell

Click on the cell where you want the precise decimal result to be displayed.

Enter the division formula

Type the equals sign (=), enter the numerator cell reference or value (e.g., D6 or 550), type a forward slash (/), and enter the denominator (e.g., A6 or 7).

Execute the calculation

Press Enter. The cell will now display the exact decimal result, such as 78.571428.

Rounding the Result: If you need a specific number of decimal places (like 78.6), wrap your division operation inside the ROUND function. For example: =ROUND(550/7, 1).

Powerful Spreadsheet Alternative

Calculate Precise Division and Decimals in WPS Spreadsheet

WPS Spreadsheet seamlessly handles both complex function-based mathematics and basic arithmetic. You can easily calculate exact decimals, apply rounding rules, or extract integers using the exact same formulas you already know.

1. Open your workbook: Launch WPS Spreadsheet and select an empty cell for your calculation.
2. Input the division operator: Type =550/7 (or use your specific cell references like =D6/A6) rather than using the QUOTIENT function.
3. Confirm the result: Press Enter to instantly display the accurate decimal calculation on your sheet.
4. Adjust decimal display: Use the 'Increase Decimal' or 'Decrease Decimal' icons located in the Number group on the Home tab to format the exact number of visible decimal places.

Fully compatible with Microsoft Excel formulas including QUOTIENT, ROUND, MOD, and basic arithmetic operators.Lightweight software with a familiar, user-friendly interface that requires zero learning curve.Advanced cell formatting capabilities to instantly manage decimal places with single-click ribbon buttons.Completely free to use for daily spreadsheet calculations and professional data analysis.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the QUOTIENT function exist if it ignores decimals?

QUOTIENT is designed specifically for scenarios where fractional results are impossible or irrelevant, such as determining how many whole items can fit into a shipping container. It extracts just the whole number from a division.

How do I get only the remainder of a division?

To find only the remainder of a division operation, use the MOD function. Typing =MOD(550, 7) will divide 550 by 7 and return 4, which is the remainder left over.

Why does my division operator (/) still show a whole number?

If you used the slash (/) but still see an integer instead of a decimal, the cell formatting is likely set to show zero decimal places. Select the cell, navigate to the Home tab, and click the 'Increase Decimal' button to reveal the hidden fractional values.

Excel & Data Problems