If you want to subtract a cell value from a number that is not in a cell, simply replace one of your cell locations with that number instead.įor example, the formula =100-B2 would subtract my value in cell B2 from 100. This simple formula is very versatile, and we will show you a couple of other ways that you can use it at the end of the article.Įnter the formula into the cell, such as =a2-b2, then press Enter. You can either subtract this value from a value in another cell, or you can subtract it from a number that you select. The steps in this tutorial assume that you have a cell containing a value that you want to subtract. How to Use the Formula for Subtraction Excel 2013 – Subtracting Two Cell Values You can read our Microsoft Excel tutorial on how to add columns if you’ve been looking for an easy way to generate totals for an entire column of values. Specifically, we will focus on subtracting in Excel 2013 by specifying two cell locations that contain numerical values. This article will provide a brief overview of the Excel subtraction formula, plus some examples of that formula that you can apply to your own spreadsheets. There are a number of different calculations that Excel is capable of performing, many of which can save you a lot of time if you regularly work with Excel spreadsheets. Learning how to use some of the common mathematical operations, like subtraction, in Excel 2013 with a formula will provide you with a gateway into the world of Excel formulas. if you need to know how to do this, then check out our how to calculate percentage in Excel article.
You can use combinations of these functions to generate percentage values. This means it’s possible to add, subtract, divide, and multiply in Excel 2013. You can also compare data and use mathematical functions. Microsoft Excel can do more than just store and sort data. Press Enter to perform the subtraction.Ĭontinue reading below for more information on how to subtract in Excel, as well as view pictures of these steps.Enter the first cell value, then a “-” symbol, then the second cell value.6 Frequently Asked Questions About the Excel Subtraction Formula How to Use the Subtraction Formula in Excel
0 kommentar(er)
