Related Function:

The IMSIN function returns the sine of a complex number in x + yi or x + yj text format.

Syntax

=IMSIN(inumber)

Arguments

Argument Description
inumber A complex number for which you want the sine

Note: Use the COMPLEX function to convert real and imaginary coefficients into a complex number.

Examples

  A B C D
1 Data Formula Result Notes
2 3+4i =IMSIN(A2) 3.85373803791938-27.0168132580039i Returns the sine of a complex number, 3+4i
3   =IMSIN(“3+4i”) 3.85373803791938-27.0168132580039i  
4   =IMSIN(“2-i”) 1.40311925062204+0.489056259041294i  
5   =IMSIN(COMPLEX(4,1)) -1.16780727488952-0.768162763456573i  

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if the supplied inumber argument is not recognized as a complex number
#NAME? Occurs when Analysis ToolPak add-in is not enabled

The sine of a complex number is calculated as:  

    \[   sin(x+yi) = sin(x) cosh(y) + cos(x) sinh(y)i   \]

See Wikipedia for more information on complex numbers.