Excel randomly choose Yes or No.
Use CHOOSE and RANDBETWEEN for a roughly 50/50 split.
Or use IF and RAND to generate an approximate percentage of one or the other.