Excel #NUM!: Inspect the Numeric Input Before Forcing a Result

#NUM! is not a request to change the cell’s display format. A numeric input may be outside a function’s permitted domain; other cases involve a result outside Excel’s numeric range or a calculation that cannot converge. Microsoft’s NUM error overview identifies these broader causes.

Isolate the argument, not just the last formula

Copy the failing expression to a test area and expose the value supplied to its innermost function. Record what that quantity represents and which units it uses. An unexpected sign can originate in a subtraction several steps before the cell displaying the error.

The following exercise diagnoses a negative square-root input. It is not a general repair for IRR, RATE or every other #NUM! case. Consult the relevant function’s argument rules for those problems; this page does not instruct browser users to change desktop iterative-calculation settings.

Worked case: reversed remaining-area calculation

In a practice sheet enter 81 in A2, meaning total square units, and 32 in B2, meaning used square units. The intended model is the side length of a square with the remaining area.

1. In C2 enter =B2-A2. The expected intermediate value is -49.
2. In D2 enter =SQRT(C2). The documented expected result is #NUM!, because SQRT does not accept a negative argument.
3. Check the model: remaining area means total minus used. Correct C2 to =A2-B2. Expect 49 in C2 and 7 in D2.
4. Change B2 to 45. Expect 36 and 6. This tests whether the repaired expression responds to its intended input.

The Microsoft SQRT reference documents the negative-input error. The separate web formula overview explicitly demonstrates SQRT in Excel for the web.

Why an absolute value can conceal the mistake

For the original reversed subtraction, taking the square root of the magnitude of -49 also gives 7. That numerical coincidence does not validate the subtraction. If used area exceeds total area, the model needs investigation; converting every negative remainder to positive would manufacture an apparent usable area.

Keep the intermediate value visible until the underlying records and intended calculation agree. A zero fallback would likewise claim a measured zero rather than explain why no valid result was available.

Continue with the SQRT function guide for syntax and other examples, or general troubleshooting for a different symptom.

Scope and evidence

Checked October 22, 2026. This is a basic typed-formula exercise for Excel for the web, not a claim about desktop diagnostic controls. Arithmetic and documented error expectations were independently checked; no native Excel execution or screenshot was obtained. No paid edition or account was used. The exercise does not test extreme floating-point values or convergence behavior.