How to Use the MOD Function in WPS on Windows

Last updated:July 23, 2026

Use the MOD function in WPS with 3 how-to topics, all available without membership, covering formula entry, fill-down calculation, and combined formula use.

How-to Index

#TopicMembership
11. Enter a basic MOD formulaFree
22. Fill down MOD results across rowsFree
33. Combine MOD with other formulasFree

How-to Guide

1. Enter a basic MOD formula

Entry point: A worksheet cell in WPS Spreadsheets

  1. Open WPS Spreadsheets and go to the worksheet where you want to calculate a remainder.
  2. Click the target cell.
  3. Enter =MOD(10,3) or =MOD(A2,B2).
  4. Press Enter to return the result.

Success Criteria

  • UI state: The selected cell shows the remainder result.
  • Next actions: You can edit the formula or copy it to other cells.

Tips While Using

  • Common mistakes: Incorrect parentheses, commas, or cell references can prevent the formula from calculating correctly.
  • Environment limits: If the divisor is 0, the formula cannot return a normal remainder result.

2. Fill down MOD results across rows

Entry point: A cell that already contains a MOD formula

  1. Enter the MOD formula in the first result cell.
  2. Select that cell.
  3. Drag the fill handle downward across the target range.
  4. Check whether each row returns the expected remainder based on its references.

Success Criteria

  • UI state: The target range shows continuous calculation results.
  • Next actions: You can continue with sorting, filtering, or later formulas.

Tips While Using

  • Common mistakes: If the reference pattern is not what you expect, filled results will change with each row.
  • Environment limits: Before batch calculation, confirm that the dividend and divisor columns contain numeric values.

3. Combine MOD with other formulas

Entry point: A worksheet cell in WPS Spreadsheets

  1. Select the cell where you want to show the final result.
  2. Enter a combined formula such as =IF(MOD(A2,2)=0,"Even","Odd").
  3. Press Enter to confirm the result.
  4. Fill the formula down if needed.

Success Criteria

  • UI state: The cell shows the evaluated text or calculation result.
  • Next actions: You can continue using filters, conditional formatting, or summary formulas.

Tips While Using

  • Common mistakes: Text values in the formula should be wrapped in double quotation marks.
  • Environment limits: If the full formula is long, confirm that the MOD part works correctly before nesting more functions.