Formulas > =IMCOSH()

How To Use IMCOSH() Function in Google Sheets


Returns the hyperbolic cosine of the given complex number. For example, a given complex number "x+yi" returns "cosh(x+yi)."

Common questions about the IMCOSH formula include:

- What does IMCOSH stand for?
- What does the IMCOSH formula represent?
- What are the components of the IMCOSH formula?

The IMCOSH formula can be used to calculate the total internal rate of return (IRR) of investments over a given period of time. Its components include: total investment, net present value (NPV), internal rate of return (IRR), and cash flow.

Common ways the IMCOSH formula may be mistyped include:

- IMCOS instead of IMCOSH
- IMCOSH instead of IMCOSH
- IMCASH instead of IMCOSH

Common ways the IMCOSH formula can be used inappropriately include entering incorrect cashflow figures, incorrect internal rate of return figures, or incorrect total investment amount.

Common pitfalls when using the IMCOSH formula include not understanding the differences between net present value (NPV) and internal rate of return (IRR), not properly accounting for future cash flows, and not understanding the assumptions used to calculate the formula.

Common mistakes when using the IMCOSH formula include entering the wrong data into the formula, incorrect calculations, and not considering all of the cashflows associated with a project.

Common misconceptions people might have with the IMCOSH formula include believing that the formula will always provide a positive return on investment, believing that the formula will always yield a profitable investment, and believing that the formula will always produce accurate results.

How To Actually Use IMCOSH() in Sheets


Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the IMCOSH() formula:

54 engineering formulas in excel 2016

This video is about how to create 54 Engineering Functions with Examples in MS Excel Spreadsheet 2016.

Generate a IMCOSH() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.