Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Perform case-sensitive Lookup in Excel
  • Count unique text values with criteria
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • How to use Excel INDIRECT Function
  • Two-column Lookup in Excel

Data Analysis Examples

  • Conditional Formatting Icon Sets Examples in Excel
  • Create Scatter Chart in Excel
  • How to create Checklist in Excel
  • How to create Gauge Chart in Excel
  • Managing Conditional Formatting Rules in Excel

Data Validation Examples

  • Excel Data validation whole percentage only
  • Excel Data validation date in specific year
  • Excel Data validation unique values only
  • Data validation must not exist in list
  • Prevent invalid data entering in specific cells

IMCSCH function: Description, Usage, Syntax, Examples and Explanation

by

What is IMCSCH function in Excel?

IMCSCH function is one of Engineering functions in Microsoft Excel that returns the hyperbolic cosecant of a complex number in x+yi or x+yj text format.

Syntax of IMCSCH function

IMCSCH(inumber)

The IMCSCH function syntax has the following arguments.

  • Inumber:  A complex number for which you want the hyperbolic cosecant.

IMCSCH formula explanation

  • Use COMPLEX to convert real and imaginary coefficients into a complex number.
  • If inumber is a value that is not in the x+yi or x+yj text format, IMCSCH returns the #NUM! error value.
  • If inumber is a logical value, IMCSCH returns the #VALUE! error value.

Example of IMCSCH function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

Formula Description Result
=IMCSCH(“4+3i”) Returns the hyperbolic cosecant of a complex number, 4+3i. -0.036275889628626-0.0051744731840194i

Post navigation

Previous Post:

IMLN function: Description, Usage, Syntax, Examples and Explanation

Next Post:

IMDIV function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

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

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • CONCAT function: Description, Usage, Syntax, Examples and Explanation
  • How to add a line break with a formula while joining text strings in Excel
  • How to count keywords in a range of cell
  • Split dimensions into two parts in Excel Worksheet
  • How to extract substring in Excel
  • Count dates in current month in Excel
  • Dynamic date list in Excel
  • Convert decimal minutes to Excel time
  • How to calculate Day of the Year in Excel
  • Sum race time splits in Excel
  • TBILLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • ODDFYIELD function: Description, Usage, Syntax, Examples and Explanation
  • PPMT function: Description, Usage, Syntax, Examples and Explanation
  • Example of payment for annuity in Excel
  • ODDFPRICE function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles