RAND Between

[indygo]

hi guys,

Two cells question with random numbers formula:

In A1 I have random number generator in a range from 1 to 99.
= RANDBETWEEN(1,99)

In B1 I want to add formula which would fluctuate values from A1 but within a certain range. So I have in B1 this formula:

=A1+RANDBETWEEN(-25,25)

That's the range I want B1 to move randomly. Now the problem is, I don't want B1 to go above or below the range of 1 to 99. If A1 generates random number let's say 5
and B1 generates -25 it will create -20. Now I want to avoid that.

Can we make b1 to be still random within that range but never exit range of 1-99?

I know I can make both cells random but they have to be related and move within a certain range.

thanks

 

[indygo]

Thanks.
Yes I'm aware of that. That's why I'm using full range in the main one 1-99. Second one is just simulating disagreement in values between first column and second. I'm checking various scenarios using different brackets in b1.

Thanks for pointing that out though.