For jobs of all kinds where you want to make quick calculations and record information, Excel is used. It is the program and tool par excellence to do this type of task as quickly, agilely and easily as possible.
With it, it is possible to add and subtract complex numbers with the IM.SUM and IM.SUSTR Engineering functions. They are a kind of simplification of the formulas that are traditionally used for these specific operations.
Learn with us about the use of the IM.SUM and IM.SUSTR functions in Excel and their most relevant fundamentals.
Applications and use of the IM.SUM function in Excel
When you want to sum complex numbers in Excel, you must use the IM.SUM function in the program. It is a tool to add various complex numbers, used in trigonometry, specifically in the area of ​​Engineering.
It uses the text format x + yi or x + yj, a feature similar to other complex number functions. It uses several specific arguments, which are represented as Inumber1, Inumber2, and so on, depending on the factors to be added.
The maximum number of complex figures that can be added with this function reaches 255, being the Inumber1 mandatory. All the others are optional, and it depends on the result you want to achieve when working with this trigonometry operation.
In case there is no complex number but there are real and imaginary numbers, they can be changed. It is possible using the Excel function called COMPLEX, obtaining with it the complex numbers for the addition operation.
Its representation in the formula bar is =IM.SUM, followed by the values ​​to be added, placed between parentheses and quotation marks. Always remember that this is a simplified representation of a common formula that has more factors to calculate.
In addition to this excellent function, you can also use the ISTEXT and ISNOTEXT functions in Excel to check values. Those values ​​are written, which these functions will be able to check if they are true or false when used correctly.
It is also possible to make dynamic references that allow better organization of the data that is owned and managed in the sheet. It is a very useful tool, which requires a series of specific steps so that the result is quite beneficial.
Now you can use the IM.SUM function to add complex numbers very easily within Excel.
Applications and use of the IMSUSTR function in Excel
As the function of IM.SUM is to perform addition operations, the function of IM.SUSTR is used to do subtractions. It also works with complex numbers, which categorizes it as a trigonometry function within Excel formulas.
Its text format is also x + yi or x + yj, which is essential for these functions. In this case, it uses two arguments that are absolutely required, represented as Inumber1 and Inumber2 to do the corresponding subtraction.
These factors must be complex numbers for the function to interpret them correctly for the calculation. If you don’t have these numbers, you can change the imaginary and real numbers in them with the COMPLEX function.
Like many functions belonging to the Engineering list, it has a common formula with more factors and elements to calculate. Therefore, the IMSUSTR function is a very simplified and direct version of this known formula.
In the Excel formula bar you have to write =IM.SUSTR with the values ​​that are going to be subtracted. They have to be placed between parentheses and quotes, so that the program can fully interpret them and perform the operation.
In addition to this possibility, the blank spaces that are inside the Excel document can be easily removed. It is one of the features that allow better organization of the data and information contained in a document.
We invite you to continue learning with our Look how it’s done articles, consulting the varied topics that are available. We know about the solutions to the most common problems and doubts on the subject of virtual tools and social networks.
