When using IMSUB, the most common questions involve errors, unexpected results, and filling formulas across cells; this FAQ includes 3 common questions and a glossary.
FAQ
What should I do if IMSUB returns an error value?
- Check whether each parameter uses a recognizable complex-number format.
- Make sure there are no extra spaces or mismatched characters in the input.
- Re-enter the parameters from the Insert Function dialog so you can review them one by one.
Why does the IMSUB result look different from what I expected?
- Check whether the two parameters are in the correct order.
- Confirm that the referenced cells contain the intended complex-number values.
- Review the function syntax and then enter the formula again if needed.
How can I use IMSUB in multiple cells?
- Enter the IMSUB formula in the first target cell.
- Drag the fill handle to copy the formula to the required range.
- Check whether the copied cell references match your expected result.
Glossary
| Term | Definition |
|---|---|
| IMSUB | A function name used to return the difference between two complex numbers. |
| Complex number | A number made up of a real part and an imaginary part, such as 3+4i. |
| Function argument | A value or cell reference passed into a function to determine the result. |