Is it possible to output a type as "int" if we select from say A1:A5, contains (1,2,3,4,5);
but output a type as "string" if we have (1,2,hello,4,5)
Is it possible to output a type as "int" if we select from say A1:A5, contains (1,2,3,4,5);
but output a type as "string" if we have (1,2,hello,4,5)
Sure, use ISNUMBER() function true is numeric false is something else but then for each cell in the chosen range,
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Try:
=IF(ISERROR(SUMPRODUCT(A1:A5+0)),"string","int")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks