Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.
The REPT function in Google Sheets is used to repeat an expression a set number of times. The REPT formula to repeat “Go! ” three times is: =REPT(“Go! “, 3) Notice the additional space added after the exclamation point, so that there is a space between the repeated values in the output.
The IF function in Google Sheets is used to make decisions with your data. It’s from the Logical family of functions in Google Sheets. In this tutorial, you’ll see how to use IF formulas in Google Sheets to make decisions with your data. What does the IF Function do? At its heart, the IF function … Continue reading IF Function in Google Sheets
Earlier this year, The Washington Post told a story about the effects of Coronavirus on the US workforce, and illustrated the story with grid charts. Grid charts can show you the breakdown of the whole into constituent parts, to allow at-a-glance understanding of the big picture. In this post, I’ll show you how to create … Continue reading How To Create A Grid Chart In Google Sheets
2024 Update: Table’s features and capabilities are now integrated into AppSheet. Read more here. 2020 Launch: Here’s something to get excited about: Google just launched a new workflow automation tool! Google Tables is a tool for teams and businesses that combines the flexibility of a spreadsheet with the power of a database. Best of all, … Continue reading Google Tables: How I Use Google’s New Workflow Tool
The future of Google Sheets is analyzing millions, even billions, of rows of data with regular formulas and pivot tables. The future of Google Sheets is Connected Sheets. That’s a bold claim, so let’s explore it. Check out this formula operating on 1.5 billion rows of data: I just ran a COUNT function across 1.5 … Continue reading Connected Sheets: Analyze Big Data In Google Sheets