Rbreb13 Posted December 26, 2003 Report Share Posted December 26, 2003 Calculate exponentials in two ways In many statistical, financial, and scientific calculations, you frequently need to calculate a value that results when you raise any number X to the power of any number Y. The result is what you get when you multiply X by itself Y times. In print, the exponent (Y) appears as superscript adjacent to the base number (X). Excel 2000 provides a couple of easy ways to make exponential calculations. First, you can hard-code the values by using the exponentiation operator, the circumflex [^]. For example, to calculate the result of three to the third power, enter =3^3 in any cell and press [Enter]. When you do, Excel performs this calculation: 3 x 3 x 3 = 27. In addition to using the exponentiation operator, you can also use the POWER function, which takes the form =Power(basenumber,exponent). To try this function, create a new worksheet and enter any number in cell A1 and any other number in cell A2. In cell A3, enter =Power(A1,A2). When you change the values in cells A1 and A2, A3 will show the results of your calculation. Quote Link to comment Share on other sites More sharing options...

## Recommended Posts

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.