I. Intro
The IMCOS function returns the cosine of a complex number in the x + yi or x + yj format.
II. About the function
- Formula: =IMCOS(value)
- Parameters:
- value (required): The complex number that you want the cosine of.
- Example: =IMCOS("2+3i")
- Note: If value is a logic value, then IMCOS will return a #VALUE! error value.
III. Steps
Use the IMCOS function
- Select a cell and click Formulas on the toolbar, then select Engineering > IMCOS. You can also directly enter =IMCOS in a cell.
- Enter the parameters in the cell. For example: =IMCOS(A2).
- Press Enter to get the result, which is -3.724545504915322-0.511822569987384i in this example.
- Drag the + icon in the lower-right corner of the cell to apply the formula to other cells.
250px|700px|reset
Delete the IMCOS function
Select the cell with the IMCOS function and press Delete.