IF vs Equal (=) vs EXACT Function in Excel (Khmer)

Hello everyone! Today I show you difference between IF, Equal operator (=), and EXACT function in Excel step by step with easy examples and video guide in Khmer language.

Many beginners get confused when comparing two text cells in Excel. Do you know that standard = sign ignores capital letters, while EXACT() function checks capital letters strictly? Let's see how they work!

Quick Comparison: = vs EXACT()

Method 1: Standard Equal Operator (=) - Case Insensitive

When you compare two cells using standard = sign:

=A2 = B2

• If A2 = Apple and B2 = apple, Excel returns TRUE.
• Excel treats uppercase (A-Z) and lowercase (a-z) as exact same thing.

Using inside IF function:

=IF(A2 = B2, "Match", "Not Match")

• Returns Match for Apple and apple.

Method 2: EXACT Function - Case Sensitive Comparison

If you need to verify strict case sensitivity (like password, product code, SKU, or serial number):

Use EXACT function:

=EXACT(A2, B2)

• If A2 = Apple and B2 = apple, Excel returns FALSE!
• If A2 = Apple and B2 = Apple, Excel returns TRUE.

Using inside IF function:

=IF(EXACT(A2, B2), "Exact Match", "Case Different")

Method 3: Real Example - Validate Product Serial Code

Suppose cell A2 contains master code KH-990A and user type input in B2:

• Formula 1 (Standard IF):

  =IF(A2 = B2, "Pass", "Fail")
  

  If user type kh-990a, result is Pass (ignoring lower case).

• Formula 2 (Strict Case IF + EXACT):

  =IF(EXACT(A2, B2), "Pass", "Fail")
  

  If user type kh-990a, result is Fail because kh is lowercase!

📹 Watch Khmer Video Tutorial

Watch video step by step below to see how to use IF, Equal, and EXACT functions in Excel:

💡 Quick Tip:

• Hidden Space Problem: If EXACT(A2, B2) returns FALSE even when text looks 100% same, one cell probably has an invisible extra space at the end! Wrap with TRIM: =EXACT(TRIM(A2), TRIM(B2)).
• Case-Sensitive Lookup: Standard VLOOKUP and XLOOKUP are case-insensitive. If you need case-sensitive lookup, combine XLOOKUP with EXACT: =XLOOKUP(TRUE, EXACT(A2:A10, "Apple"), B2:B10).

📚 Related Resources

• How to Insert Current Date, Time, and AutoSum in Excel
• How to Calculate Working Hours in Excel
• How to Use Track Change and Comment in Excel
• Top 15 Basic Excel Formulas Every Beginner Should Know