Table of Contents
The IMSUB function in Excel is a mathematical formula that allows users to subtract imaginary numbers. It is commonly used in complex mathematical calculations and can be accessed through the “Formulas” tab in Excel. To use the IMSUB function, users must input the two complex numbers they wish to subtract in the designated cells and then use the formula “=IMSUB(first complex number, second complex number)”. This will result in the subtraction of the two numbers and display the answer in the designated cell. The IMSUB function is a useful tool for those working with complex numbers and can greatly simplify calculations.
This article describes the formula syntax and usage of the IMSUB function in Microsoft Excel.
Description
Returns the difference of two complex numbers in x + yi or x + yj text format.
If you just want to subtract two numbers that are not complex, see Subtract numbers.
Syntax
IMSUB(inumber1, inumber2)
The IMSUB function syntax has the following arguments:
Inumber1 Required. The complex number from which to subtract inumber2.
Inumber2 Required. The complex number to subtract from inumber1.
Remarks
Use COMPLEX to convert real and imaginary coefficients into a complex number.
The difference of two complex numbers is:
See Also
Cite this article
stats writer (2024). “How do I use the IMSUB function in Excel?”. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-imsub-function-in-excel/
stats writer. "“How do I use the IMSUB function in Excel?”." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-imsub-function-in-excel/.
stats writer. "“How do I use the IMSUB function in Excel?”." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-imsub-function-in-excel/.
stats writer (2024) '“How do I use the IMSUB function in Excel?”', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-imsub-function-in-excel/.
[1] stats writer, "“How do I use the IMSUB function in Excel?”," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. “How do I use the IMSUB function in Excel?”. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.