=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

Greg...........

Please check your system clock..........

Vaya con Dios,
Chuck, CABGx3


"Greg" wrote in message
...
thanks Bob

Greg

just checking the time
changed a setting

Greg

Hi

Check your time zone!


Arvi Laanemets


"Greg" wrote in message
...
CLRI

believe it is fine I am from Australia so when I post it is using the
correct time on both my system clock and windows clock.

If I am not looking in the right place please let me know

Thanks

Greg

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

thanks Bob

Greg

CLRI

believe it is fine I am from Australia so when I post it is using the
correct time on both my system clock and windows clock.

If I am not looking in the right place please let me know

Thanks

Greg