How to use the IMSIN function in Excel

[ad_1]

The IMSIN function is an engineering function, and its purpose is to return 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.

  1. Launch Excel
  2. Create a table or use an existing table
  3. Type the formula for the IMSIN function into the cell you want to place the result
  4. 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.

How do I use the IMSIN function in Excel

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.

Source link

Alice AUSTIN

Alice AUSTIN is studying Cisco Systems Engineering. He has passion with both hardware and software and writes articles and reviews for many IT websites.

Leave a Reply

Your email address will not be published. Required fields are marked *