RANDBETWEEN in WPS on Windows: Introduction

RANDBETWEEN in WPS is a random integer function in WPS Spreadsheets; 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

About This Feature

Overview

RANDBETWEEN is a built-in function in WPS Spreadsheets that returns a random integer between a lower bound and an upper bound. It is useful for sample generation, test data preparation, and range-based random values in spreadsheet workflows.

Core capabilities include:

Enter =RANDBETWEEN( directly in a cell and view syntax guidance.
Return a random integer within a defined range.
Work with cell references and nested formulas.
Update results when the worksheet recalculates.

Use cases include classroom demos, sample numbering, test sheets, and simulated data. This page also helps users looking for how to use the RANDBETWEEN function in WPS on Windows.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office
App version	The latest version of WPS Office is recommended
Network	No required network connection for local formula use
Other	You need access to WPS Spreadsheets and permission to edit cells

Download & Installation

Before using the RANDBETWEEN function, install WPS Office on your Windows device and open WPS Spreadsheets.

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office, create or open a spreadsheet, and enter `=RANDBETWEEN(` in a cell

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides the RANDBETWEEN function for random integers between bounds, with syntax guidance, cell references, nested calculations, and recalculation updates.	Excel provides the RANDBETWEEN function to return a random integer between numbers you specify.	Google Sheets provides the RANDBETWEEN function to return a random integer between two values, inclusive.	Notion formulas support calculations across numbers, dates, text, and lists, but its official function reference does not list a same-name RANDBETWEEN spreadsheet function.	Adobe Acrobat documentation focuses on PDF and form workflows, and its official desktop help does not describe a spreadsheet-style RANDBETWEEN function.
WPS Advantages	Advantage: You can enter the function directly in spreadsheet cells and use syntax guidance during input. Distinct: It fits naturally into cell references and nested spreadsheet formulas.	Compared with WPS: It also offers a direct spreadsheet function for random integers in a similar worksheet workflow.	Compared with WPS: It also offers the same function name and explicitly documents inclusive lower and upper bounds.	Compared with WPS: It is oriented more toward database property formulas than traditional spreadsheet cell formulas.	Compared with WPS: It is oriented more toward PDF, signing, and document workflows than spreadsheet random integer calculations.
Official Source	—	RANDBETWEEN function	RANDBETWEEN	Formula syntax & functions	Adobe Acrobat desktop help

Overall Conclusion

If you mainly need random integers inside a spreadsheet, WPS follows a familiar worksheet formula workflow and fits directly into everyday calculations. Notion is better aligned with database-style formulas, while Adobe is aimed at document and PDF workflows rather than spreadsheet functions.

Use Cases

No.	Scenario	Suitable for	Main need	How RANDBETWEEN helps
1	Random classroom selection	Teachers	Generate quick numbers	Use RANDBETWEEN to return a random index
2	Test data preparation	Testers	Simulate integer values	Fill cells with random integer results
3	Sampling IDs	Analysts	Pick values inside a range	Control the result range with lower and upper bounds
4	Event or game numbering	Office users	Create temporary random numbers	Enter the function directly in a worksheet
5	Formula practice	Students and office users	Learn nested formulas	Combine RANDBETWEEN with other formulas

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Use the RANDBETWEEN function in spreadsheets	✅	✅
Basic spreadsheet editing	✅	✅
Additional premium benefits and value-added services	Based on the current account benefits page	Includes more value-added benefits and services

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Everyday random values and basic spreadsheet work	Free	The RANDBETWEEN function itself is available for routine learning and office work
Long-term work that also needs more value-added features	WPS Premium	Suitable when you also need broader membership benefits and services

WPS membership center: Subscribe now