Carmel wrote:
My formula for a lottery number selector is =INT(49*RAND())

FYI, if your intent is to generate numbers between 1 and 49 inclusive,
the formula should be 1+INT(49*RAND()).