Forum Discussion
rand function only giving mre 0 and 1
im only getting 0 and 1 when i use random function
Make sure that the cells with the =RAND() formula are formatted as General, or as Number with several decimal places. If they are formatted as Number with 0 decimal places, the displayed value will be rounded to the nearest whole number, i.e. 0 or 1.