Geezer. The procedure you model in your spreadsheet does not reflect the way the game show host acts.
The conclusion you draw from it would be valid if the organisers put £ 2,400 in an envelope then spun a coin to determine whether £ 1,200 or £ 4,800 goes into the second.
But they don't. They decide (we don't how) two amounts, one twice the other, to go into two envelopes. They then pass one of these chosen at random to the contestant. The difference between the two procedures does make a difference!
I realise that you always gave the contestant a £ 2,400 envelope because that figure was given in the OP, but Factor30 has explained that this figure wass just an example. The game show would provide poor entertainment, if successive contestants received the same amount each time!
So can you agree that the real problem is : Two envelopes are prepared, one containing twice the amount of the other. One of these, chosen at random, is given to a contestant who sees the amount and may then either keep it or exchange it for the other?
To test the benefits of swapping, your spreadsheet might be something like this
Column 1 - a random amount, chosen between limits
Column 2 - an amount twice Column 1
Column 3 - a random choice of Col 1 or Col 2
Column 4 - the amount not put into Col3
The total of Col 3 is the amount won with no swaps
The total of Col 4 is the amount won with swapping