How can i generate a random number between 0.8 and 1.2

[hawkinsr86]

hi guys,

Is it possible to use the =randbetween() function to generate a random number between 0.8 and 1.2.

thanks

[ragulduy]

randbetween does integers, so you would need to do something like:
=randbetween(8,12)/10
which would give you one decimal place.
=RANDBETWEEN(8000,12000)/10000
would give you four decimal places
and so on

[hawkinsr86]

cheers mate

[MrShorty]

Or use the RAND() function, which generates a random real number between 0 and 1. http://office.microsoft.com/en-us/ma...974.aspx?CTT=1 The help file also explains how to use the RAND() function to get a random number between any real numbers a and b =rand()*(b-a)+a

[AnthonyBlignault]

Now that's something new. Thank you