ODD in WPS on Windows: Introduction

ODD in WPS is a spreadsheet-style formula used in multi-dimensional tables to round a number away from zero to the nearest odd integer; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	Matches the number of Free rows in the How-to Index
Membership-related items	0	Matches the number of membership-related rows in the How-to Index

About This Feature

Overview

The ODD function in WPS helps you round a number to the nearest odd integer away from zero inside a formula field. It can be used in a multi-dimensional table when you need a stable odd-number result for record-based calculations.

Core capabilities include:

Entering ODD(number) directly in a formula field.
Combining ODD with other formulas for calculation and display logic.
Refreshing results automatically when source record values change.

This function is useful for quantity normalization, odd-number labeling, rule-based calculations, and spreadsheet workflows that require odd-number outputs.

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	No mandatory network connection is required for local formula editing; downloading, installation, and account actions require internet access
Other	You need access to a multi-dimensional table and permission to add or edit formula fields

Download & Installation

Before using the ODD function, install WPS Office on your Windows device and open a multi-dimensional table where formula fields are available.

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, enter a multi-dimensional table, and confirm that you can add a Formula field

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Uses `ODD` in a formula field inside a multi-dimensional table for record-level calculations and automatic refresh.	Excel provides `ODD(number)` to round a number up to the nearest odd integer.	Google Sheets provides `ODD(value)` to round a number up to the nearest odd integer.	Notion formulas support general numeric functions such as `round`, `ceil`, and `floor`, but no native ODD function is documented on the official formula syntax page.	Acrobat Desktop Help focuses on PDF creation, editing, and form workflows, and does not document a native spreadsheet-style ODD function equivalent.
WPS Advantages	Advantage: ODD can be used directly in a formula field for record-based table workflows. Distinct: results update automatically when source values change.	Compared with WPS: Excel has the same named function, but it is centered on worksheet cell workflows.	Compared with WPS: Sheets has the same named function and fits browser-based spreadsheet workflows.	Compared with WPS: similar logic would need to be built with general numeric functions instead of calling a native ODD function.	Compared with WPS: Acrobat does not provide a same-component spreadsheet formula entry point for ODD-style calculations.
Official Source	—	Excel ODD function	Google Sheets ODD	Notion formula syntax	Acrobat Desktop Help

Overall Conclusion

If your work centers on record-level formula fields in a multi-dimensional table, WPS offers a direct way to apply ODD in that workflow. Excel and Google Sheets also provide native ODD functions for spreadsheet cells, while Notion and Adobe are better described as adjacent tools rather than same-component matches for this formula scenario.

Use Cases

No.	Scenario	Suitable For	Main Need	How ODD Helps
1	Quantity normalization	Data organizers	Raw values do not meet odd-number rules	Use `ODD` to return an odd-number result
2	Number labeling	Operations staff	Values need to be aligned to odd-number labels	Use `ODD` to move values to the nearest odd integer
3	Pre-processing before later formulas	Table builders	Later logic depends on odd-number outputs	Standardize the value first with `ODD`
4	Dynamic record calculation	Team collaborators	Manual recalculation is repeated after data changes	Let the formula field refresh automatically
5	Training and demos	Trainers and learners	A quick example is needed to explain odd-number rounding	Enter a sample ODD formula directly in the table

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Core Writer, Spreadsheet, and Presentation apps	✅ Available	✅ Available
Basic formula usage including ODD-style formula work	✅ Available	✅ Available
Some advanced PDF editing features	Limited by feature	More advanced features available
Cloud storage and some value-added content	Basic quota	Higher quota or additional benefits

Source: WPS Office pricing page; Why pay for WPS Office

Recommendations

Scenario	Recommended Plan	Why
You only need ODD and other basic formula features in tables	Free	Core apps and common formula workflows are available
You also need broader PDF tools or more value-added office features	WPS Premium	Better suited for users who need expanded office capabilities

WPS membership center: Subscribe now

Source: WPS Office pricing page