Hi All,

Issue: I have a formula here
Formula: copy to clipboard
=IF(AND(B3="",C3="",D3=""),"",CONCATENATE("Student ",B3,"-",C3,"-",RANDBETWEEN(0,500000)))
in which includes the RANDBETWEEN function. However, I have just noticed that it is volatile function.

Trying to do: Would it be possible to include in the above formula somehow where a static random number is generated?

Thanks in advance for any help given and let me know if further information is needed