Related Function:

- SQRT function

The POWER function calculates a given number, raised to a supplied power.

### Syntax

=POWER(number,power)

#### Arguments

Argument | Description |
---|---|

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.

#### Examples

A | B | C | |
---|---|---|---|

1 | Formula | Result | Notes |

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 |