- SQRT function
The POWER function calculates a given number, raised to a supplied power.
|number||The base number. It can be any real number|
|power||The exponent to which the base number is raised|
Note: The “^” operator can be used instead of POWER to indicate to what power the base number is to be raised, i.e., =POWER(6,2) is the same as 6^2.
|2||=POWER(2,3)||8||2 to the 3rd power|
|3||=POWER(5.5,3)||166.375||5.5 to the 3rd power|
|4||=POWER(2,0.5)||1.414213562||2 to the power of 0.5|
|5||=POWER(98.6,3.2)||2401077.222||98.6 to the power of 3.2|
|6||=POWER(“2”,2)||#VALUE!||One of the values is a text string|
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if either of the supplied arguments can not be interpreted as numeric values|