ODD in WPS on Windows: Introduction

WPS ODD is a spreadsheet rounding function that rounds a number away from zero to the nearest odd integer; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index
Membership limit	None for this function	The ODD function can be used directly in WPS Spreadsheets
Version limit	None stated	Available in WPS Spreadsheets across supported Windows builds

About This Feature

Overview

The ODD function in WPS Spreadsheets is a math and rounding function used to round a value to the nearest odd integer away from zero. It fits common spreadsheet tasks such as data cleanup, grouped calculations, and nested formulas.

Core capabilities include:

Enter ODD(value) directly in a cell to return an odd integer result.
Reference cell values and recalculate automatically when source data changes.
Use cross-sheet references to keep the same rounding rule across worksheets.
Nest ODD inside larger formulas for more complex calculations.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	Local formula calculation does not require a constant internet connection; downloading, installation, and account services do require network access
Other	You need to open WPS Spreadsheets files and have permission to edit cell formulas

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation method	Download the Windows version of WPS Office and complete setup with the installation wizard
Post-install check	Open WPS Spreadsheets, enter `=ODD(2)` in any cell, and confirm that a result is returned

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Enter the ODD function directly in WPS Spreadsheets, with formula input, cross-sheet references, nested calculations, and automatic recalculation when data changes.	Excel provides the ODD function and describes it as returning a number rounded up to the nearest odd integer.	Google Sheets provides the ODD function and documents its syntax, examples, and behavior for positive and negative values.	Notion formulas support calculations with properties, built-ins, and functions, but the official formulas overview does not present an ODD function with the same spreadsheet syntax.	Adobe Acrobat supports calculated form fields and predefined calculations for PDF forms, rather than worksheet-style ODD functions in a spreadsheet grid.
WPS Advantages	Advantage: WPS keeps odd-integer rounding inside a familiar spreadsheet cell workflow and supports cross-sheet references and nested formulas in the same workbook context.	Compared with WPS: Excel also supports ODD, and its official page focuses on syntax and usage for the function itself.	Compared with WPS: Google Sheets also supports ODD and is documented for browser-based spreadsheet use.	Compared with WPS: Notion focuses on database formulas and property-based calculations instead of a same-name ODD worksheet function.	Compared with WPS: Adobe focuses on PDF form calculations, so its calculation workflow is different from everyday spreadsheet formula entry.
Official Source	—	ODD function	ODD	Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion
If you need odd-integer rounding in a spreadsheet with direct cell references and automatic recalculation, WPS ODD is a practical fit for daily worksheet work on Windows. Microsoft Excel and Google Sheets provide similar function coverage, while Notion and Adobe focus on different calculation models such as database formulas or PDF form logic.

Use Cases

No.	Scenario	Suitable for	Main issue	Solution
1	Sales data rounding	Sales teams, operations staff	Results need to follow an odd-integer rounding rule	Use the ODD function in result cells
2	Budget estimation support	Finance staff, project managers	Intermediate values need rounding before later calculations	Nest ODD with other formulas
3	Multi-sheet data linkage	Data coordinators	Cross-sheet references still need a consistent rounding rule	Add ODD to cross-sheet formulas
4	Reusable report templates	General office users	Repeated reports need the same rounding logic	Preset ODD formulas in template cells

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Basic ODD function usage	✅	✅
Basic spreadsheet formula editing	✅	✅
Advanced PDF tools and additional value-added features	Partially limited	More features available
Cloud storage and template resources	Basic quota	Higher quota or more resources

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Everyday spreadsheet calculations and learning functions	Free	The ODD function itself has no membership restriction
Broader office work that also needs more value-added tools	WPS Premium	Suitable when you also need more templates, cloud storage, or other advanced tools

WPS membership center: Subscribe now