Why Excel Returns 14.21 When Squaring a Displayed 4 and How to Fix It
Question details
The user needs to understand why squaring a cell that appears to contain the number 4 results in 14.21, and how to calculate the expected result based on the displayed whole number.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Squaring a number in a spreadsheet where the cell displays a rounded integer but the underlying value contains hidden decimals.
- Observed behavior
- Excel returns approximately 14.21 instead of the expected 16 when squaring a cell that visibly displays the number 4.
Before modifying your formulas, click on the cell containing the number '4' and look at the Formula Bar at the top of the window to verify if it contains a hidden decimal value.
Use the ROUND Function to Calculate the Displayed Value
To force Excel to square the exact whole number you see (4) rather than the hidden decimal value, you need to round the stored value first within your formula.
Excel uses the underlying stored value for calculations, not the value displayed on your screen. If the cell displays 4 but stores a number like 3.7696, squaring it will yield 14.21. Wrapping your cell reference in a ROUND function ensures the calculation uses the rounded integer.
Click on the cell where you want the squared result to appear.
Type the formula =ROUND(A1, 0)^2 (assuming your number is in cell A1). The '0' tells Excel to round to zero decimal places before multiplying.
Press the Enter key on your keyboard. The cell will now calculate the square of the rounded integer, correctly returning 16.

Change Cell Formatting to Reveal the True Stored Value
Adjusting the cell's number format will show the underlying decimal value so you can accurately understand why Excel is calculating 14.21.
Handle Calculations and Number Formatting Easily with WPS Spreadsheet
WPS Spreadsheet seamlessly handles exact calculations and formatting displays, offering 100% compatibility with standard spreadsheet functions like ROUND and MROUND. It helps you manage underlying decimal values easily to prevent calculation errors.
- 1. Open your document in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet to review the calculation issue.
- 2. Check the Formula Bar: Click on the cell displaying the number. The top Formula Bar will instantly show you the true stored decimal value.
- 3. Apply the ROUND function: Type =ROUND(cell_reference, 0)^2 into your target cell to instantly correct the squared calculation based on the visual whole number.

Frequently Asked Questions
Does changing the cell format change the stored calculation value in Excel?
No, changing a cell's formatting to display fewer decimals only changes how the number looks on the spreadsheet. Excel continues to use the exact, unrounded decimal value for all mathematical calculations.
What is the difference between the ROUND and MROUND functions?
The ROUND function rounds a number to a specified number of decimal digits (e.g., 0 for whole numbers). The MROUND function rounds a number to a desired multiple of another number, which is useful for rounding to the nearest 0.5 or 5.
Is there a setting to force Excel to calculate based only on displayed values?
Yes, there is an advanced workbook option called 'Set precision as displayed'. However, enabling this permanently alters stored values and drops the hidden decimal data, which can lead to permanent data loss. Using the ROUND function is generally much safer.




