What're differences between ISTEXT ISNONTEXT ISNUMBER?

Hello everybody

I try to compare the result of using ISTEXT ISNONTEXT ISNUMBER

Please see the sample file for your understand.


Range B3:B15 Naming as Data

When I input '200 or ="200" after that using ISNONTEXT ISTEXT ISNUMBER to
check data the return results are FALSE TRUE FALSE.

When using isnumber istext isnontext to check data in cell B2 (contatin
2) return True, False, True.

When check the blank cell ISNONTEXT return True while ISNUMBER return false.
These results was come in my doubt that why using ISNUMBER return FALSE not return TRUE. Because in my understand that ISNONTEXTmean is the data that we determine is number or not


Thank you for your advice.

sincerely yours