=IF(A1="yes",RAND(),"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Greg" wrote in message
...
Is there anychance of if a certaion criteria is met for the if function to
place a code in that cell

i.e.

cell a1 say yes

use the if function to put the =rand() code into cell a2


Thanks

Greg