Math: Excel: entering complex numbers

Tutoring differential equations or complex variables, you might use a spreadsheet sometimes. The tutor gives a hint about entering complex numbers on Excel.

Excel does, indeed, handle complex numbers. Formulas for them are among the Engineering ones.

Apparently, to enter a complex number, quotes are needed around it. For instance, to obtain the product of 6-i and 2+i, you would enter

=improduct(“6-i”,”2+i”)

Hopefully you receive the answer 13+4i.

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Tagged with:

Leave a Reply