How can you check if a cell or value is not null in Google Sheets? There are several ways to check if a cell is not null in Google Sheets with formulas like ISBLANK() or simple operator checks...
Category: Spreadsheets
Are you looking to learn how to use the Google Sheets QUERY function to select and filter data based on specific conditions? In this blog post, you'll explore the ins and outs of the powerful...
What is a named function in Google Sheets and when is it best to use this new feature in your spreadsheet? Google Sheets new Named Functions feature enables you to refactor long formulas into what...
Google Sheets SWITCH Formula Example: Refactor IF Functions By 20%
How do you use the Google Sheets SWITCH() formula? The SWITCH() formula in Google Sheets enables you to compress a series of IF statements, even nested IF statements, into one succinct...
How can you set a default value when using the VLOOKUP function? As VLOOKUP throws an #N/A error when the searched item cannot be found in the first column range, wrap the VLOOKUP function in an...
3 Different Ways To Underline In Google Sheets: Shortcuts, Borders & Formulas
How many ways can you underline in Google Sheets? There are three broad approaches when seeking to emphasise text in Google Sheets by applying underlines. These three approaches are: underlying...
