Since the impedance is a complex number, I use the COMPLEX function in Excel. What is the current in the circuit?Īs you’ve seen, we can use Excel to handle the complex number calculations.įirst, I enter the input values for voltage and impedance. Suppose we have a circuit with a voltage of 12 volts and an impedance (Z) of 5+10j ohms. Let’s take a look at one of the calculations that Excel’s complex number functions enable: an RLC circuit. These functions enable many different engineering calculations in Excel, such as analyzing current in an RLC circuit or describing the motion of a damped harmonic oscillator. IMEXP, IMLN, IMLOG10, IMLOG2: Return the exponential, natural log, log (base 10) and log (base 2) of a complex number.IMSIN, IMCOS, IMTAN, etc.: Return the sine, cosine, tangent, etc.
#How to angle text in excel how to#
How to Enable Complex Number Calculations in Excel How to Enable Complex Number Calculations in Excel.