The IMSIN function is an engineering function that returns the sine of a complex number. The formula for the IMSIN function is IMSIN (Inumber). The syntax for the IMCOS function is below.
Inumber: A complex number for which you want the sine. It is required.
What is a complex number?
A complex number consists of two parts, a real number and an imaginary number, for example, a + bi where a and b is a real number and i is a symbol, an imaginary number.
How do I use the IMSIN function in Excel
It is not a complicated function to use; it is easy as long you know its formula. In this tutorial, we will discuss how to use the IMSIN function in Excel. To use the IMSIN function, follow the steps below.
- Launch Excel
- Create a table or use an existing table
- Type the formula for the IMSIN function into the cell you want to place the result
- Press Enter to see the result
Launch Microsoft Excel.
Create a table or use an existing table.
Type the function =IMSIN(A2) into the cell you want to place the result.
Cell A2 has the complex number you want to sine.
Then press the Enter key to see the result.
Drag the fill handle down to see the other results.
There are two other methods to use the IMSIN function in Excel.
Method one is to click the fx button on the top left of the excel worksheet.
An Insert Function dialog box will appear.
Inside the dialog box in the section, Select a Category, select Engineering from the list box.
In the section Select a Function, choose the IMSIN function from the list.
Then click OK.
A Function Arguments dialog box will open.
In the Inumber section, input into the entry box the cell A2.
Then click OK.
Method two is to click the Formulas tab and click the More Functions button in the Function Library group.
Hover the cursor over Engineering and select the IMSIN function from the list.
A Function Arguments dialog box will appear.
We hope this tutorial helps you understand how to use the IMSIN function in Excel.
Now read: How to use the DISC function in Excel.
