DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How to use the ACOSH Function in Excel office 365?

#tousetheacoshfunctio #excel #excelfunctions

COSH function is a Mathematical function to calculate the hyperbolic Cosine of the value , and it is a built-in Excel function. The hyperbolic function of COSH is defined using the exponential function. In this post, we will explain to you how to use ACOSH Function In Excel Office 365. Let’s see them below!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

ACOSH Function

ACOSH function in Excel returns the inverse of the Cosine hyperbolic function in Excel.

ACOSH Function Syntax 

= ACOSH ( number )
Enter fullscreen mode Exit fullscreen mode

Syntax Explanation:

number: input any real number equal to greater than 1.

Example

  • You have to create a sample data with values which will be input to the function.

Sample data

  • Then, you need to find the inverse of the hyperbolic Cosine value using the ACOSH function in Excel.
  • Now, you have to use the following formula given below. 
=COSH ( A2 )
Enter fullscreen mode Exit fullscreen mode

A2: the number is given as cell reference.

ACOSH function

  • After that, the value will calculate ** using the **mathematical formulation stated. 
x = COSH -1 (e1+ e-1) / 2  = COSH -1[( e + 1/e ) / 2] = 0
Enter fullscreen mode Exit fullscreen mode
  • You need to copy the formula to other cells using the Ctrl + D shortcut key.

Copy to other cells

  • Finally, Excel calculates the inverse of the Hyperbolic Cosine of a number using the COSH function.

Check this too: How to use the ASINH Function in Excel office 365?

NOTE:

  • The function returns #VALUE! Error if the argument to the function is non – numeric.
  • Now, the function returns #NUM error , if the argument number is less than 1.
  • The input argument to the function can be any real number.
  • Argument to the function can be provided directly or using the cell reference in Excel.

Wrap-Up

Hope you understood how to use ACOSH Function In Excel Office 365. Please feel free to state your query or feedback for the above article. Thank you for Reading!! To learn more, check out Geek Excel!! *and Excel Formulas *!!

Read Also:

Top comments (0)