Thread: NORMINV and RAND

Hello,

I have a column in my spreadsheet that calculates a random number based on a mean of 2500 and a std deviation of 200.

=NORMINV(RAND(),2500,200)


The formula is producing the correct result but I need to add an upper and lower limit of 2700 and 2300 which is where I'm getting stuck.

I'm struggling to figure out how to add this to the formula.

For now I have utilized an IF function to keep the values in between the parameters.

=IF(D3>2500,(2500),(IF(D3<2300,2300,D3)))

Is anyone able to assist, please?

Thank you for the help

Hi jailed and welcome to the forum,

You could look at the Median function to limit the answers. If the Rand() is between the bottom and top then it is returned. If the Rand() is greater than the top then the top is returned and etc for the bottom.

hope that helps. It is kind of a trick but should work for you.