MAKEARRAY in WPS on Windows FAQ

Last updated:July 17, 2026

When using MAKEARRAY, the most common questions focus on formula entry, parameter input, unexpected results, and recalculation behavior, covering 4 frequent question types.

FAQ

What should I do if MAKEARRAY shows an error after I enter it?

  1. Check whether the formula starts with =.
  2. Make sure the parentheses are paired correctly and the separators are correct.
  3. Review the syntax prompt to confirm that the parameter types and count match the function requirements.
  4. Press Enter again after making corrections.

How can I view the parameter guidance for MAKEARRAY?

  1. Select the target cell and type =MAKEARRAY(.
  2. Review the syntax prompt that appears automatically.
  3. Check the parameter order, examples, and input pattern in the prompt.
  4. Continue the formula based on your calculation goal.

What should I do if the MAKEARRAY result is not correct?

  1. Check whether the referenced cells use the correct data format.
  2. Confirm that there is no circular reference or incorrect cross-worksheet reference.
  3. Review the logic order of any nested functions.
  4. Change the source data and check the result again.

Why does the result not match what I expected after I change the data?

  1. Check whether the referenced data range is correct.
  2. Confirm that you changed the cells actually used by the formula.
  3. Look for text-formatted numbers or blank values that may affect the calculation.
  4. If needed, edit the formula again and confirm the parameter settings.

Glossary

TermDefinition
MAKEARRAYA function name in Smart Spreadsheet used to generate array results based on a defined rule.
Syntax promptThe parameter guidance and examples shown while entering a function.
Nested formulaA formula structure that combines multiple functions so one result can be used inside another function.
Cross-worksheet referenceA formula reference that uses data from another worksheet in the current workbook.