WPS Features
Resources
Free AI Tools
Docs Center

How to Use the RANDBETWEEN Function in WPS on Windows

Last updated:July 13, 2026

This how-to guide covers 3 operation topics for using RANDBETWEEN in WPS Spreadsheet; all 3 are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Insert the function from the Insert Function dialog boxFree
22. Type the formula directly in a cellFree
33. Review the syntax and parameter detailsFree

How-to Guide

1. Insert the function from the Insert Function dialog box

Entry point: Formulas tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
  3. Search for RANDBETWEEN in the Insert Function dialog box.
  4. Select the function and click OK.
  5. Enter each parameter in the Function Arguments dialog box.
  6. Click OK to finish inserting the function.

Success Criteria

  • The current cell contains the RANDBETWEEN function.
  • After the parameters are entered, the cell returns a random integer within the specified range.
  • You can continue editing, copying, or filling the formula down.

Tips While Using

  • Searching with the uppercase function name can make the function easier to find.
  • Make sure the parameters define a valid numeric range.

2. Type the formula directly in a cell

Entry point: Worksheet cell → Formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =RANDBETWEEN(...) directly in the cell or the formula bar.
  3. Press Enter to confirm.
  4. If you want to review the parameter hint, type =RANDBETWEEN( and then press F1.

Success Criteria

  • The cell shows a calculated result instead of plain text.
  • The full formula is visible in the formula bar.
  • Pressing Enter returns an integer within the target range.

Tips While Using

  • Use an English comma to separate parameters.
  • If the cell is formatted as text, change it to a general or number format before entering the formula.

3. Review the syntax and parameter details

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Enter RANDBETWEEN in the search box.
  3. Select the function and review the syntax: RANDBETWEEN(bottom, top).
  4. Open the related help entry if you need more details.

Success Criteria

  • You can see the function name, syntax structure, and parameter positions.
  • You can distinguish the meanings of bottom and top.
  • You can return to the worksheet and complete the formula entry.

Tips While Using

  • bottom is the lower bound of the range.
  • top is the upper bound of the range.
  • If the values are not valid numbers, the result may not work as expected.