Excel: Calculate nth root and co-tangent

Using Excel, you can calculate nth roots and the co-tangent. However, there is no direct function input for root extraction.

Excel: calculate nth root and co-tangent

Excel does not offer any special functions for the task described. However, the task can be easily rewritten mathematically and reduced to another function:

• The nth root means nothing other than the 1/nth power of a value. To calculate the nth root of the value x, you can therefore type the following function into any cell in Excel: “=POTENCE(x;1/n)”. Alternatively, this also works with “=x^(1/n) ”

• The calculation of the co-tangent can be traced back to the tangent. The co-tangent of a value is the same as 1 divided by the tangent of this value. When calculating, however, you must always bear in mind that Excel expects the angle arguments in radians.

• To calculate the co-tangent of an angle “a” in degrees, enter the function “=1/TAN(BOGENMASS(a))”. Alternatively, you can also calculate the co-tangent with “=1/TAN(a*PI()/180)”.