This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Functions and Formulas - Exponentiation

There are two ways to perform exponentiation (raising a number to a power) in a Microsoft Excel 2003 spreadsheet.

A: Use the ^ operator

B: Use the =POWER function

Syntax:

=power(NUMBER,POWER)

NUMBER is the number to be raised

POWER is the power to that NUMBER will be raised.

The following two cells will return the exact same value, 32:

A1: =2^5
A2: =POWER(2,5)



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Exponentiation.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.