WPS #DIV/0!: Find the Zero in a Ratio

Scope: WPS Spreadsheet, English official Academy documentation checked October 21, 2026. The source does not specify a numeric build or guarantee identical Windows, macOS, Linux, web and mobile behavior. These are core formula exercises, not premium-feature instructions. No WPS execution or screenshot was performed. Expected results combine documented error rules with independently checked arithmetic; they are not native test observations. Use a disposable workbook.

Start with the denominator

WPS Academy’s error reference identifies division by zero as the cause of #DIV/0!. Its section heading contains a typographical variant, but the explanation uses #DIV/0!; that is the label used here.

A ratio can fail even when the visible inputs look reasonable. A denominator calculated from their difference may be zero. Inspect intermediate results before replacing a formula with a fallback.

Reproduce a remaining-capacity ratio

In a disposable sheet, enter 90 in A2, 15 in B2 and 15 in C2. These represent a synthetic remaining workload, total available slots and allocated slots. Put =B2-C2 in D2 and =A2/D2 in E2. D2 equals 0, making E2 an expected #DIV/0! case.

For this exercise, the verified allocation record should say 10. Correct C2 to 10. D2 should become 5 and E2 18. Independently, 5 × 18 = 90.

Set A2 to 0, leaving five slots available. E2 should now be 0, a valid result. Restore A2 to 90 and C2 to 15; division is again undefined. These two zero cases should not be combined in the same report category.

Decide what a real zero denominator means

If all slots genuinely are allocated, do not falsify the allocation to obtain a number. The ratio is unavailable under this model. Preserve that condition or label it according to an explicit reporting rule. Returning zero would claim no workload per available slot despite there being no available slots.

Check copied references, units and source records. A formatted cell that looks blank or displays a rounded number is not a reliable substitute for inspecting its actual value and formula. This guide’s exercise uses explicit integer zeros, not an unverified assumption about every kind of empty cell.

WPS Academy also describes clearing error cells as a cleanup operation. That removes content rather than repairing the model; it is deliberately not used here. Keep formulas intact while identifying the cause. IFERROR can implement an agreed reporting fallback later, but hiding an error is not a validation step. For a formula displayed as literal text instead of any result, use the separate formula-text diagnosis.

Return to the WPS Spreadsheet error selector.