How to use the ISNONTEXT function in Google Sheets
If you have ever tried to check the type or state of a value before acting on it in Google Sheets and ended up wrestling with awkward workarounds, the ISNONTEXT function is…
Continue reading →Category
Info formulas
18 tutorials in this category. Each one walks through the syntax, an example, and the small mistakes that quietly break things in real spreadsheets.
How to use the ISNUMBER function in Google Sheets
If you have ever tried to check the type or state of a value before acting on it in Google Sheets and ended up wrestling with awkward workarounds, the ISNUMBER function is…
Continue reading →How to use the ISREF function in Google Sheets
If you have ever tried to check the type or state of a value before acting on it in Google Sheets and ended up wrestling with awkward workarounds, the ISREF function is…
Continue reading →How to use the ISTEXT function in Google Sheets
If you have ever tried to check the type or state of a value before acting on it in Google Sheets and ended up wrestling with awkward workarounds, the ISTEXT function is…
Continue reading →How to use the N function in Google Sheets
If you have ever tried to check the type or state of a value before acting on it in Google Sheets and ended up wrestling with awkward workarounds, the N function is…
Continue reading →How to use the NA function in Google Sheets
If you have ever tried to check the type or state of a value before acting on it in Google Sheets and ended up wrestling with awkward workarounds, the NA function is…
Continue reading →How to use the SHEETS function in Google Sheets
If you have ever tried to check the type or state of a value before acting on it in Google Sheets and ended up wrestling with awkward workarounds, the SHEETS function is…
Continue reading →How to use the TYPE function in Google Sheets
If you have ever tried to check the type or state of a value before acting on it in Google Sheets and ended up wrestling with awkward workarounds, the TYPE function is…
Continue reading →How to use the CELL function in Google Sheets
If you have ever tried to check the type or state of a value before acting on it in Google Sheets and ended up wrestling with awkward workarounds, the CELL function is…
Continue reading →