How to write imaginary coefficient in excel 2013

Click For Summary
SUMMARY

This discussion focuses on writing imaginary coefficients in Excel 2013 using complex number functions. Users can utilize the formula "=complex(2,3)" to create complex numbers, which will return "2+3i". If this function is not available, the Analysis Toolpak must be installed. All arithmetic operations involving complex numbers must be performed using specific functions, such as "=improduct(2,A1)" for multiplication.

PREREQUISITES
  • Familiarity with Excel 2013 interface
  • Understanding of complex numbers and their representation
  • Knowledge of Excel functions and formulas
  • Ability to install and enable Excel add-ins like Analysis Toolpak
NEXT STEPS
  • Research how to install and enable the Analysis Toolpak in Excel 2013
  • Learn about additional Excel functions for complex number manipulation
  • Explore advanced applications of complex numbers in Excel
  • Investigate other mathematical functions available in Excel for engineering calculations
USEFUL FOR

This discussion is beneficial for Excel users, mathematicians, engineers, and anyone working with complex numbers in their calculations.

fatinnn
Messages
1
Reaction score
0
i have equation:
ur=2.c(1-v2)/(w.d.i)(1+v2)
i don't know how to write imaginary coefficient in excel.please help:(
 
Last edited:
Technology news on Phys.org
Excel has functions for manipulating complex numbers. A Google search for "excel complex numbers" gave me this as the first hit:

http://mysite.avemaria.edu/jcdaly/Tutorials/ComplexExcel/ComplexNos.html

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)".
 
  • Like
Likes   Reactions: FactChecker

Similar threads

How to disable access to old data with newest version of software?
  • · Replies 8 ·
Replies
8
Views
1K
C/C++ Is Jamie King's Approach to Operator Overloading in C++ the Best Practice?
  • · Replies 53 ·
2
Replies
53
Views
5K
A little help in programming docx to Excel
  • · Replies 6 ·
Replies
6
Views
2K
Absorption coefficient and Linear Optical Susceptibility
  • · Replies 2 ·
Replies
2
Views
3K
Python Interesting article how to use Pandas with Excel sheets
  • · Replies 1 ·
Replies
1
Views
2K
Python Re: Python’s Sympy Module and the Cayley-Hamilton Theorem
  • · Replies 3 ·
Replies
3
Views
2K
How to concatenate columns in Excel
  • · Replies 2 ·
Replies
2
Views
1K
Find the polar form of a complex number
  • · Replies 5 ·
Replies
5
Views
3K
Fundamental matrix for complex linear DE system
  • · Replies 4 ·
Replies
4
Views
2K
Excel automatically highlighting row and column
  • · Replies 4 ·
Replies
4
Views
3K