I have a sheet which generates numbers using the =rand() function but it has
started producing some negative numbers, when they should only produce
numbers between 0 and 1. This has only happened recently, and if i try a
formula for example rand()*(1.5-0.5)+0.5, it generates numbers lower than
0.5 occasionally. Does anyone have an explanation for this, or an idea of
how i could return it to the origional method?