Type Functions In AFC
Type Functions
The supported type functions are shown by example below:
ISTEXT (does not support blanks!)
| A | B | C | ||
| 2 | true | =ISTEXT( C2 ) | Abc | |
| 3 | true | ... | Абвгд | |
| 4 | true | ... | 12345 | |
| 5 | false | ... | 12345.0 | |
| 6 | false | ... | true |
ISNONTEXT (does not support blanks!)
| A | B | C | ||
| 8 | false | =ISNONTEXT( C8 ) | Abc | |
| 9 | false | ... | Абвгд | |
| 10 | false | ... | 12345 | |
| 11 | true | ... | 12345.0 | |
| 12 | true | ... | true |
ISNUMBER (does not support blanks and logical values!)
| A | B | C | |||
| 14 | false | =ISNUMBER( C14 ) | Abc | ||
| 15 | false | ... | Абвгд | ||
| 16 | false | ... | 12345 | ||
| 17 | true | ... | 12345.0 | ||
| 18 | true | ... | 39117.0 | ||
| 19 | true | ... | true | Excel says: false | |
| 20 | true | ... | false | Excel says: false |