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.
Leave a Reply
You must be logged in to post a comment.