Hi

I am developing an AFL football score calculator using the RAND function.

Is there a function that can default a cell to "0" after a random number has been created.

I use F9 to do the random number, is there a formula or funtion that I can use to default that cell?

Any help is appreciated, thanks in advance.