MS Excel: ATANH Function (WS)

This Excel tutorial explains how to use the Excel ATANH function with syntax and examples.

Description

The Microsoft Excel ATANH function returns the inverse hyperbolic tangent of a number.

Syntax

The syntax for the Microsoft Excel ATANH function is:
ATANH( number )

Parameters or Arguments

number is a number between 1 and -1 (excluding the values of -1 and 1).

Applies To

The ATANH function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The ATANH function can be used in Microsoft Excel as the following type of function:
  • Worksheet function (WS)

Example (as Worksheet Function)

Let's look at some Excel ATANH function examples and explore how to use the ATANH function as a worksheet function in Microsoft Excel:
Microsoft Excel
Based on the spreadsheet above, the following Excel ATANH examples would return:
=ATANH(A1)
Result: -1.47221949

=ATANH(A2)
Result: 0

=ATANH(A3)
Result: 1.256152812

=ATANH(-0.75)
Result: -0.972955075

Total Pageviews

2016 © BiztechCS
Planer theme by BiztechCS