Select a cell and type an equal sign (=) to start the formula.Įnter the first value, then a subtraction sign (-).Įxcel performs the calculation and displays the result in the cell. Learning how to subtract in Excel when the calculation involves two values is simple. How to subtract in Excel using two values In this article, we explain how to subtract in Excel using a range of different methods plus how to enhance your Excel skills. You can use these tasks to make simple or complex calculations that help with useful business functions, like forecasting, scheduling and databasing.
It's helpful to start learning how to use the program by performing basic tasks like additions, subtractions, multiplications and divisions. Another example is SUM(A1, A3, A5) which adds the numbers that are contained in cells A1, A3, and A5 (A1, A3, and A5 are arguments).Excel is a powerful data management and analysis program with a wide variety of tools available but, for many users, it's relatively simple arithmetic calculations that get the most use.
For example, SUM(A1:A5) adds all the numbers in the range of cells A1 through A5. Each argument can be a range, a cell reference, an array, a constant, a formula, or the result from another function. The SUM function adds all the numbers that you specify as arguments.
To switch between viewing the results and viewing the formulas, press CTRL+` (grave accent) on your keyboard.Or, click the Show Formulas button (on the Formulas tab). In the worksheet, select cell A1, and then press CTRL+V. Subtracts 9000 from 15000 (which equals 6000)Īdds all number in the list, including negative numbers (net result is 16000) Select all of the rows in the table below, then press CTRL-C on your keyboard. Exampleįollow these steps to subtract numbers in different ways: Use the SUM function and convert any numbers that you want to subtract to their negative values. Note: There is no SUBTRACT function in Excel.
0 kommentar(er)
