Skip to content

Function

Excel Function – ADDRESS()

  • ilyar126 

Description To calculate the address of a cell in an worksheet. You can use this function to refer cells in other worksheets as well. Syntax ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text]) row_num: specifies the row number col_num: specifies the column number [abs_num]: optional, which row or column to be fixed (absolute) with $ or relative [a1]: optional, it specifies A1 or R1C1 reference style if set to False or left blank.… Read More »Excel Function – ADDRESS()

Excel Function – ACOT()

  • ilyar126 

Description To calculate the inverse of a Cotangent or Arctangent. The result is in radians number from 0 to pi (3.14) Syntax ACOT(number) Examples The results are as follows: The DEGREES() function is the same as 180/PI(), which basically tells us Arctangent in Degrees References Similar function ACOS calculates Arccosine or inverse cosine.

Excel Function – ACOSH

  • ilyar126 

Description To calculate the hyperbolic arccosine of a hyperbolic cosine (number). The Hyperbolic Arccosine is an inverse of a hyperbolic cosine is a number greater or equal to 1. Syntax ACOSH(number) Examples The results are as follows: References How to calculate Arccosine.

Excel Function – ACOS()

  • ilyar126 

Description To calculate the arccosine of a cosine (number). The Arccosine is an inverse of a cosine ranging from 0 to pi (3.14). Syntax ACOS(number) Examples The results are as follows: The DEGREES() function is the same as 180/PI(), which basically tells us Arccosine in Degrees References Want to see ACOS() in action? Check out how to measure Earth’s distances between any 2 points here.

Excel Function – ABS()

  • ilyar126 

Description Provides absolute number of any positive or negative number. The results is always a positive number. An absolute number means simple a number without a negative sign, so its always positive. Syntax ABS(number) Examples