AI, Fabric, PowerBI, SQL, ML Blog – Formulas, Ideas, Coffee and more …
The ARABIC and ROMAN functions in Microsoft Excel are powerful tools designed to convert between Roman and Arabic numerals. These functions are particularly useful for professionals dealing with historical data, legal documents, or business reports that utilize Roman numerals. What are the ARABIC and ROMAN Functions? The ARABIC function converts a Roman numeral to an…
The AMORDEGRC function in Microsoft Excel is a financial function designed to calculate the depreciation of an asset for each accounting period using a depreciation coefficient. Unlike the AMORLINC function, AMORDEGRC applies a depreciation coefficient based on the life of the asset. This function is particularly tailored for the French accounting system, where it is…
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…
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]:…
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.
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.
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…
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