이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
EXACT(text1, text2)The EXACT function compares two text strings and returns TRUE if they are identical, including case sensitivity. It ignores formatting and is useful for verifying data entries where capitalization matters.
=EXACT("Apple", "apple")결과: FALSE
Returns FALSE because the function is case-sensitive.
=EXACT("Excel", "Excel")결과: TRUE
Returns TRUE because both strings are identical.
Yes, unlike the standard equal sign (=) operator, EXACT is strictly case-sensitive.