How to set a seed for random number generation
<p>From what I understand, there is no built-in function in Google Sheets that allows you to set a seed for RAND() or RANDBETWEEN().</p>

<p>My goal is to create a list of psuedo-random integers, within a range, using a function that will produce different (though, not necessarily unique) values based on:</p>

<ul>
<li>Which cell is running the function</li>
<li>And the value in a second cell that contains a seed of my choosing</li>
</ul>

<p>I need it to produce the same value every time the function is run in a particular cell, with a particular seed.</p>

<p>What is the simplest way to achieve this, so that someone who isn't me and has no programming knowledge can easily use the formula in other cells, as they need to?</p>