Operations in Google Sheets
Google Sheets
Format Pivot Tables in Google Sheets (Step-by-Step)
Pivot tables offer an easy way to summarize the values of a dataset.
This tutorial provides a step-by-step example of how to create and format...
Google Sheets
Google Sheets: A Simple Formula for “If Contains”
You can use the following formula in Google Sheets to determine if a cell contains a certain string:
=IF(REGEXMATCH(B1, "this"), 1, 0)
In this example, if...
Google Sheets
Google Sheets: How to Use COUNTIF with Multiple Ranges
The COUNTIFS() function in Google Sheets can be used to count the number of rows in a spreadsheet that meet multiple criteria.
This function uses...
Google Sheets
How to Round to Significant Figures in Google Sheets
Often you may want to round a value to a certain number of significant figures in Google Sheets.
You can use the following formula to...
Google Sheets
Google Sheets: Change Color when Checkbox is Checked
You can use the custom formula function in Google Sheets to change the color of a cell when a checkbox is checked.
The following example...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read