Random outcome based on set criteria on refresh

Hi,

I am looking to find a formula that will provide me with any of the following variables randomly:

Yes
No
Ongoing

Ideally this will be triggered every time an F9/refresh is initiated.

Any help would be appreciated...

How about:

=IF(RAND()<=1/3,"YES",IF(RAND()>1/2,"NO","ONGOING"))

perfect. Many thanks!