Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

How to write imaginary coefficient in excel 2013

  1. Nov 20, 2015 #1
    i have equation:
    i dont know how to write imaginary coefficient in excel.please help:(
    Last edited: Nov 20, 2015
  2. jcsd
  3. Nov 21, 2015 #2


    User Avatar

    Staff: Mentor

    Excel has functions for manipulating complex numbers. A Google search for "excel complex numbers" gave me this as the first hit:


    To see if you have these functions, enter the formula "=complex(2,3)" in a cell. You should get "2+3i". If you get an error, you may have to install the Analysis Toolpak. I remember having to do that in an older version of Excel. My current version (2011 for Mac OS) apparently has it built in.

    You have to do all arithmetic using functions. For example, if you have 2+3i in cell A1, you can't use the formula "=2*A1" to multiply it by 2. You have to use "=improduct(2,A1)".
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook