Spreadsheet

How to Return Value When The Logical Expression is FALSE in IFS

How to Return Value When The Logical Expression is FALSE in IFS

There is a major difference between Google Sheets IFS and IF. I'll explain you what's this difference and how to overcome it. From the title, how to return value when the logical expression is...
Extract Multiple Words Using Regexextract

How to Extract Multiple Words Using Regexextract in Google Sheets

We can extract multiple words in a cell into a row or column in Google Sheets. We can use a REGEXEXTRACT formula for this purpose. So learn the simple steps to extract multiple words using REGEXEXTRACT...
How to Limit a Column Total Within a Specific Value

How to Limit a Column Total Within a Specific Value

Some times you may want to limit the total amount in a column within a specific rage. I can give you several real life examples to this specific use. So, in this tutorial I...
How to Highlight All the Cells with Formulas in Google Sheets

How to Highlight All the Cells with Formulas in Google Sheets

Many Google Spreadsheet users think that it's not possible to highlight all the cells with formulas in Google Sheets. But it's possible. They may think so because there is no alternative to Excel's "Go...
How to Use the function ISFORMULA in Google Sheets

How to Use the Function ISFORMULA in Google Sheets

Straight to the point. Learn how to use the function ISFORMULA in Google Sheets. Actually there is nothing in detail to learn about this function. So I'm directly going to the syntax part, purpose...
How to Use MINA Function in Google Sheets

How to Use MINA Function in Google Sheets and Difference With MIN

MINA is a statistical function in Google Sheets to find the minimum value in a range. Don't use this function as an alternative to MIN or SMALL. Let's see how to use MINA function...
How to Use IF Function to Test a Sentence for a Text

How to Use IF Function to Test a Sentence for a Text in Google...

You can learn here an awesome trick using IF, the popular Logical Test function in Google Sheets. With this tutorial titled how to use IF Function to test a sentence for a text, I...
Extract Top N Number of Items From a Data Range

Extract Top N Number of Items From a Data Range in Google Sheets

I have a sales report in Google Sheets where I want to extract only the top 5 items based on sales volume. Is it possible, and if possible, how to do that? Yup! It's...