![]() The formula returns the complex Sine of the complex number using the following formulation. The IMSIN function returns the complex Sine of the complex number (inumber) having both real & imaginary part.Ī2 : complex number (inumber) provided as cell reference.Īs you can see the complex number having real_num = 4 & imaginary part = 3. Here X & Y are the coefficients of the real & imaginary part of the complex number (inumber). Sin (X + iY) = Sin (X) * Cosh (Y) + i Cos (X) * Sinh (Y) The coefficient of iota ( i) which is 5 is called as imaginary part and the other part 2 is called the real part of the complex number.Ĭomplex number (inumber) is written in the X iY format.Ĭomplex Sine of a complex number (X + iY) is given by This here equation is a Complex number (inumber) having 2 different parts called real part & imaginary part For calculation of some term like shown below. Square root of negative number is not possible, so for calculation purpose, ?-1 is named as imaginary and call it iota ( i or j). In mathematics we call it the coefficient of i or j (iota). In this article, we will learn about how to use the IMSIN function in Excel.ĬOMPLEX number (inumber) in excel derived for mathematical number having real and imaginary coefficients.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |