When you build a formula, you need to identify the worksheet cells that provide the values for the formula and the operations that you want to perform on those values. If there is, Excel interprets the cell’s contents as text, not as a formula. Type the expression representing the calculation that you want to perform.īe sure that there’s no space before the equal sign in your formula. Build a formulaĬlick the cell in which you want to enter a formula. The formula that you enter appears on the formula bar, where you can examine and edit it.
HOW TO USE MICROSOFT EXCEL FORMULAS 2013 PLUS
If you want to find the sum of the values in two cells, you just type an equal sign (=), the reference of the first cell, a plus sign (+), and the reference of the second cell. Creating simple cell formulasīuilding calculations in Excel is pretty straightforward. Excel makes it easy to reference a number of cells at once, letting you build your calculations quickly. Many times you can’t access the information that you want without referencing more than one cell it’s also often true that you’ll use the data in the same group of cells in more than one calculation.
Whether those cells represent the sales for a day at your store, the returns from your personal investments, or your times in bicycle races, you can find the total or average of the values, identify the minimum or maximum value in a group, or perform dozens of other calculations on your data. One important task that you can perform in Excel is to summarize the values in related cells. Microsoft Excel 2013 workbooks let you do much more than simply store and organize your data. Summarizing the values in groups of cellsĬreating formulas that reference cells in other workbooksĪnalyzing data using the Quick Analysis Lens Understanding formulas and cell references in ExcelĬreating, editing, and deleting named ranges
0 kommentar(er)
