@daredevil said:
@daredevil said:
Same with RAND()...
If the formula is the same, the result is the same.
@jim said:
Here's what I did. 3 identical formulas, 3 different values between 1 and 5.
I was intresded with your video : all the opposite to my experience !!
So... I tested and tested again, and finally I understand why !!!
If you type in uppercase (RAND() or RANDBETWEEN(1,5)) or use the help to insert function (that write it in uppercase), same formulas produce same result.
But if you write in lowercase (rand() or randbetween(1,5)) each folmula produce a different result, the random is "realy" random !
If you use mixed case, Rand() produce same result as other Rand(), but different to RaNd() that produce same as other RaNd()...
I used to type in uppercase in DC, but now, I will always use lowercase, like in Ruby
Thanks Jim for you exemple
If anybody was going to provide an answer . . . . it was shure to be SketchUcation. THANKS.