Manuals/calci/IS FUNCTIONS
Syntax
Examples-1
''''''' ''''
Description
These are the nine worksheet functions used for testing the type of a value or reference.The function displays 1 or 0 depending on the outcome.
IS FUNCTIONS
=ISLOGICAL(TRUE) is 1
=ISLOGICAL(“TRUE”) is 0
=ISNUMBER(4) is 1
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1 | |||
| Row2 | 0 | |||
| Row3 | 1 | |||
| Row4 | ||||
| Row5 | ||||
| Row6 |
ISBLANK(V)
ISERR(V)
ISERROR(V)
ISLOGICAL(V)
ISNA(V)
ISNONTEXT(V)
ISNUMBER(V)
ISREF(V)
ISTEXT(V)
ISERR(V)
ISERROR(V)
ISLOGICAL(V)
ISNA(V)
ISNONTEXT(V)
ISNUMBER(V)
ISREF(V)
ISTEXT(V)
where V is the value that is to bet tested.
|
|
|
|
|
|
|
ISBLANK |
V refers to an empty cell. |
|
ISERR |
Vl refers to any error value except #N/A. |
|
ISERROR |
V refers to any error value |
|
ISLOGICAL |
V refers to a logical value. |
|
ISNA |
V refers to the NaN error value. |
|
ISNONTEXT |
V refers to any item that is not text. |
|
ISNUMBER |
V refers to a number. |
|
ISREF |
V refers to a reference. |
|
ISTEXT |
V refers to text. |
Examples-2
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | Welcome | 0 | sav123 | 1 |
| Row2 | NaN | 0 | ||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
Let's see another example in Column1Row1
Let C1R1 = Welcome
=ISBLANK(C1R1) is 0
Let C3R1 = sav123
=ISTEXT(C3R1) is 1
///rly C1R2 = NaN
=ISERR(C1R2) is 0