How to Use Excel MOD Function in WPS Office [Step-by-Step]

August 15, 2023 955 views

This guide focuses on the MOD function in WPS Office's Excel, a powerful tool for mathematical calculations and data analysis. It addresses the common conflicts users face in understanding and using the MOD function effectively. The guide offers step-by-step instructions and practical examples to help users grasp the concept and leverage the function's potential. By the end of the guide, users will gain confidence in utilizing the MOD function for various tasks, elevating their spreadsheet skills and data analysis capabilities in WPS Office.

Part 1. What is the MOD Function in Excel?

The MOD function in WPS Office's Excel is a powerful mathematical function that calculates the remainder when dividing one number by another. With the syntax MOD (dividend, divisor), it takes two arguments: the dividend (the number to be divided) and the divisor (the number by which the dividend is divided). The function returns the remainder of the division operation, helping users analyze cyclical patterns, identify even or odd numbers, and distribute data into groups. This versatile function is valuable for handling various data analysis tasks, making it an essential tool for users dealing with mathematical calculations in WPS Office's Excel.

Part 2. MOD Function in WPS Office Step-by-Step Guideline

The MOD function in WPS Office (and Excel) is used to find the remainder when one number (dividend) is divided by another number (divisor). It is a mathematical function that can be handy in various scenarios, such as distributing items evenly, identifying patterns, or dealing with cyclic data. This tutorial will guide you on how to use the MOD function in WPS Spreadsheets step-by-step:

Step 1: Insert the MOD function in a new column: =MOD(number, divisor).

Step 2: Press Enter to calculate the remainder.

Step 3: Drag the formula down to apply it to other cells.


The MOD function in WPS Spreadsheets (and Excel) is a versatile tool for finding remainders when dividing numbers. It can be used in various scenarios for data analysis, pattern recognition, and distribution calculations. By following this step-by-step tutorial, you can effectively use the MOD function in WPS Office to enhance your data manipulation and analytical capabilities.

Part 3: Microsoft Office Compatibility in WPS

WPS Office is a versatile office suite with a user-friendly interface and robust productivity tools. It supports Microsoft Office file formats, making it a seamless choice for users transitioning from Microsoft Office. With cross-platform compatibility and regular updates, WPS Office ensures productivity and collaboration across devices. Its feature-rich applications, such as WPS Writer, WPS Spreadsheets, and WPS Presentation, empower users to create, edit, and share documents effortlessly. Whether you're a student, professional, or business user, WPS Office caters to diverse needs and enhances productivity in a cost-effective manner.

Recommend WPS Spreadsheet
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Same Excel Formula as Microsoft. Perfectly compatible with MS format.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
Algirdas Jasaitis

Part 4. More Benefits for You to Use WPS Office

WPS Office is a versatile and comprehensive office suite designed to meet various productivity needs. With its user-friendly interface and seamless compatibility with Microsoft Office formats, WPS Office offers a smooth transition for users seeking an alternative to traditional office software.

  • Key Features and Functions:

WPS Writer: Create, edit, and format professional documents with ease. Access a wide range of templates and advanced features to enhance your writing experience.

WPS Spreadsheets: Perform complex data analysis, financial calculations, and data visualization effortlessly. WPS Spreadsheets supports .xlsx files and offers powerful formula editing capabilities.

WPS Presentation: Craft captivating and dynamic presentations with a variety of templates and animations. Share your ideas effectively using .pptx files compatible with Microsoft Office.

PDF Tools: WPS Office includes PDF editing features, allowing you to convert, edit, and annotate PDF documents without the need for additional software.

  • AI Writer Function:

With AI Writer, WPS Office takes productivity to the next level. The AI-driven feature provides intelligent document creation, auto-correction, and grammar suggestions, enabling you to write accurately and efficiently.

  • Free and Cost-Effective:

WPS Office stands out with its free features, making it an affordable solution for users seeking robust office software without any financial burden. Experience the power of WPS Office without compromising on essential functions.


WPS Office is the ultimate free office suite that combines essential functions, seamless Microsoft Office compatibility, and AI-driven features. Whether you are a student, professional, or business user, WPS Office offers a complete package for efficient document creation, data analysis, and presentation. Embrace the power of WPS Office for enhanced productivity and effortless collaboration.


1. How do I use MOD function in Excel VBA?

To use the MOD function in Excel VBA:

  • Open the VBA editor (Alt + F11).

  • Insert a new module.

  • Write the code using the MOD function.

  • Run the VBA code to get the remainder when dividing two numbers.

2. How to use the MOD function in Excel for conditional formatting?

To use the MOD function in Excel for conditional formatting:

  • Select the range of cells.

  • Go to "Conditional Formatting" > "New Rule."

  • Enter the formula with the MOD function (e.g., =MOD(A1, 1) = 0).

  • Set formatting options for cells meeting the condition.

  • Apply the conditional formatting. The MOD function will highlight cells with integer values.

3. What is the opposite of MOD function?

The opposite of the MOD function is the DIV function. While the MOD function calculates the remainder when dividing two numbers, the DIV function calculates the quotient or the whole number result of the division.

For example:

MOD(10, 3) = 1 (remainder when 10 is divided by 3)

DIV(10, 3) = 3 (quotient when 10 is divided by 3)

In the case of DIV, the decimal part of the division result is ignored, and only the whole number quotient is considered. It is particularly useful when you want to divide two numbers and obtain an integer result without any remainder.


This guide explores the powerful MOD function in WPS Office's Excel, which calculates remainders when dividing numbers. It aids in analyzing cyclical patterns, identifying even/odd numbers, and distributing data into groups. With step-by-step instructions and examples, users can confidently leverage the function for various tasks, enhancing spreadsheet skills and data analysis in WPS Office. The article also highlights WPS Office's compatibility with Microsoft formats, AI Writer function for intelligent document creation, and other key features. It addresses FAQs, making WPS Office a user-friendly and cost-effective office suite empowering users with advanced features for efficient document management and data analysis.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.