Did you know you can create an interactive online Tic Tac Toe game in 5 steps? Google spreadsheets makes this possible! Two beautiful features of a Google spreadsheet are 1) it is online-based, so anyone with an Internet connection can play; and 2) Google spreadsheets are free! To access it, view our post: spreadsheetsolving.com/access
Interested in learning how to create this? While there are many ways to solve this problem, a 5-step sample action is below.
View a Tic Tac Toe game in action! Tic Tac Toe: 2 Minute Video
5 step sample plan
- Open a Google spreadsheet and select 9 cells to be the board game.
- Use Data Validation so that each cell in your game board allows the user to select only an X or an O.
- Write a formula that indicates when a winning combination occurs (e.g. 3 consecutive X’s or O’s across any vertical, horizontal, or diagonal line). One potential solution is to use the IF, AND, and OR functions.
- If you’d like to indicate who the winner is on the top of the board game, write a formula using a Nested IF function.
- Format the board game to your heart’s content, using text background colors, font size, and borders
What are the exact formulas? We’d like to give you a chance to figure them out! Stuck on what to do? At the bottom of the post, check out our video tutorials to understand the functions. Once you have a solution and want to compare it against ours, email us with your solution, and we’ll send you ours (spreadsheetsolving@gmail.com). Of course, if you have questions or comments, reply to this post below, and we’ll respond!
Nice post. I was checking continuously this blog and I’m impressed!
Very useful information particularly the last
part 🙂 I care for such information much. I was seeking
this certain information for a very long time. Thank you and
best of luck.
What if i want to create a game of chance kind of like a deal or no deal, but various factors happen in each round. How would one go about that?