=TYPESTRING(1) -> "Number" =TYPESTRING(TRUE) -> "Boolean" =TYPESTRING("What is love?") -> "String" =TYPESTRING(#REF!) -> "Error" =TYPESTRING(A1:A3) -> "Range"
DEFINE( TYPESTRING, LAMBDA( input, [recursive], SWITCH( TYPE(input), 1, "Number", 2, "String", 4, "Boolean", 16, "Error", 64, IF( DEFAULT(recursive, FALSE), MAP( input, LAMBDA( each, TYPESTRING(each))), "Range"), 128, "Function", OTHERWISE, "Unknown")))
Help us optimize this function