How can i generate a random number between 0.8 and 1.2

hi guys,

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

thanks

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

cheers mate

Now that's something new. Thank you