Power() Function



The Excel POWER function returns a number to a given power. The POWER function works like an exponent in a standard math equation.


Syntax

The syntax for the POWER function in Microsoft Excel is:

=POWER( number, power )

Parameters or Arguments

number

It is the base number.

power

It is the exponent used to raise the base number to.

Excel Power Function Examples

The following spreadsheet shows three simple examples of the Excel Power function.

Formulas:


A
B
C
1
=POWER( 2, 3 )
2
5.5
3
=POWER( A2, B2 )
3
2
0.5
=POWER( A3, B3 )

Results:


A
B
C
1
8
2
5.5
3
166.375
3
2
0.5
1.414213562

References



No comments:

Post a Comment

OR Function