WPS Features
Resources
Free AI Tools
Docs Center

How to Use the RANDARRAY Function in WPS on Windows

Last updated:July 13, 2026

Use RANDARRAY through 3 how-to topics, with 3 available without membership and 0 membership-related items; choose a topic from the index and follow the entry path and steps.

How-to Index

No.TopicMembership Requirement
11. Insert RANDARRAY from the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. View syntax and parameter detailsFree

How-to Guide

1. Insert RANDARRAY from the Insert Function dialog

Entry path: Formula 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 Formula tab.
  3. Search for RANDARRAY in the dialog box.
  4. Select the function and click OK.
  5. Enter the required parameters in the function arguments dialog.
  6. Click OK to finish inserting the function.

Success Criteria

  • The target cell contains the RANDARRAY function.
  • You can continue editing parameters or confirm the result with Enter.

Tips While Using

  • A misspelled function name may prevent the function from appearing in search.
  • Make sure a worksheet is already open in WPS Spreadsheet.

2. Type the formula directly in a cell

Entry path: Cell → Formula bar

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

Success Criteria

  • The worksheet returns a random number array.
  • You can edit the formula again and recalculate with different parameters.

Tips While Using

  • Incomplete separators or parentheses can cause a formula error.
  • The spill area needs enough empty space to display the array result.

3. View syntax and parameter details

Entry path: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Enter RANDARRAY in the search box.
  3. Select the function and review the syntax: RANDARRAY([rows], [columns], [min], [max], [whole_number]).
  4. Click the related help link to view more details.

Success Criteria

  • The function name, syntax, and parameter area are visible.
  • You can continue by inserting the function or adjusting its parameters.

Tips While Using

  • If the wrong function is selected first, the displayed description will not match RANDARRAY.
  • Opening an online help page requires internet access.