How To Subtract in Google Sheets

0:00 You're going to learn a very little known way how to subtract in Google Sheets . Here we have our sales and our goals and we need to know how far away are we from our goal. We can do equals goal minus with the hyphen sign and we get our number . And we can totally click and drag that all the way down or copy paste it all the way down. We can also use array formula . To say this minus this, we get some negative numbers there, we can flip it around, take this minus or hyphen this, and we get all positive numbers. There is one other way, we can use minus, this is a formula , we will use equal sign m i n u s, minus, and we'll take it. C2 and 55. But if you're not sure which way this should go, should it go B2 comma C2, 5 Ways To Use Google Sheets for Advanced Project Management Absolute Basics of Google Sheets Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5 How To Make Negative Numbers Red in Google Sheets

0:49 you might get some negative numbers. But an interesting point about subtraction here and in this particular case, we just need to know the difference. It doesn't actually matter if it's positive or negative here. It's going to be the same number . We just have to wrap abs or absolute around it and we get an absolute number and we know the difference. So this is very interesting if you're trying to subtract two numbers and you literally just need to know the difference between these two numbers. We can use absolute and minus here. If you're looking to get more out of Google Sheets than you ever have before, consider subscribing here on YouTube to BetterSheets. Google Sheet Basics - The Absolute Basics Absolute Basics of Google Sheets Cumulative Subtraction in Google Sheets