This FAQ covers 3 common question types about RANDBETWEEN in WPS, including errors, changing results, and filling the formula across multiple cells.
FAQ
What should I do if RANDBETWEEN shows an error after I enter it?
- Check whether the function arguments are valid numbers.
- Make sure the arguments do not include text, extra spaces, or unsupported punctuation.
- If needed, clean the source values and enter the formula again.
Why does the result of RANDBETWEEN change?
- Check whether the worksheet has recalculated.
- Remember that this function returns a random integer within the specified range.
- If you need to keep the current result, copy the cell and paste it as a value.
How do I use RANDBETWEEN in multiple cells?
- Enter and confirm the formula in the first cell.
- Select the cell and drag the fill handle across the target range.
- Or copy the formula and paste it into other cells.
Glossary
| Term | Definition |
|---|---|
| RANDBETWEEN | A function that returns a random integer within a specified range. |
| bottom | The lower-bound argument in the function. |
| top | The upper-bound argument in the function. |
| Insert Function | The WPS Spreadsheet entry used to search for, select, and insert functions. |