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