MAKEARRAY is a built-in function in WPS Sheets on Windows for generating array results in a single formula; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | All topics in this guide are available directly |
About This Feature
Overview
MAKEARRAY is a built-in function in WPS Sheets for spreadsheet formula workflows on Windows. It is useful when you want to generate array results with one formula and complete batch-style calculations through function arguments.
Core tasks in this guide include:
- Insert MAKEARRAY from the Insert Function dialog.
- Type
=MAKEARRAY(...)directly in a cell or in the formula bar. - Review syntax and argument details from the function help entry.
This feature is useful for learning a new function, building array formulas, and checking argument usage while working in a spreadsheet.
System Requirements
| Item | Requirement |
|---|---|
| OS | A Windows device that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office so newer function support and help entries are available |
| Network | A network connection is not required for local formula entry, but it is needed for online help pages or downloading the app |
| Other | You need to be able to open WPS Sheets and edit worksheet cells |
Download & Installation
| Item | Notes |
|---|---|
| Official Download | WPS Office Free Download |
| Post-install Check | Open WPS Sheets, go to the Formulas tab, and confirm that entries such as Insert Function are available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | In WPS Sheets, MAKEARRAY can be used through Insert Function, direct formula entry, and the function help entry. | Word supports calculations in table cells through the Formula command, but this is mainly for document table calculations rather than a spreadsheet function environment. | Google Sheets is an online spreadsheet that supports formulas for calculations, analysis, and collaborative data work. | Notion formulas perform calculations with database properties, built-ins, and functions, mainly inside database properties rather than worksheet cells. | Acrobat supports calculated PDF form fields, including predefined calculations and custom calculation behavior for form fields. |
| WPS Advantages | Advantage: better aligned with spreadsheet cell formula entry on desktop; Distinct: users can learn, insert, and adjust the function from the dialog box, formula bar, and help entry in one workflow. | Compared with WPS: Word formula features focus on table fields inside documents, not a spreadsheet-style worksheet formula workflow. | Compared with WPS: Google Sheets emphasizes online collaboration and cloud-based analysis, while WPS follows a desktop spreadsheet formula workflow. | Compared with WPS: Notion formulas are tied to database properties and outputs, not a traditional worksheet cell editing interface. | Compared with WPS: Acrobat calculations are designed for PDF form fields, not worksheet-based spreadsheet formulas. |
| Official Source | — | Use a formula in a Word table | Google Sheets product page | Intro to formulas | Configure form field calculations in Acrobat |
Overall Conclusion
If your main task is entering and adjusting formulas in a desktop spreadsheet, WPS provides a more direct path for function entry and review. The other products also support calculations, but they focus on document tables, cloud collaboration databases, or PDF forms rather than the same worksheet formula scenario.
Use Cases
| # | Scenario | Target Users | Core Pain Point | Solution |
|---|---|---|---|---|
| 1 | Learn a new function | New users and office users | The function entry point and arguments are not clear | Search for MAKEARRAY in Insert Function and review the argument dialog |
| 2 | Enter a formula quickly | Users who work with spreadsheets often | They want to type the formula directly in the worksheet | Enter =MAKEARRAY(...) in a cell or in the formula bar |
| 3 | Check syntax details | Users who need to verify arguments | They do not remember the syntax or help entry | Open the function window to review syntax and argument details |
Membership & Benefits
Free vs WPS Premium
| Feature | Free User | WPS Member |
|---|---|---|
| MAKEARRAY function entry and use | Available | Available |
| Basic PDF features | Available | Available with a broader feature range |
| Cloud storage | 1 GB | 20 GB shown on some plan pages |
| Template downloads | Limited | Broader access |
Source: WPS Office pricing page
Recommendations
| Use Case | Recommended Plan | Reason |
|---|---|---|
| Spreadsheet formulas and everyday editing | Free version | MAKEARRAY itself is available directly and works well for routine formula learning and entry |
| More cloud storage, templates, or broader office features | WPS membership | A better fit for users who need storage, templates, and additional office capabilities on an ongoing basis |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page