The header says kN, the formula gives kN.m: checking units in an Excel™ calculation
A column is headed "Force (kN)". Its formula multiplies a force by a distance. The result is a moment, in kN.m, under a header that says kN. The number is plausible, so nobody stops to question it.
Do the algebra beside the formula
For any formula in a calculation sheet, write the units out:
- force × length = moment (kN × m = kN.m)
- stress × area = force (MPa × mm² = N)
- moment ÷ section modulus = stress
If the units on the right of the equals sign do not match the header, something is wrong: the header, the formula or a reference.
Check by hand
These steps apply to Excel™ in Microsoft 365.
- Press Ctrl+` to show formulas instead of results.
- For each calculated column, read the formula and name the unit of each reference from its header or row label.
- Write the resulting unit in a note or helper row next to the column.
- Compare it with the header. Fix the header or the formula.
- For branches, check an
IFreturns the same unit from each branch. A formula that returns kN in one branch and kN.m in the other is a trap. - Check a result against a hand calculation with round numbers.
Know what a check cannot do
Some quantities are dimensionally identical, such as torque and energy, or stress and pressure, so units alone cannot separate them. A formula that is dimensionally valid can still be the wrong formula. A clean unit check means no contradiction was found. It does not mean the calculation is correct.
Let the checker follow it through
Unit-aware Calculation Checker recovers units from headers, labels, formats, notes and defined names, and reports a header that contradicts its formula, or an IF that returns different units from different branches, with the evidence under each finding. Lookups and some constructs are reported as unreadable, not guessed. Checking the active sheet is free.
See Unit-aware Calculation Checker for Excel™
Microsoft, Excel and Microsoft 365 are trademarks of the Microsoft group of companies. Unit-aware Calculation Checker is not affiliated with or endorsed by Microsoft.