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.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.