Should you switch? Simulate this situation 1000 times. For each replication use an @RISK function to generate the door that leads to the prize. Then use another @RISK function to generate the door that Monty will open.

Assume that Monty plays as follows: Monty knows where the prize is and will open an empty door, but he cannot open door