Calculate exponentials in two ways

Recommended Posts

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.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account. ×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.