View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pozman Pozman is offline
external usenet poster
 
Posts: 1
Default Defaulting a random number


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.


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