samedi 20 août 2022

Randbetween until a specific day?

I want to have the randbetween function only return a random number until a specific day, then stop changing. Is there a way to accomplish this in googlesheets?

=IF(today()<F1,randbetween(1,10),)

I tried something like this, but it would just go blank if it's false.




Aucun commentaire:

Enregistrer un commentaire