Returns the inverse hyperbolic cosine of a number.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-Excel — אותה תחביר ואותם ארגומנטים.
ACOSH(number)The ACOSH function calculates the inverse hyperbolic cosine of a given number. The number must be greater than or equal to 1, otherwise the function returns a #NUM! error.
=ACOSH(1)תוצאה: 0
The inverse hyperbolic cosine of 1 is 0.
=ACOSH(10)תוצאה: 2.993222846
Calculates the inverse hyperbolic cosine of 10.
This error occurs if the input number is less than 1, as the inverse hyperbolic cosine is undefined for values smaller than 1.