The CHOOSE Function in Google Sheets lets you choose between different options. It’s a lookup function, akin to a limited VLOOKUP rather than an alternative to the IF function. It takes an index number and returns a value at that numbered position from the list of possible options. Here’s a simple example: =CHOOSE(1,”A”,”B”) which will … Continue reading How To Use The Choose Function In Google Sheets
Arrays in Google Sheets are collections of data, consisting of rows and columns. You can use arrays in formulas in the same way that you use regular A1-type ranges. You construct arrays in Google Sheets with curly brackets: { } They’re also known as ARRAY LITERALS.
June 2024 update: Google announced they’ve doubled the speed of calculations in Google Sheets! 🎉 So hopefully you won’t need as many of these ideas anymore 😉 Slow Google Sheets? We’ve all been there, stuck watching the little loading bar creep slowly, frustratingly to its conclusion: How can you speed up a slow Google Sheet? … Continue reading Slow Google Sheets? Here are 27 Ideas to Try Today 🐢
The IFS function in Google Sheets is used to test multiple conditions and outputs a value specified by the first test that evaluates to true. It’s akin to a nested IF formula, although it’s not exactly the same. However, if you find yourself creating a nested IF formula then it’s probably easier to use this … Continue reading IFS Function in Google Sheets
The INDIRECT function in Google Sheets is used to convert text strings into valid cell or range references. For example, the INDIRECT function will convert the text string “A1” into the cell reference A1. The formula is: =INDIRECT(“A1”) which is equivalent to this formula: = A1 It gives the answer 10 in the following example … Continue reading INDIRECT Function in Google Sheets
