Use Excel as a calculator

Note: We do our best to provide you with the latest help content as quickly as possible in your language. This page has been translated automatically and may contain grammatical errors or inaccuracies. Our goal is to make this content useful to you. Can you tell us at the bottom of the page if this information helped you? Here is the article in English for easy reference. Instead of using a calculator, use Microsoft Excel to perform mathematical operations. You can enter simple formulas to add, divide, multiply, and subtract two numeric values. You can also use the AutoSum feature to quickly add a series of values ​​without entering them manually into a formula. After you create a formula, you can copy it to adjacent cells to avoid having to recreate it multiple times. Subtract in Excel Multiply in Excel Split in Excel Learn more about simple formulas All formula entries start with an equal sign (=). For simple formulas, just type the equal sign followed by the numeric values ​​you want to calculate and the mathematical operators you want to use: the plus sign (+) to add, the minus sign (-) to subtract, asterisk (*) to multiply and slash (/) to divide it. Then press Enter to have Excel calculate and display the result of the formula. For example, when you enter = 12.99 + 16.99 in cell C5 and press ENTER, Excel calculates the result and displays 29.98 in that cell. The formula that you enter in a cell remains visible in the formula bar, and appears each time that cell is selected. Important: Unlike the SUM function, there is no SUBTRACT function. Use the minus (-) operator in a formula; for example, = 8-3 + 2-4 + 12. You can also use a minus sign to convert a number to a negative value in the SUM function; for example, the formula = SUM (12.5, -3.8, -4) uses the SUM function to add 12, 5, subtract 3, add 8, and subtract 4, in that order. Use AutoSum The easiest way to add an SUM formula to your spreadsheet is to use AutoSum. Select an empty cell directly above or below the range to be added, and on the Home or Formulas tab of the ribbon, click AutoSum> Sum. AutoSum automatically detects the range to add and creates the formula for you. It can also work horizontally if you select a cell to the left or right of the range to add. Note: AutoSum does not work on non-contiguous ranges. Vertical AutoSum In the illustration above, the AutoSum feature is visible to automatically detect B2: B5 cells as the range to be added. Just press ENTER to confirm it. If you need to add / exclude other cells, hold down the Shift key and press the arrow key of your choice until the selection is right for you. Press Enter when done. IntelliSense function mark: The floating SUM tag (number1, [nombre2], …) displayed under the function is its IntelliSense mark. If you click SUM or the name of the function, it changes to a blue hyperlink that gives you access to the help topic for that function. If you click on the individual elements of the function, their representative part in the formula will be highlighted. In this case only, B2: B5 would be highlighted because this formula contains only a number reference. The IntelliSense tag is displayed for any function. Automatically sum horizontally For more information, see the article on the SUM function. Avoid rewriting the same formula After creating a formula, you can copy it to other cells to avoid having to rewrite it. You can copy the formula or use the copy handle to copy the formula into adjacent cells. For example, when you copy the formula into cell B6 through C6, the formula for that cell automatically changes to update the cell references in column C. When you copy the formula, make sure the cell references are correct. Cell references may change if they have references …


Leave a Reply

Your email address will not be published. Required fields are marked *