COMPLEX in WPS on Windows FAQ

Q: Why does an error appear after I enter COMPLEX?

Check whether the formula starts with = . Check whether all parentheses are closed. Check whether the arguments use the correct separators. Re-enter the arguments with the on-screen function hint.

Q: How can I view the parameter hint for the COMPLEX function?

Select the target cell. Type =COMPLEX( . Watch the formula area for the syntax hint. Enter the arguments in order and confirm the formula.

When using COMPLEX, the most common issues fall into 3 groups: syntax errors, parameter understanding, and result checking; this section answers 3 common questions.

FAQ

Why does an error appear after I enter COMPLEX?

Check whether the formula starts with =.
Check whether all parentheses are closed.
Check whether the arguments use the correct separators.
Re-enter the arguments with the on-screen function hint.

How can I view the parameter hint for the COMPLEX function?

Select the target cell.
Type =COMPLEX(.
Watch the formula area for the syntax hint.
Enter the arguments in order and confirm the formula.

What should I do if the result does not match my expectation?

Check whether the referenced cells for the real and imaginary parts are correct.
Confirm that the source cells contain values that can participate in calculation.
Check whether a parenthesis or argument is missing in a nested formula.
Press Enter again after correction to recalculate the result.

Glossary

Term	Definition
COMPLEX	A function that combines a real part and an imaginary part into a complex-number text result.
Real part	The numeric part of a complex number that does not include the imaginary unit.
Imaginary part	The numeric part associated with the imaginary unit in a complex number.
Nested formula	A formula that calls another function inside the current formula.