isnumber-of-integer |
ISNUMBER |
=ISNUMBER(42) |
value |
|
isnumber-of-decimal |
ISNUMBER |
=ISNUMBER(3.14) |
value |
|
isnumber-of-text |
ISNUMBER |
=ISNUMBER("hello") |
value |
|
isnumber-of-numeric-text |
ISNUMBER |
=ISNUMBER("42") |
value |
1 |
isnumber-of-boolean |
ISNUMBER |
=ISNUMBER(TRUE) |
value |
1 |
isnumber-of-blank-cell |
ISNUMBER |
=ISNUMBER(A1) |
value |
|
isnumber-of-number-cell |
ISNUMBER |
=ISNUMBER(A1) |
value |
|
isnumber-of-error |
ISNUMBER |
=ISNUMBER(1/0) |
error-code |
|
istext-of-text |
ISTEXT |
=ISTEXT("hello") |
value |
|
istext-of-empty-string |
ISTEXT |
=ISTEXT("") |
value |
|
istext-of-number |
ISTEXT |
=ISTEXT(42) |
value |
|
istext-of-boolean |
ISTEXT |
=ISTEXT(TRUE) |
value |
|
istext-of-blank-cell |
ISTEXT |
=ISTEXT(A1) |
value |
|
istext-of-text-cell |
ISTEXT |
=ISTEXT(A1) |
value |
|
istext-of-error |
ISTEXT |
=ISTEXT(1/0) |
error-code |
|
isnontext-of-number |
ISNONTEXT |
=ISNONTEXT(42) |
value |
|
isnontext-of-text |
ISNONTEXT |
=ISNONTEXT("hello") |
value |
|
isnontext-of-boolean |
ISNONTEXT |
=ISNONTEXT(TRUE) |
value |
|
isnontext-of-blank-cell |
ISNONTEXT |
=ISNONTEXT(A1) |
value |
|
isnontext-of-error |
ISNONTEXT |
=ISNONTEXT(1/0) |
error-code |
|
islogical-of-true |
ISLOGICAL |
=ISLOGICAL(TRUE) |
value |
1 |
islogical-of-false |
ISLOGICAL |
=ISLOGICAL(FALSE) |
value |
1 |
islogical-of-number |
ISLOGICAL |
=ISLOGICAL(1) |
value |
|
islogical-of-text |
ISLOGICAL |
=ISLOGICAL("TRUE") |
value |
|
islogical-of-blank-cell |
ISLOGICAL |
=ISLOGICAL(A1) |
value |
|
islogical-of-error |
ISLOGICAL |
=ISLOGICAL(1/0) |
error-code |
|
isblank-of-blank-cell |
ISBLANK |
=ISBLANK(A1) |
value |
|
isblank-of-number-cell |
ISBLANK |
=ISBLANK(A1) |
value |
|
isblank-of-text-cell |
ISBLANK |
=ISBLANK(A1) |
value |
|
isblank-of-empty-string-cell |
ISBLANK |
=ISBLANK(A1) |
value |
|
isblank-of-literal-number |
ISBLANK |
=ISBLANK(42) |
value |
|
isblank-of-literal-empty-string |
ISBLANK |
=ISBLANK("") |
value |
|
iserr-of-div-0 |
ISERR |
=ISERR(1/0) |
value |
|
iserr-of-na |
ISERR |
=ISERR(NA()) |
value |
|
iserr-of-number |
ISERR |
=ISERR(42) |
value |
|
iserr-of-text |
ISERR |
=ISERR("hello") |
value |
|
iserr-of-blank-cell |
ISERR |
=ISERR(A1) |
value |
|
iserror-of-div-0 |
ISERROR |
=ISERROR(1/0) |
value |
|
iserror-of-na |
ISERROR |
=ISERROR(NA()) |
value |
|
iserror-of-value |
ISERROR |
=ISERROR("a"+1) |
value |
|
iserror-of-number |
ISERROR |
=ISERROR(42) |
value |
|
iserror-of-text |
ISERROR |
=ISERROR("hello") |
value |
|
iserror-of-blank-cell |
ISERROR |
=ISERROR(A1) |
value |
|
isna-of-na |
ISNA |
=ISNA(NA()) |
value |
|
isna-of-div-0 |
ISNA |
=ISNA(1/0) |
value |
|
isna-of-number |
ISNA |
=ISNA(42) |
value |
|
isna-of-text |
ISNA |
=ISNA("hello") |
value |
|
isna-of-match-miss |
ISNA |
=ISNA(MATCH(99, {1,2,3}, 0)) |
value |
|
isformula-of-formula-cell |
ISFORMULA |
=ISFORMULA(A1) |
value |
2 |
isformula-of-number-cell |
ISFORMULA |
=ISFORMULA(A1) |
value |
2 |
isformula-of-blank-cell |
ISFORMULA |
=ISFORMULA(A1) |
value |
2 |
isformula-of-text-cell |
ISFORMULA |
=ISFORMULA(A1) |
value |
2 |
isref-of-single-cell |
ISREF |
=ISREF(A1) |
value |
|
isref-of-range |
ISREF |
=ISREF(A1:A3) |
value |
|
isref-of-literal-number |
ISREF |
=ISREF(42) |
value |
1 |
isref-of-literal-text |
ISREF |
=ISREF("A1") |
value |
1 |
isref-of-indirect-valid |
ISREF |
=ISREF(INDIRECT("A1")) |
value |
|
isdate-of-date-string |
ISDATE |
=ISDATE("2024-01-15") |
value |
|
isdate-of-number |
ISDATE |
=ISDATE(42) |
value |
2 |
isdate-of-text |
ISDATE |
=ISDATE("hello") |
value |
2 |
isdate-of-date-call |
ISDATE |
=ISDATE(DATE(2024,1,15)) |
value |
2 |
isemail-valid |
ISEMAIL |
=ISEMAIL("[email protected]") |
value |
2 |
isemail-invalid |
ISEMAIL |
=ISEMAIL("not-an-email") |
value |
2 |
isemail-of-number |
ISEMAIL |
=ISEMAIL(42) |
value |
2 |
isemail-of-blank-cell |
ISEMAIL |
=ISEMAIL(A1) |
value |
2 |
n-of-number-info |
N |
=N(42) |
value |
|
n-of-text |
N |
=N("hello") |
value |
|
n-of-true-info |
N |
=N(TRUE) |
value |
2 |
n-of-false-info |
N |
=N(FALSE) |
value |
2 |
n-of-blank-cell |
N |
=N(A1) |
value |
|
n-of-error-info |
N |
=N(1/0) |
error-code |
|
na-nullary |
NA |
=NA() |
value |
|
na-used-in-arithmetic |
NA |
=NA()+1 |
value |
|
type-of-number |
TYPE |
=TYPE(42) |
value |
|
type-of-text |
TYPE |
=TYPE("hello") |
value |
|
type-of-boolean |
TYPE |
=TYPE(TRUE) |
value |
|
type-of-error |
TYPE |
=TYPE(1/0) |
error-code |
|
type-of-array |
TYPE |
=TYPE({1,2,3}) |
value |
|
type-of-blank-cell |
TYPE |
=TYPE(A1) |
value |
|
error-type-of-div-0-info |
ERROR.TYPE |
=ERROR.TYPE(1/0) |
error-code |
1 |
error-type-of-na |
ERROR.TYPE |
=ERROR.TYPE(NA()) |
error-code |
1 |
error-type-of-value-info |
ERROR.TYPE |
=ERROR.TYPE("a"+1) |
error-code |
1 |
error-type-of-non-error-number |
ERROR.TYPE |
=ERROR.TYPE(42) |
error-code |
1 |
error-type-of-non-error-text |
ERROR.TYPE |
=ERROR.TYPE("hello") |
error-code |
1 |
error-type-of-ref-error |
ERROR.TYPE |
=ERROR.TYPE(INDIRECT("ZZZZ99999999")) |
error-code |
2 |
cell-address |
CELL |
=CELL("address", A1) |
value |
1 |
cell-contents |
CELL |
=CELL("contents", A1) |
value |
1 |
cell-row |
CELL |
=CELL("row", B3) |
value |
1 |
cell-col |
CELL |
=CELL("col", B3) |
value |
1 |
cell-type-text |
CELL |
=CELL("type", A1) |
value |
1 |
cell-format |
CELL |
=CELL("format", A1) |
format |
|
sheets-no-arg |
SHEETS |
=SHEETS() |
value |
|
sheets-of-reference |
SHEETS |
=SHEETS(A1) |
value |
|