If function

[Bob Phillips]

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

--

HTH

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

 

[CLR]

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

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

Vaya con Dios,
Chuck, CABGx3

 

[Greg]

just checking the time
changed a setting

Greg

 

[Arvi Laanemets]

Hi

Check your time zone!


Arvi Laanemets

 

[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

 

[Greg]

thanks Bob

Greg

 

[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