<\/p>\n
How to work with\u00a0calculations with square roots and powers in formulas Excel? It serves mathematical symbols and functions for this. In this article we will focus on just how to use it in excel formulas or insert a square root of various levels. They are not used too often, but in certain subjects\u00a0like math, statistics, physics and others where they\u00a0have their place. Let’s take a look at how to use them.<\/p>\n
For the powers we can use Excel formula in which we insert a special symbol. It is the symbol ^ , we can write it by\u00a0key combination Left ALT + 94<\/strong> on the numeric keypad or on by SHIFT + 6<\/strong>, depending on your keyboard language.<\/p>\n The second option is to use the POWER<\/strong>\u00a0function that enhance the numbers on the specified exponent.<\/p>\n =POWER(number,exponent)<\/p>\n Example\u00a01:<\/strong><\/span> we calculate 10 ^ 3 (ten to the third),<\/p>\n To determine the root of a number, again, we could use the symbol ^, because the root is defined as the power to the reciprocal value. Eg. the cube\u00a0root of five is five to one third. Excel does not know\u00a0specific\u00a0square root symbol.<\/p>\n For the square root<\/em>\u00a0we can use the SQRT function<\/strong>.<\/p>\n =SQRT(number)<\/p>\n Example 2:<\/strong><\/span>\u00a0<\/strong>we want to calculate the square root of 25<\/strong><\/p>\n Example\u00a03:<\/strong><\/span>\u00a0we want to calculate the fifth root of 100 000<\/p>\n\n
Roots<\/h2>\n
\n