When using COMPLEX, the most common issues fall into 3 groups: input errors, unexpected results, and filling the formula across cells.
FAQ
What should I do if COMPLEX returns #VALUE!?
- Check whether the parameter data types are correct and make sure numeric parameters do not contain extra spaces or text.
- Confirm that parameters are separated with English commas rather than Chinese commas.
- If the original data contains spaces, clean it with
CLEANorTRIMand then enter the formula again.
What should I do if the COMPLEX result is not what I expected?
- Check whether the referenced cells or ranges are correct.
- Confirm that the related cells contain numeric values that can participate in calculation.
- Review the entered parameters again and verify the calculation step by step if needed.
How can I use COMPLEX in multiple cells?
- Enter the COMPLEX formula in the first target cell.
- Select that cell, drag the fill handle at the lower-right corner across the target range, or copy and paste the formula into other cells.
- After filling the formula, confirm that relative and absolute references behave as expected.
Glossary
| Term | Definition |
|---|---|
| COMPLEX | A function name in WPS Spreadsheets that builds a complex-number expression from the provided parameters. |
| Insert Function | A function-entry command that lets you search for a function name and insert it by filling in parameters. |
| Formula bar | The area that displays and edits the content of the current cell, including formulas. |
| Fill handle | The small square at the lower-right corner of a selected cell that can extend formulas or copy results. |