IMSUM and IMSUB functions - Sum and complex differences in Excel
The following article details the meaning and usage of IMSUM and IMSUB functions - Sum and difference of two complex numbers in excel.
1. IMSUM function
Description: The function performs the sum of 2 or more complex numbers in excel.
Syntax: = IMSUM (inumber1, inumber2, .) .
Inside:
- inumber1, inumber2, .: are complex numbers to be summed up, up to 255 complex numbers, at least have 2 complex numbers.
Attention:
- The sum of 2 complex numbers is calculated as follows:
For example:
Sum the following complex numbers:
In the first and second complex numbers, enter the following formula: IMSUM (B6, D6) -> Press Enter -> the sum of 2 and 1 complex numbers is:
In the cell to sum of 3 complex numbers, enter the formula: IMSUM (B6, C6, D6) -> The sum of 3 complex numbers is:
2. IMSUB function
Description: The function returns the difference of two complex numbers of the format x + yi or x + yj.
Syntax: IMSUB (inumber1, inumber2) .
Inside:
- inumber1 : The first complex number, is the subtracted number
- inumber2 : is the second complex number, minus number.
Attention:
- IMSUB function has only 2 parameters and cannot subtract 3 or more complex numbers.
- The difference is calculated based on the formula:
For example:
Calculate the difference of 2 complex numbers 1 and 2, 2 and 3.
In the cell to calculate difference of the 1st and 2nd complex numbers enter the formula: IMSUB (B6, C6) -> Press Enter -> the 1st and 2nd complex differences are:
In the cell you need to calculate the difference of the 2nd and 3rd complex numbers enter the formula: IMSUB (C6, D6) -> Press Enter -> the 2nd and 3rd complex differences are:
The above is a detailed guide on how to use and specific examples of IMSUM and IMSUB functions that hope to help you.
Good luck!
You should read it
- Summary of trigonometric functions in Excel
- How to add computers to Excel
- How to fix the SUM function doesn't add up in Excel
- Complete financial functions in Excel you should know
- MS Excel - Lesson 5: Excel formulas and functions
- Compare ROUND, ROUNDUP and ROUNDDOWN rounding functions in Excel
- Summary of information functions in Excel
- Comparison functions in Excel - How to use comparison functions and examples using comparison functions
- Date time functions in Excel
- 10 EXCEL functions that ACCOUNTERS often use
- MS Excel 2003 - Lesson 8: Excel Macro - Automate complex tasks
- What is a CSV file? Differences between CSV and Excel files
Maybe you are interested
Are complex passwords 'out of date'?
Warning: DDoS attacks are becoming more dangerous both in scale and complexity
Build a space telescope complex to serve the mission of finding aliens
Excel continues to be used as a lure for online fraud with complex mechanisms
Learn the basics of supercomputers, complex and powerful machines
Discover the Samsung Galaxy Note10 + 5G interior, complex and difficult to repair