λΉ μ μ²λ¦¬
μ΄ μννΈμ¨μ΄μ μ΄μ λ²μ μμλ λΉ μ μ μ²λ¦¬κ° μΌλΆ λ¬Έλ§₯μμλ μ«μ 0μΌλ‘, λ€λ₯Έ κ³³μμλ λΉ λ¬Έμμ΄λ‘ κ°μ μ€μ λμμ΅λλ€. κ·Έλ¦¬κ³ =A1=0κ³Ό =A1="" κ°μ μ§μ λΉκ΅λ μμΈλ‘ μ²λ¦¬λμμ΅λλ€. μ΄μ κ°μ κ²½μ°μλ A1μ΄ λΉμμ κ²½μ° λͺ¨λ TRUE κ°μ κ°κ² λ©λλ€. μ΄λ¬ν μ²λ¦¬λ κ³μ μ μ§λμ΄, =VLOOKUP(...)=0κ³Ό =VLOOKUP(...)=""μ κ²½μ° λΉ μ μ΄ κ²°κ³Όκ°μΌλ‘ λ°νλ κ²½μ° TRUE κ°μ κ°μ΅λλ€.
λΉ μ μ λν λ¨μ μ°Έμ‘°λ μ«μ 0μΌλ‘ νμλμ§λ§ μ«μ νμμΌ νμλ μμ΅λλ€. λ°λΌμ μ°Έμ‘°νλ μ κ³Όμ λΉκ΅λ μμλλ‘ λμν©λλ€.
λ€μ μμ μμλ, A1 μλ μ«μ, B1 μ λΉ μ , C1 μλ B1 μ λν μ°Έμ‘°κ° ν¬ν¨λμ΄ μμ΅λλ€.
A1: 1 B1: <λΉμ΄μμ> C1: =B1 (0μΌλ‘ νμ)
=B1=0 => TRUE
=B1="" => TRUE
=C1=0 => TRUE
=C1="" => TRUE (μ΄μ κ°μ FALSE)
=ISNUMBER(B1) => FALSE
=ISNUMBER(C1) => FALSE (μ΄μ κ°μ TRUE)
=ISNUMBER(VLOOKUP(1;A1:C1;2)) => FALSE (B1)
=ISNUMBER(VLOOKUP(1;A1:C1;3)) => FALSE (C1, μ΄μ κ°μ TRUE)
=ISTEXT(B1) => FALSE
=ISTEXT(C1) => FALSE
=ISTEXT(VLOOKUP(1;A1:C1;2)) => FALSE (B1, μ΄μ κ°μ TRUE)
=ISTEXT(VLOOKUP(1;A1:C1;3)) => FALSE (C1)
=ISBLANK(B1) => TRUE
=ISBLANK(C1) => FALSE
=ISBLANK(VLOOKUP(1;A1:C1;2)) => TRUE (B1, μ΄μ κ°μ FALSE)
=ISBLANK(VLOOKUP(1;A1:C1;3)) => FALSE (C1)

Microsoft Excel μ λΉ μ μ΄λ λΉ κ²°κ³Όλ₯Ό κ°λ μμ μ μ λν μ°Έμ‘° κ²°κ³Όκ° νμ μ«μλ‘ λ°νλ©λλ€. μμ :
A1: <λΉμ΄μμ>
B1: =A1 => 0 μΌλ‘ νμ. λ¨, μ΄λ λΉ μ μ λν μ°Έμ‘°μΌλΏμ λλ€.
=ISNUMBER(A1) => FALSE
=ISTEXT(A1) => FALSE
=A1=0 => TRUE
=A1="" => TRUE
=ISNUMBER(B1) => FALSE (Microsoft Excel: TRUE)
=ISTEXT(B1) => FALSE
=B1=0 => TRUE
=B1="" => TRUE (Microsoft Excel: FALSE)
C1: =VLOOKUP(...) with empty cell result => displays empty (Microsoft Excel: displays 0)
=ISNUMBER(VLOOKUP(...)) => FALSE
=ISTEXT(VLOOKUP(...)) => FALSE
=ISNUMBER(C1) => FALSE (Microsoft Excel: TRUE)
=ISTEXT(C1) => FALSE