DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How to use the IMSIN Function in Excel office 365?

#tousetheimsinfunctio #excel #excelfunctions

In this tutorial, we will guide you on how to use the IMSIN Function In Excel Office 365. Let’s get them below!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

IMSIN Function

This function returns the complex Sine of the complex number (inumber) having both real & imaginary parts.

IMSIN Function Syntax 

=IMSIN (inumber)
Enter fullscreen mode Exit fullscreen mode

Syntax Explanation:

inumber: complex number on which common logarithm is performed.

Example1

  • Firstly, you have to create a sample data with input complex number.

Sample data

  • Then, you need to get the complex Sine of the input complex number (inumber).
  • Now, you have to use the following formula ** to calculate **IMSIN Function. 
=IMSIN (A2)
Enter fullscreen mode Exit fullscreen mode

A2: complex number (inumber) provided as a cell reference.

IMSIN Function

  • After that, the formula ** returns the **complex Sine of the complex number using the following formulation. 
Sin (4 + 3i) = Sin (4) * Cosh (3) + i Cos (4) * Sinh (3)
Enter fullscreen mode Exit fullscreen mode
  • At last, you have to copy the formula ** to the other remaining cells using **Ctrl + D shortcut key.

Copy to other cells

Example2

  • Firstly, you have to create a sample data with input complex number.

Sample data

  • Then, you need to get the complex Sine of the input complex number (inumber).
  • Now, you have to use the following formula ** to calculate **IMSIN Function. 
=IMSIN (A2)
Enter fullscreen mode Exit fullscreen mode

A2: complex number (inumber) provided as a cell reference.

IMSIN Function

  • After that, the formula ** returns the **complex Sine of the complex number using the following formulation. 
Sin (4 + 3i) = Sin (4) * Cosh (3) + i Cos (4) * Sinh (3)
Enter fullscreen mode Exit fullscreen mode
  • At last, you have to copy the formula ** to the other remaining cells using **Ctrl + D shortcut key.

Copy to other cells

Check this too:

Wrap-Up

Hope you understood how to use the IMSIN Function In Excel Office 365. Please feel free to state your query or feedback for the above article. Thank you so much for Reading!! To learn more, check out Geek Excel!! *and Excel Formulas *!!

Read Ahead:

Top comments (0)