IF Statement Help

[darkblueblood]

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

[windy58]

It would help if you could upload a sample workbook.

Needs to include existing formulas and data (for the vlookup)

For someone to recreate this from scratch could be problematic.

[darkblueblood]

Coupar Villa Darts Scoreboard No Home Away.xlsm

Don't know if this has worked or not, but tried to attach the spreadsheet. The formula in question is on the 2 player scoreboard in cells D21 and P21.

Feel free to play about and offer suggested improvements. I've got limited Excel knowledge