IMSIN(inumber)
=IMSIN("4+3i")
The function returns the sine of a complex number. For example, the formula returns the sine of 4+3i, which is -3.8517.
=IMSIN(PI()/6)
The function can also be used to calculate the sine of angles in radians. For example, the formula returns the sine of 30°, which is 0.5.
=IMSIN(SQRT(-1))
The function can be used in combination with other functions. For example, the formula returns the sine of the imaginary number i, which is 1.22465e-16.
=IMSIN(A1:A5)
The function can also be used to calculate the sine of a range of numbers. For example, this formula, where A1 to A5 contain the values 0, PI()/2, PI(), 3*PI()/2, and 2*PI(), respectively, returns an array of the sine values of those numbers, {0, 1, 0, -1, 0}.
The IMSIN function calculates the sine of a complex number, taking the number formatted as x + yi or x + yj as input and returning a complex number as the result.