Hi All,
Issue: I have a formula herein which includes the RANDBETWEEN function. However, I have just noticed that it is volatile function.Formula:
=IF(AND(B3="",C3="",D3=""),"",CONCATENATE("Student ",B3,"-",C3,"-",RANDBETWEEN(0,500000)))
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![]()
Bookmarks