Formulas are the real workhorses of an Excel 2010 worksheet. If you set up a formula properly, it computes the correct answer when you enter it into a cell. You can set up a formula from the functions excel provides or create your own custom excel function. From then on, it keeps itself up to date, recalculating the results whenever you change any of the values that the formula uses.
You let Excel know that you’re about to enter a formula in the current cell by entering the equal sign (=). Some formulas follow the equal sign with a built-in function such as SUM or AVERAGE. Many simple formulas use a series of values or cell references that contain values separated by one or more of the following mathematical operators:
This Mathematical Operator . . . | . . . Is Used For |
---|---|
+ (plus sign) | Addition |
– (minus sign or hyphen) | Subtraction |
* (asterisk) | Multiplication |
/ (slash) | Division |
^ (caret) | Raising a number to an exponential power |
Apr 19, 2018 - How to Do Exponents in Excel on PC or Mac. This formula will allow you to insert a base number and a power exponent, and see the result of.
For example, to create a formula in cell C2 that multiplies a value entered in cell A2 by a value in cell B2, enter the following formula in cell C2: =A2*B2
To enter this formula in cell C2, follow these steps:
- Select cell C2.
- Type the entire formula =A2*B2 in the cell.
- Press Enter.
![Excel For Mac How To Insert An Exponent In A Formula Excel For Mac How To Insert An Exponent In A Formula](/uploads/1/2/5/8/125842267/356101573.png)
Or
- Select cell C2.
- Type = (equal sign).
- Select cell A2 in the worksheet by using the mouse or the keyboard.This action places the cell reference A2 in the formula in the cell.To start the formula, type =, and then select cell A2.
- Type * (Shift+8 on the top row of the keyboard).
- Select cell B2 in the worksheet by using the mouse or the keyboard.This action places the cell reference B2 in the formula.
- Press Enter.Excel displays the calculated answer in cell C2 and the formula =A2*B2 in the Formula bar.
If you select the cell you want to use in a formula, either by clicking it or by moving the cell cursor to it, you have less chance of entering the wrong cell reference.
Now comes the fun part: After creating a formula that refers to the values in certain cells (rather than containing those values itself), you can change the values in those cells, and Excel automatically recalculates the formula, using these new values and displaying the updated answer in the worksheet. Using the example shown in the figures, suppose that you change the value in cell B2 from 100 to 50. The moment that you complete this change in cell B2, Excel recalculates the formula and displays the new answer, 1000, in cell C2.
Did this glimpse into Excel formulas leave you longing for more information and insight about Microsoft’s popular spreadsheet program? You’re free to test drive any of the For Dummies eLearning courses. Pick your course (you may be interested in more from Excel 2010), fill out a quick registration, and then give eLearning a spin with the Try It! button. You’ll be right on course for more trusted know how: The full version’s also available at Excel 2010.
Related Articles
- 1 Square in a Spreadsheet
- 2 Calculate Compound Interest Rates
- 3 Set Call Forwarding on a Motorola RAZR
- 4 Compute a Value in Excel With Square Root and Exponents
Exponents refer to a number raised to the power of another number. The 'power' means how many times the base number is multiplied by itself. As an example, 10 to the second power, also called '10-squared,' simply means 10 times 10. In business, many important calculations, such as growth projections, require exponents. If you're an avid Microsoft Excel user, you will likely eventually need to use exponents in Excel.
1.Open your business spreadsheet in Microsoft Excel.
2.Use the 'Power' function to specify an exponent using the format 'Power(number,power).' When used by itself, you need to add an '=' sign at the beginning. As an example, '=Power(10,2)' raises 10 to the second power.
3.Substitute Excel's '^' shorthand in place of the Power function using the format 'number^power.' As an example, '=10^2' performs the same function as '=Power(10,2).'
Photo Credits
- Hemera Technologies/Photos.com/Getty Images
Choose Citation Style
Taylor, C.. 'How to Use Exponents on Excel.' Small Business - Chron.com, http://smallbusiness.chron.com/use-exponents-excel-54040.html. Accessed 20 November 2019.
![Mac how to insert a row Mac how to insert a row](/uploads/1/2/5/8/125842267/242955712.png)
Taylor, C.. (n.d.). How to Use Exponents on Excel. Small Business - Chron.com. Retrieved from http://smallbusiness.chron.com/use-exponents-excel-54040.html
Taylor, C.. 'How to Use Exponents on Excel' accessed November 20, 2019. http://smallbusiness.chron.com/use-exponents-excel-54040.html
Note: Depending on which text editor you're pasting into, you might have to add the italics to the site name.