How to use the ERROR.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 ERROR.TYPE 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 ISBLANK 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 ISBLANK function is…
Continue reading →How to use the ISDATE 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 ISDATE function is…
Continue reading →How to use the ISEMAIL 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 ISEMAIL function is…
Continue reading →How to use the ISERR 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 ISERR function is…
Continue reading →How to use the ISERROR 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 ISERROR function is…
Continue reading →How to use the ISFORMULA 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 ISFORMULA function is…
Continue reading →How to use the ISLOGICAL 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 ISLOGICAL function is…
Continue reading →How to use the ISNA 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 ISNA function is…
Continue reading →