Sometimes we have data we have some negative values like here revenue and expenses meaning profit and we don't want to necessarily get rid of all of the negative values but we just want to adjust them to zero. So how do we do that? We're going to equals if and this logical expression is only going to be true or false. If d2 is less than zero then if that's true we want to adjust it to zero. If it's false, we just want this exact number . So, we adjust that here. And now we have the adjusted profit. And we see all of the months where there's actual profit. This is great also if you want to prevent invalid values . Sometimes negative numbers can be invalid values for some

other formulas. So, this is also a good way to do that. 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.