FLOOR in WPS on Windows: Introduction

WPS FLOOR is a common formula function in multidimensional tables for rounding a number down to the nearest specified multiple; 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 index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

The FLOOR function in WPS multidimensional tables rounds a number down to the nearest specified multiple in a formula field. It is useful for standardized calculations, tiered values, and rule-based data processing.

Core capabilities include:

Using the FLOOR function in a formula field for round-down calculations.
Filling in the function parameters and saving the result in the formula editor.
Combining FLOOR with other functions for more advanced data processing.

This function fits scenarios such as amount banding, quantity rounding, standardized reporting, and automatic calculation after imported data changes.

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 editing and calculation do not require a constant network connection; internet access is needed for downloads or online help
Other	You need access to a workspace that contains a multidimensional table and permission to edit formula fields

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office, enter a multidimensional 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	Supports using FLOOR in a multidimensional table formula field to round results down and continue calculations with other functions.	Excel provides `FLOOR(number, significance)` to round a number down to the nearest specified multiple.	Google Sheets provides `FLOOR(value, [factor])` to round a number down to the nearest multiple of a specified factor.	Notion formulas support `floor(number)`, which returns the largest integer less than or equal to the input and fits database formula scenarios.	Acrobat documentation provides JavaScript references for numeric processing in PDF forms, but not a spreadsheet-style formula function workflow.
WPS Advantages	Advantage: You can apply round-down logic directly in a multidimensional table formula field and keep results updated with record data. Distinct: It fits record-level calculations and field-based data management.	Compared with WPS: Excel FLOOR is designed for traditional spreadsheet cell formulas rather than record-based multidimensional fields.	Compared with WPS: Sheets focuses on online spreadsheet formulas, while multidimensional record management follows a different workflow.	Compared with WPS: Notion supports integer floor logic, but its official formula syntax describes a database formula language rather than a same-name two-parameter spreadsheet function for specified multiples.	Compared with WPS: Adobe mainly focuses on PDF and JavaScript processing, without a directly comparable multidimensional table formula field experience.
Official Source	—	Excel FLOOR function	Google Sheets FLOOR	Notion formula syntax	Acrobat JavaScript API Reference

Overall Conclusion
WPS FLOOR works well for record-level round-down calculations inside multidimensional tables, especially when results need to stay in a dedicated field. Excel and Google Sheets provide well-documented spreadsheet function behavior, Notion is more database-formula oriented, and Adobe is mainly centered on PDF scripting.

Use Cases

No.	Scenario	Suitable For	Main Pain Point	How FLOOR Helps
1	Rounding amounts down by denomination	Finance and operations staff	Amounts need to follow a fixed denomination rule	Use FLOOR in a formula field to generate standardized results
2	Quantity banding	Data organizers	Raw values include decimals or irregular numbers	Use FLOOR to normalize values to a specified multiple
3	Automatic calculation after import	Table maintainers	Imported data should refresh results automatically	Save the formula field so the table recalculates results
4	Combined formula logic	Advanced users	One function alone is not enough for business rules	Combine FLOOR with functions such as IF
5	Consistent rules across many records	Team collaborators	Multiple records need the same rounding rule	Reuse one FLOOR formula in the same field

Membership & Benefits

Membership details for FLOOR are straightforward: the function itself is available without membership, while Premium plans are more relevant when you also need expanded PDF tools, cloud storage, or broader advanced features.

Free vs WPS Premium

Capability	Free	WPS Premium
Basic FLOOR function usage	✅ Available	✅ Available
Multidimensional table formula calculation	✅ Available	✅ Available
Expanded PDF tools and broader advanced benefits	Limited in some areas	More advanced capabilities included
Cloud storage	1 GB	20 GB
Template and advanced feature range	Basic range	Broader advanced range

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
You only need FLOOR and basic formula work in multidimensional tables	Free	Basic FLOOR usage does not require membership and fits everyday data cleanup
You also need broader office, PDF, or cloud storage benefits	WPS Premium	A better fit for users who need expanded productivity features and more storage

WPS membership center: Subscribe now