Is it possible to test for integers or strings in a Google Spreadsheet and respond to each differently?
migrated from superuser.com Feb 22 '11 at 11:08
This question came from our site for computer enthusiasts and power users.
To test for string you can use
To test for an Integer you will need to do something like this:
Which basically converts the value to an Integer and then checks if it is the same as the original pre-converted value.
You should be able to use the following function:
Which returns either TRUE or FALSE.