If you owe money, you can't owe less than you actually owe. So, here is where your round down might be wrong. In this particular case, we're looking at the cost of an item. We have a price and we're doing a deep discount. Maybe it's the end of a business sale. Uh-oh. But our debt is just piling up because we have costs involved. We have negative profits. And we have a total debt here of -43. But we want to round it. We want to have a round number . And if we round down, let's just wrap that sum with round down, we're going to get -43. No matter how we look at that, if it's in dollars or anywhere else, this is wrong. This is

less debt than we actually owe, which is 43.5 or $43.50. So how do we round down but not to zero? So basically what's going on under the hood is that round down is taking whatever number is here and getting it closer to zero. So positive numbers it works fine. It works totally good. But when we have negative numbers in this particular case and in some cases it doesn't necessarily matter. But in in a lot of cases with debt, we can't owe less than we actually owe. We want reality to be the same or reality to be real. So we use int. Int rounds down to the nearest integer.

However, it rounds to negative infinity. So actually rounding down in positive numbers, int and roundown are the same. But in negative numbers, they are polar opposites. Very interesting to know that int could be the answer for even rounding down above zero if it's also what you need to do below zero. There is also round which in this particular case is going to get our real correct answer. But if everything is flipped, we don't have this deep discount. Is our round up correct? Is it? Do we want to be rounding up when it's positive? And when we are negative, we want to round

towards zero as well. If we don't, if in actuality we want to be rounding down when we're positive and rounding down to negative infinity when we're negative, you're going to want to use int. There is going to be the answer for you to round. Very interesting little optimization you can do to your Google Sheets today. You're watching Better Sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how-tos, get more out of your Google Sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right

here, one of these videos is going to be your next Google Sheet.