Fix Division-by-Zero Errors in a Microsoft Word Table Formula
Question details
Divide one Word table cell by another while returning zero when the divisor is zero.

- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- A table formula should divide the value in column C by the value in column A only when the column A value is nonzero.
- Observed behavior
- The formula produces a division-by-zero error instead of returning the intended result.
Identify the numeric cells to use as the dividend and divisor and choose an empty result cell in the same table. The example uses C1 and A1; replace those references with the cells for your row.
Use nested fields with a safe divisor in the Word table
Use this approach to calculate C1 divided by A1 and return zero when A1 is zero.
Word table fields are not Excel formulas. A nested calculation can be evaluated even inside an IF branch, so the formula below substitutes 1 for a zero divisor and multiplies the result by 0 in that case.
The field code is: { = { = C1 } / { IF { = A1 } = 0 1 { = A1 } } * { IF { = A1 } = 0 0 1 } }. Every pair of braces must be an actual Word field delimiter, not typed characters.
Click an empty cell in the same table, such as D1. On Windows, press Ctrl+F9 to insert the outer field braces.
Inside the outer braces, enter the formula shown above. Press Ctrl+F9 for every nested pair of braces, then type the corresponding field instructions inside them. Change A1 and C1 if your values are in different cells.
Select the complete field and press F9 to update it. Press Alt+F9 to switch between field codes and results if needed.
Enter a nonzero number in A1 and confirm the result is C1 divided by A1. Then enter 0 in A1, select the result field, and press F9; the result should be 0.

Edit Documents and Tables with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with documents and tables. It supports common Microsoft Office formats for an easier move between applications, though it does not fix Microsoft Word field behavior.

Frequently Asked Questions
Why does my Word IF field still show a division-by-zero error?
Nested calculation fields can be evaluated even when they appear in an IF branch that should not be used. Substitute a nonzero divisor before dividing, then use another IF field to return zero when the original divisor is zero.
Can I type the braces around a Word field?
No. On Windows, press Ctrl+F9 to insert each pair of field braces. Typed braces are treated as ordinary text.
How do I see the formula instead of its result?
In Word for Windows, press Alt+F9 to toggle between field codes and their results. Select a field and press F9 to update it.
What if my divisor is in a different row?
Replace every A1 reference in the example with the divisor cell for that row, and replace C1 with the corresponding dividend cell. Then select the result field and press F9.
Does the formula work with negative divisors?
Yes. The example tests whether the divisor equals zero, so it divides by either a positive or a negative value when that value is nonzero.




