Calculation Issues

Why Excel Returns 14.21 When Squaring a Displayed 4 and How to Fix It

Olivia MillerOlivia Miller Nov 10, 2026 870 views

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.

Why Excel Returns 14.21 When Squaring a Displayed 4
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 you start

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.

Solution 1Recommended

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.

1
Select the result cell

Click on the cell where you want the squared result to appear.

2
Enter the ROUND formula

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.

3
Press Enter

Press the Enter key on your keyboard. The cell will now calculate the square of the rounded integer, correctly returning 16.

Use the ROUND Function to Calculate the Displayed Value
Alternative function: You can also use the MROUND function to round to specific multiples, such as =MROUND(A1, 1), and then square the result.

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. 1. Open your document in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet to review the calculation issue.
  2. 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. 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.
100% compatible with Microsoft Excel formulas and number formatsIntuitive Increase/Decrease Decimal buttons to easily verify underlying valuesFree, lightweight, and fast alternative to standard Office suites
microsoft office alternative - wps office

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.