Table of Contents
The IMCOSH function in Google Sheets is a mathematical function that calculates the inverse hyperbolic cosine of a given number. To use this function, you must first open a Google Sheets spreadsheet and select the cell where you want the result to be displayed. Then, type “=IMCOSH(” followed by the number or cell reference for the value you want to calculate the inverse hyperbolic cosine of. Press Enter to see the result. This function is useful for complex mathematical calculations and can be used in combination with other functions to perform various operations.
IMCOSH function
The IMCOSH function returns the hyperbolic cosine of the given complex number. For example, a given complex number “x+yi” returns “cosh(x+yi).”
Parts of an IMCOSH formula
IMCOSH(number)
| Part | Description | Notes |
number | The complex number for which you want the hyperbolic cosine. | This can be either the result of the COMPLEX function, a real number interpreted as a complex number with imaginary parts equal to 0, or a string in the format “x+yi” where x and y are numeric. |
Sample formulas
IMCOSH(COMPLEX(4, 6))
IMCOSH(4)
IMCOSH("2+3i")
Notes
The IMCOSH function returns an error if the given number isn’t a valid complex number.
Examples
| A | B | |
| 1 | Formula | Result |
| 2 | =IMCOSH(COMPLEX(4, 1)) | 14.7547011704838+22.963673499193i |
| 3 | =IMCOSH(3.5) | 16.5728246710573 |
| 4 | =IMCOSH("3+2i") | -4.18962569096881+9.10922789375534i |
Related function
COMPLEX: The COMPLEX function creates a complex number, given real and imaginary coefficients.
IMCOS: The IMCOS function returns the cosine of the given complex number.
IMSINH: The IMSINH function returns the hyperbolic sine of the given complex number.
Cite this article
stats writer (2024). “How do I use the IMCOSH function in Google Sheets?”. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-imcosh-function-in-google-sheets/
stats writer. "“How do I use the IMCOSH function in Google Sheets?”." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-imcosh-function-in-google-sheets/.
stats writer. "“How do I use the IMCOSH function in Google Sheets?”." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-imcosh-function-in-google-sheets/.
stats writer (2024) '“How do I use the IMCOSH function in Google Sheets?”', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-imcosh-function-in-google-sheets/.
[1] stats writer, "“How do I use the IMCOSH function in Google Sheets?”," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. “How do I use the IMCOSH function in Google Sheets?”. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.