I have a darts scoreboard with the following formula in a cell:

=IF(P11<0,"BUST",VLOOKUP(P11,'Checkout Sheet'!A3:B704,2,0))

Essentially what this does is check the scoreboard, and if the score is less than 0, then it says BUST. If not, then it looks up a table to determine what darts need to be thrown to finish.

Up until now, if a player is bust, they just add 0 into the score to stay on the same score. What would I need to add so that if a player was bust, it automatically changed the cell to 0, so therefore reset the scoreboard to what it was?

e.g. if a player was on 4 (double 2), but scored 5, they could enter 5 as their score, a message would appear to say "BUST", then the score changes to 0.

Thanks in advance