Pozman Wrote:
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.
Hi Pozman,

I assume you want the "0" in another cell?

Try something like this in cell B1

=IF(A10,0,"") if your random number is in A1, B1 will be 0, otherwise
nothing

Alter cell ref's to suit

Is this what you are looking for?

oldchippy


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=566384