이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
TYPE(value)The TYPE function identifies the data type of a given value. It returns 1 for numbers, 2 for text, 4 for logical values, 16 for error values, and 64 for arrays.
=TYPE(100)결과: 1
Returns 1 because 100 is a number.
=TYPE("Hello")결과: 2
Returns 2 because "Hello" is a text string.
A result of 16 indicates that the value provided is an error value, such as #N/A or #VALUE!.