Jump to content

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.

Link to comment
Share on other sites

Join the conversation

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

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...