ROUND Tens, Hundreds, Thousands
Learn how to round numbers to the nearest tens, hundreds, or thousands in Google Sheets with this quick and effective tutorial. Discover practical applications for rounding in inventory management, budgeting, and property valuation.
So you're trying to round to the tens, hundreds or thousands, this is the video for you. Very quick little trick, but I wanna share with you why you might be doing this, 'cause you might be rounding your inventory down for a quick stock count, you might be rounding your monthly spend, you might be rounding property values . For example, you might be rounding even small units to the nearest ten for, like, starting net labels, or you might even want to round annual revenue for a really high-level summary. And essentially we wanna take these numbers over here on the left and have more zeros in them, right? We can say, like, if we have a certain stock, we really want to round down. But round down is a lot of letters to… We can actually do this with round. How to Refer to Other Cells - A1 and R1C1 Explained How to Round Numbers in Google Sheets
Uh, round is just saying, "Hey, take this," and you think, "Oh, I got two places," right? Or one place. And you see that, okay, cool, it's rounding down on that, after that dot. But before that dot I also wanna round. That's where we wanna round our tens, hundreds or thousands. And round negative one is going to be a tens round. Negative two is gonna be for hundreds, and thousands is gonna be negative three. So for inventory, we may want to round only to the tens. For monthly marketing spend, round, take our selection that we wanna actually… the text or the number we wanna round to. Maybe we want just a few numbers. WRONG ROUNDDOWN
For, for property values , we want to round this number negative three, four or even five. Rounding down small units, equals round, select the text, negative one. Nine point four is still gonna round to 10, just a, a note . For a high-level summary equals this, round- Negative three or five, four, whatever you want to get a nice result. Very rounded numbers, a lot more zeros. Very easy to parse these numbers than the ones on the left You are 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 WRONG ROUNDDOWN
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 gonna be your next Google sheet. Better Sheets Videos Checklist 80 Years In 1 Spreadsheet Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets. Link to Another Sheet in Google Sheets