Brought to you by:

Hi Reader,

Welcome to the Google Sheets Tips newsletter #317, your Monday morning espresso, in spreadsheet form!

I hope your week is off to a fabulous start.

My youngest son is sports-mad. From the moment he wakes up until he falls asleep, he's got a bat and ball in his hands or a football at his feet. Currently, he's obsessed with pickleball, the funny, new version of tennis that's sweeping across the US. So I spent much of this weekend just gone whacking a ball around in the backyard. I already nearly broke my toe playing soccer with him this summer, so if you see me typing with only one hand soon, you'll know why...

Brought to you by: ChartPixel From raw data to explained insights in 30 seconds! Uncover hidden trends and patterns in your data with ChartPixel’s AI-assisted insights and visualization engine, offering powerful statistics without the learning curve. Get the most important data insights explained and visualized in seconds. Forecast relevant business insights and ensure statistical significance to make better decisions. Gain expert survey insights with sentiment and topic analysis. See what ChartPixel can do

➜ Sheets Tip #317: Round to the nearest 100

Here's a handy tip that I used last week. I needed to create a set of random sales figures to the nearest 100.

Let's see how I did that.

We can use the MROUND function to round a number to the nearest 100 (or any other integer).

For example, suppose we have the value "94714" in cell A1. We can use this formula to round up to the nearest 100:

=MROUND(A1,100)

The result is 94700.

By the way, the neat thing with MROUND is that you can put any integer as the rounding factor.

Need to round to the nearest 471 instead?

Not a problem!

=MROUND(A1,471)

which gives the answer 94671.

For my scenario last week, I had one more step. I wanted to generate a random value to the nearest 100, between $10,000 and $100,000.

To do this, I used RANDBETWEEN and wrapped it with the MROUND function. E.g.

=MROUND(RANDBETWEEN(10000,100000),100)

Nice!

If you enjoyed this newsletter, please forward it to a friend who might enjoy it.

Have a great week!

Cheers,
Ben

P.S. AI is doing the wrong jobs for us!​