Re:Building Tic-Tac-Toe in a Google spreadsheet [video]
by rahimnathwani on Sunday March 12, 2017 @11:16PM
(#13854989)
Yup. A few rules I try to follow when designing spreadsheets that will be used for more than 15 minutes:
- Any cell that contains a numerical value (as opposed to a formula) is highlighted. All such cells are at the top of the first sheet.
- Never ever use VLOOKUP or HLOOKUP, as inserting columns or rows will break them. Use INDEX and MATCH instead.
- Never use OFFSET, as it's a 'volatile' function, meaning Excel will recalculate the value for any cell which contains it, if any value in the sheet changes. Use INDEX instead.
- When you're tempted to enter a value directly in a formula (e.g. when you divide by 12 for the number of months in a year), just don't do it. Move the value to an input cell. This goes also for parameters in an OFFSET formula.
- Any cell that contains a numerical value (as opposed to a formula) is highlighted. All such cells are at the top of the first sheet.
- Never ever use VLOOKUP or HLOOKUP, as inserting columns or rows will break them. Use INDEX and MATCH instead.
- Never use OFFSET, as it's a 'volatile' function, meaning Excel will recalculate the value for any cell which contains it, if any value in the sheet changes. Use INDEX instead.
- When you're tempted to enter a value directly in a formula (e.g. when you divide by 12 for the number of months in a year), just don't do it. Move the value to an input cell. This goes also for parameters in an OFFSET formula.