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 #391, your Monday morning espresso, in spreadsheet form! (Sorry there was no newsletter last week. I was sick!) This week we're looking at a cool use case for Google Sheets that most folks have no idea about. Creating QR codes! With a few simple formulas you can create QR codes in your Sheets that you could use to track inventory, accept invitations, or even print out to use at an event. First, a housekeeping announcement: after today,...
Hi Reader, Welcome to the Google Sheets Tips newsletter #390, your Monday Tuesday* morning espresso, in spreadsheet form! * public holiday in the US yesterday. Speaking of coffee, I usually work from my local coffee shop twice a week. It makes for a nice change of scenery from home. And everytime I order the same thing: a regular cappuccino, no frills, no syrups, no fancy milks. I think it says a lot about my personality and stage in life. As a working parent, neck deep in the world of AI,...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #389, your Monday morning espresso, in spreadsheet form! After a major work sprint to launch the 28 Days to Gemini Mastery course earlier this spring, I recently took a few weeks off to visit my brother and his family in Australia. We spent time hiking and packrafting in Tasmania's remote and beautiful Southwest National Park. It was an incredible trip and, without cell service for 12 days, a true break from the noise...