Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
ST387: Do You Know How To Round Numbers To The Nearest Hundred, Thousand?
|
Welcome to the Google Sheets Tips newsletter #387, your Monday morning espresso, in spreadsheet form! I'm traveling so no news section again this week. But don't worry, I'll have a full recap of all the relevant Google Next announcements soon. ➜ Sheets Tip #387: Do You Know How To Round Numbers To The Nearest Hundred, Thousand?We’ve all used the ROUND function to tidy up messy decimals. But do you know one of its best tricks? It works equally as well to round to the nearest ten or hundred or thousand using negative numbers, in the same way as with positive numbers. Most of us use ROUND like this: =ROUND(A1, 2) to get two decimal places. But when you go negative, the rounding moves to the "left" of the decimal point. To the nearest 10: =ROUND(A1, -1) To the nearest 100: =ROUND(A1, -2) To the nearest 1,000: =ROUND(A1, -3) ExampleSuppose you have a line item of $92,389 in your project expenses. Those granular dollars and cents are often just "noise" in a high-level summary. Use the ROUND formula to fix it. For example: =ROUND(92389, -3) outputs a clean $92,000. It’s one of those things that you wonder how you did without it in hindsight; it’s a total game-changer for data reporting. Happy rounding! If you enjoyed this newsletter, please forward it to a friend who might enjoy it. Have a great week! Cheers, |
Google Sheets Tips
Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Hi Reader, Welcome to the Google Sheets Tips newsletter #388, your Monday morning espresso, in spreadsheet form! ➜ Sheets Tip #388: Merged Cells To many power users who live in spreadsheets, merged cells are often treated like a patch of poison ivy on a hiking trail. They see them, turn their nose up, and steer well clear. But are they always the villain? Let's find out. Why Purists Cringe At Merged Cells In a structured dataset or a table, merged cells are, quite frankly, a nightmare. They...
Hi Reader, Welcome to the Google Sheets Tips newsletter #386, your Monday morning espresso, in spreadsheet form! Similar to Sheets Tip #384 from a couple of weeks ago, we're keeping it light hearted with today's tip. In this case, I'm showing you one of Google Sheets' secret easter egg functions! Read on to find out what it is and what it does. ➜ Sheets Tip #386: Is your Sheet feeling crowded? Build a meadow 🐑 We’ve all been there: you’re focused on giving a demonstration in your Sheet to...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #385, your Monday morning espresso, in spreadsheet form! It's that time of year when you need hat and gloves one day and shorts and sunscreen the next. Last week, we had back-to-back days of 90°F. I'm sure it happens every Spring, but I always find it surprising how quickly the seasons change. Thankfully, we've also enjoyed plenty of days in the 60s and 70s (the preferred operating temperature of this Englishman). I...