Showing posts with label Power Function. Show all posts
Showing posts with label Power Function. Show all posts

Tuesday, 28 July 2009

Power Function

Microsoft excel has provided power function. You can calculate the power of a number. For example you can see the following examples:

1. create a table like the following
We will calculate the power of the existing numbers in column A, then calculate the power (power 2 in column B) and power 4 in column C




2. Below we will try to use the power formula;
General formula:

= POWER (number, power)

a. the input formula B4 cells
= POWER (A4, 2)
b. In the cells enter the formula C 4
= POWER (A4, 4)

You also can use another formula, such as:
General formula

= number ^ power

a. In cell B11 type the formula
= A11 ^ 2
b.a In cell C11 type formula
= A11 ^ 4

You can see the result as below



Random Posts