GETPIVOTDATA is one of my favorite functions in Excel when it comes to retrieving and aggregating data. Its similar to SUMIFS and CUBEVALUE, but it always references a pivot table. What is the GETPIVOTDATA function? The GETPIVOTDATA function is a built-in function in Excel that allows you to retrieve data from a pivot table based…
Tag: Function
Excel Function – ADDRESS()
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]:…
Excel Function – ACOT()
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
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()
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…
Excel Function – ABS()
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