How to Use the RANDBETWEEN Function in WPS on Windows

Last updated:July 20, 2026

Use RANDBETWEEN through 4 topics: entering the function, setting bounds, using cell references, and refreshing results. All 4 topics are available without membership, and 0 are membership-related.

How-to Index

No.TopicMembership
11. Enter the RANDBETWEEN functionFree
22. Set lower and upper bounds and return a resultFree
33. Use the function with cell referencesFree
44. Refresh random results through recalculationFree

How-to Guide

1. Enter the RANDBETWEEN function

Feature access: Formulas tab → formula bar

  1. Open WPS Spreadsheets and go to the worksheet where you want the result.
  2. Select the target cell.
  3. Type = to start a formula.
  4. Type RANDBETWEEN( to view syntax guidance.

Success Criteria

  • The cell or formula bar shows =RANDBETWEEN(.
  • You can continue entering the lower and upper bounds.

Tips While Using

  • If you do not start with =, the entry is treated as plain text.

2. Set lower and upper bounds and return a result

Feature access: Current cell or formula bar

  1. Enter the lower bound after RANDBETWEEN(.
  2. Type a comma to separate the arguments.
  3. Enter the upper bound and close the parenthesis.
  4. Press Enter to confirm the formula.

Success Criteria

  • The cell shows an integer result within the specified range.
  • You can continue editing the range or copy the formula.

Tips While Using

  • Missing parentheses or incorrect separators can cause a formula error.

3. Use the function with cell references

Feature access: Current cell or formula bar

  1. Enter a formula such as =RANDBETWEEN(A2,B2).
  2. Replace the references with the cells that store your lower and upper bounds.
  3. Press Enter to confirm.
  4. Check whether the result stays within the referenced range.

Success Criteria

  • The result changes with the referenced lower and upper bound cells.
  • You can fill the formula down to more rows.

Tips While Using

  • If the referenced cells are not numeric, the result may not work as expected.

4. Refresh random results through recalculation

Feature access: A worksheet that already contains RANDBETWEEN formulas

  1. Make sure the worksheet already contains a RANDBETWEEN formula.
  2. Change related data or trigger recalculation when needed.
  3. Check whether the random result updates.
  4. If you want to keep the current value, copy and paste it as a value.

Success Criteria

  • The random integer result changes after recalculation.
  • You can continue saving, copying, or converting the result to a fixed value.

Tips While Using

  • If you need a permanent record, paste the result as a value before later edits.