RAND with decimals

[D4WNO]

Hi, from reading another thread HERE, I think I've nearly figured out what I need

=RANDBETWEEN($W$1,$X$1)+(ROUND((RAND()),2))

W1=4.6 (minimum to randomly select)
X1=6.4 (maximum to randomly select)

The final 2 is because I need the results format to come out as 4.54 or 5.67 for example.

For some reason it's still randomly generating 6.9 for example which is above my max, any ideas why?

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=RANDBETWEEN($W$1*100,$X$1*100)/100

 

[D4WNO]

Thank you, on both counts

 

[Fluff]

You're welcome & thanks for the feedback.