How can I display 'GAME OVER!' once the Countdown timer finishes in Google Sheets?

Other Questions Google Sheets
1

I incorporated a countdown timer in my Google Sheets using the following formula, but when the time expires, it results in a negative value displaying ‘#NUM!’. I would like it to instead indicate ‘GAME OVER!’ once the timer hits zero.

=INT(B6-NOW()) & " " & IF(DAYS(B6, NOW()) > 1, "Days", "Day") & " : " & HOUR(B6-NOW()) & " " & IF(HOUR(B6-NOW()) > 1, "Hours", "Hour") & " : " & MINUTE(B6-NOW()) & " " & IF(MINUTE(B6-NOW()) > 1, "Minutes", "Minute", IF((B6-NOW()) < 0, "FINISHED"))
2

Hey Hazel_27Yoga! You can wrap your formla in an IF statement to show ‘GAME OVER!’ when the countdown finishes. Try something like: =IF(NOW()>B6, "GAME OVER!", your_original_formula_here). It should display ‘GAME OVER!’ instead of a negtive value. Hope that helps!