I think I've hit the upper limit level for random generating numbers... Is there any workaround for this? I need to generate 10 unique random numbers in one formula/string and it always must be a 19 digit number.
I have this: =TRUNC (RAND() * (9999999999999999999 - 1) + 1)
but spreadsheet rewrites it to: =TRUNC (RAND() * (9999999999999990000 - 1) + 1) so I guess the limit is 9999999999999990000. is there a bypass? thx
Aucun commentaire:
Enregistrer un commentaire