POWER Function (Functions in Excel)
Number | Power | Result | |
3 | 2 | 9 | =POWER(C4,D4) |
3 | 4 | 81 | =POWER(C5,D5) |
5 | 2 | 25 | =POWER(C6,D6) |
5 | 4 | 625 | =POWER(C7,D7) |
What Does It Do ? |
This function raises a number to a user specified power. |
It is the same as using the ^ operator, such as 3^4, which result is 81. |
Both the POWER() function and the ^ operator are the same as using 3*3*3*3. |
Syntax |
=POWER(NumberToBeRaised,Power) |
Formatting |
No special formatting is needed. |
Example |
To calculate the area of a circle. |
Radius | Area | |
5 | 78.54 | =PI()*POWER(C22,2) |
25 | 1963.50 |
0 comments:
Post a Comment