Fluttering Upper Left Abdomen

XLS: square root or cube in Excel XLS

How do I calculate a square root in Excel?

To calculate the square root in Excel will propose 2 methods, according to two distinct functions.

• ROOT function
• POWER function

root function

This method is the procedure more direct and convenient to perform. The structure of the function is: = ROOT (NUMBER). In this case I will work on the square root of the number 2 .

The procedure is as follows:

a) Write the cell where you want the result, = ROOT (
b) Write the value or select the cell where the value to which apply the root. In this case the number 2.
c) Once the range of cells close the function with parentheses ) and now you can press ENTER or OK.

The formula would be as follows: = ROOT (2)

The following result is 2 1.41421. The number of decimal places depends on the settings of your cell number.

POWER FUNCTION

This other method is a slightly more complex procedure is suitable for those who prefer to choose the way austere, even knowing the short path. Let me continue with the example of the square root of 2 . The structure of the function is: = POWER (NUMBER, POWER ) .


The procedure is as follows:

a) Write the cell where you want the result, the sign = POWER (
b) Add the number or value you want potentiate . This can write it manually or you can select the cell where the value is. In this case the number 2.
c) Add immediately after the number to enhance sign ;
d) Now add the number of power, ie the number to which you want to raise. In this case is 1 / 2 .
1 / 2 represents the square root. If you would like to apply this exercise to a cube root of the fraction would 1 / 3 .

e) After adding the closing power function with a break ) and now you can press ENTER or OK.

The result of the following 2 is 1.41421. The number of decimal places depends numerical settings of his cell.

** The equivalent POWER function in English is POWER. **
The equivalent ROOT function in English is SQRT.
** Remember that the = sign must always be at the beginning of any formula. **
If your computer is configured in the language ENGLISH , you may need to use: instead of; This observation underscored those who prefer to manually write the complete formula instead of using the cursor or mouse at the time choose the range to add. **
Excel only operate only with numeric values: integers, decimal, dates, times, etc, but NEVER TEXT type characters .
** Remember that the wording of the formulas should never have spaces between one character and another .


Posted by: Julio Rosales V.