Generate Random Numbers that Add Up to Given Amount – Google Sheets

In this video, we’re going to show you how to use the RAND and RANDBETWEEN in Google Sheets to generate a set of random numbers that add up to a specific value. You’ll be able to generate multiple sets of random numbers that add up to any value you want. This can be done with decimal numbers as well as integers. Consider this a hack or workaround to scripting something in Python or JavaScript as a quick solution you can easily put together in Google Sheets.

0:00 Intro
0:53 Random decimal numbers
3:47 Random integers

SUBSCRIBE to my channel https://goo.gl/wN3c3p

Excel Training https://www.exceltraining101.com/p/training.html

Excel Books & Tech Gear https://www.amazon.com/shop/dough

️ Tools: Screencasting https://techsmith.z6rjha.net/5Qe53

️ Tools: Microsoft Office https://microsoft.msafflnk.net/rKL0G

️ Tools: TubeBuddy https://www.tubebuddy.com/et101

This description may contain affiliate links and we’ll receive a small commission if a purchased is made using the links (but at no additional cost to you). It’ll support the channel and so more videos like this can be made. Thanks for your support!

If you find these videos useful and want to support my channel go to
https://www.buymeacoffee.com/dough

#excel
#msexcel
#doughexcel

——
Please watch: /”Convert Table in a PDF File to Excel/”
https://www.youtube.com/watch?vCOUOvhbQ4CQ
——

Take the opportunity to connect and share this video with your friends and family if you find it useful.