Forum Discussion
rrkumarr
Sep 21, 2020Copper Contributor
Dynamic cells always turning to N/A or spill, formulas correct
Hello community, I have been working on this sheet for hours trying to figure out what my mistake is, but have not succeeded. Even though my formulas are correct, I only gather proper numerical r...
rrkumarr
Sep 21, 2020Copper Contributor
Thank you SergeiBaklan
According to your suggestions, I tired =RANDBETWEEN(0.0015,1) but it only outputs 1. Any further tips?
Thanks
SergeiBaklan
Sep 21, 2020Diamond Contributor
That's like
=RANDBETWEEN(15,10000)/10000
or so, function returns integers between bottom and top.