Author: Oscar Cronquist Article last updated on November 16, 2022

How to use the IMSIN function

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

The letter j is used in electrical engineering to distinguish between the imaginary value and the electric current.

1. IMSIN Function Syntax

IMSIN(inumber)

Back to top

2. IMSIN Function Arguments

inumber Required. A complex number in x+yi or x+yj text format.

Back to top

3. IMSIN function example

How to use the IMSIN function

The image above demonstrates a formula in cell D3 that calculates the sine of a complex number specified in cell B3.

Formula in cell D3:

=IMSIN(B3)

3.1 Explaining formula

Step 1 - Populate arguments

IMSIN(inumber)

becomes

IMSIN(B3)

Step 2 - Evaluate the IMSIN function

IMSIN(B3)

becomes

IMSIN("1+2i")

and returns

3.16577851321617+1.95960104142161i

Back to top