One of the most common functions you find in Excel is basic math. You will find that most operations have simple formulas that you can use to add, multiply and more. However, there is no formula in Excel that allows you to subtract. Instead, here are some alternative methods for subtracting in Excel.
How to subtract in Excel:
1. The most basic way to subtract is to build your own formula. As always, you must start with a equal sign (=) and then add your numbers. If you do math within a single cell, you can use numbers similar to the image below. The formula shows as = 100-17-12 .
2. You can also subtract whole cells in the same way. Instead of using numbers, you just have to use cell identities instead. In the example below, you see A1, A2 and A3 placed in the formula in cell A4. The formula reads = A1-A2-A3 .
3. Once you have mastered the art of subtracting with cells, you can make things a little easier for yourself. You can use the SUM formula to add any cells you want to subtract and then use it instead of typing each cell. This means that your formula looks like this: = A1-SUM (A2: A5) .
4. You can also get really nice and subtract two columns from each other. All it takes is to create a simple = A1-B1 formula. Then you can drag the formula through the entire line, just like the picture below.
There you go, these are four different ways to subtract in Excel. You can choose which one you prefer and they are all useful for different types of subtraction.
What more can you do in Excel?
Now that you know how to subtract in Excel and you've read a little bit about formulas, you're probably ready to learn more. With just a little training you can dominate databases and use your skills to develop your career. If you are ready, you can check out the complete Excel Pro Tips certification package for technical offers.
It is a beginner-friendly learning kit that contains six practical modules on all Excel. You can learn the basics of formulas and formatting and work on top skills like PivotTables. The all-in-all package contains 11 hours of content to help you become a spreadsheet profile.
Complete Excel Pro Tips Certification Bundle has a retail value of almost $ 300 but you can get started right now for just $ 19. Over 1,300 people have already signed up, so now is the perfect time to join them.
$ 19 .00
Complete Excel Pro Tips Certification Bundle
Save  $ 275 .00
Save $ 275 .00 $ 19 . 00