Informational functions in Canva Sheets
Informational functions help you check the type or status of a value, such as whether it's text, a number, or an error. These are useful for data validation and error handling.
FUNCTION | WHAT IT DOES | EXAMPLE |
ERROR.TYPE | Returns a number corresponding to an error type. | =ERROR.TYPE(error_val) |
ISERR | Returns TRUE if the value is any error except #N/A. | =ISERR(value) |
ISEVEN | Returns TRUE if the number is even. | =ISEVEN(number) |
ISLOGICAL | Returns TRUE if the value is a logical value. | =ISLOGICAL(value) |
ISNA | Returns TRUE if the value is a #N/A error. | =ISNA(value) |
ISNONTEXT | Returns TRUE if the value is not text. | =ISNONTEXT(value) |
ISNUMBER | Returns TRUE if the value is a number. | =ISNUMBER(value) |
ISODD | Returns TRUE if the number is odd. | =ISODD(number) |
ISREF | Returns TRUE if the value is a reference. | =ISREF(value) |
ISTEXT | Returns TRUE if the value is text. | =ISTEXT(value) |
N | Converts a value to a number. | =N(value) |
TYPE | Returns the type of a value as a number. | =TYPE(value) |
Was this helpful?
Helpful
Unhelpful