Ok here is what I am looking to do. I am using
randbetween(1,A5) *lets say the output is 5*
now I change the number in b25 the random number above will change.

Is there a way that I can get a random number, then keep that number static? I want a random number but once generated I don't want it to change if that makes any sence.