RANDBETWEEN in WPS on Windows FAQ

Last updated:July 20, 2026

Common questions about RANDBETWEEN usually involve formula syntax, changing results, parameter setup, and saving a fixed value. This FAQ covers 4 common issues.

FAQ

Why does RANDBETWEEN show an error after I enter it?

  1. Check whether the formula starts with =.
  2. Check the function spelling, parentheses, and argument separator.
  3. Make sure the lower and upper bounds are valid numbers or valid cell references.

Why does the RANDBETWEEN result change?

  1. RANDBETWEEN is a random function that updates when the worksheet recalculates.
  2. The result may refresh after worksheet recalculation or related data changes.
  3. If you need a fixed result, copy the cell and paste it as a value.

Can I use cell references as the lower and upper bounds?

  1. Yes. You can use a formula such as =RANDBETWEEN(A2,B2).
  2. Make sure the referenced cells contain valid numbers.
  3. After changing the referenced values, check whether the result still stays in range.

How do I keep the current random result from changing?

  1. Select the cell that contains the RANDBETWEEN result.
  2. Copy the cell.
  3. Use Paste Special or paste as values to keep the current result.

Glossary

TermDefinition
RANDBETWEENA spreadsheet function that returns a random integer between a lower bound and an upper bound.
Lower and upper boundsThe minimum and maximum values that define the random result range.
RecalculationThe process of running worksheet formulas again, which can update random function results.
Cell referenceA way to use a cell address as a formula argument or calculation input.