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.
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #396, your Monday morning espresso, in spreadsheet form! Today I'm sharing 3 killer tips for pivot tables. I would still argue that Pivot Tables are THE killer feature of spreadsheets. Their ability to quickly and simply generate insights about your data is unmatched. So it makes sense to learn how to use them to their fullest. Today, I'm sharing three under-the-radar tips for using pivot tables. All 3 are very simple...
Hi Reader, Welcome to the Google Sheets Tips newsletter #395, your Monday morning espresso, in spreadsheet form! I moved house last week. 🏡 It's a lot of work to pack up a house and set up a new one. And it's amazing how much stuff you accumulate, especially when: 1) you've lived somewhere for a long time, and 2) have children. A move is the perfect opportunity to declutter and get rid of stuff that isn't serving you anymore. We had a big yard sale (aka a jumble sale for my outside-the-US...
Hi Reader, Welcome to the Google Sheets Tips newsletter #394, your Monday morning espresso, in spreadsheet form. Welp, with the World Cup and the Tour de France events both now firmly in the rear view mirror, I guess I have no choice but to get back to work! In all seriousness, this summer has been crazy busy for me. International travel to visit my family in England, a bad sickness, summer camps, moving house... Once my boys go back to school again, it'll be a little easier to get into a...