# λΉ μ μ²λ¦¬

μ΄ μννΈμ¨μ΄μ μ΄μ  λ²μ μμλ λΉ μμ μ²λ¦¬κ° μΌλΆ λ¬Έλ§₯μμλ μ«μ 0μΌλ‘, λ€λ₯Έ κ³³μμλ λΉ λ¬Έμμ΄λ‘ κ°μ  μ€μ λμμ΅λλ€. κ·Έλ¦¬κ³  =A1=0κ³Ό =A1="" κ°μ μ§μ  λΉκ΅λ μμΈλ‘ μ²λ¦¬λμμ΅λλ€. μ΄μ κ°μ κ²½μ°μλ A1μ΄ λΉμμ κ²½μ° λͺ¨λ TRUE κ°μ κ°κ² λ©λλ€. μ΄λ¬ν μ²λ¦¬λ κ³μ μ μ§λμ΄, =VLOOKUP(...)=0κ³Ό =VLOOKUP(...)=""μ κ²½μ° λΉ μμ΄ κ²°κ³Όκ°μΌλ‘ λ°νλ  κ²½μ° TRUE κ°μ κ°μ΅λλ€.

λΉ μμ λν λ¨μ μ°Έμ‘°λ μ«μ 0μΌλ‘ νμλμ§λ§ μ«μ νμμΌ νμλ μμ΅λλ€. λ°λΌμ μ°Έμ‘°νλ μκ³Όμ λΉκ΅λ μμλλ‘ λμν©λλ€.

λ€μ μμ μμλ, A1 μλ μ«μ, B1 μ λΉ μ, C1 μλ B1 μ λν μ°Έμ‘°κ° ν¬ν¨λμ΄ μμ΅λλ€.

Case

Formula

A1: 1
B1: <Empty>

C1: =B1

Displays 0

=B1=0

TRUE

=B1=""

TRUE

=C1=0

TRUE

=C1=""

TRUE (previously was FALSE)

=ISNUMBER(B1)

FALSE

=ISNUMBER(C1)

FALSE (previously was TRUE)

=ISNUMBER(VLOOKUP(1;A1:C1;2))

FALSE (B1)

=ISNUMBER(VLOOKUP(1;A1:C1;3))

FALSE (C1, previously was TRUE)

=ISTEXT(B1)

FALSE

=ISTEXT(C1)

TRUE

=ISTEXT(VLOOKUP(1;A1:C1;2))

FALSE (B1, previously was TRUE)

=ISTEXT(VLOOKUP(1;A1:C1;3))

FALSE (C1)

=ISBLANK(B1)

TRUE

=ISBLANK(C1)

TRUE

=ISBLANK(VLOOKUP(1;A1:C1;2))

TRUE (B1, previously was FALSE)

=ISBLANK(VLOOKUP(1;A1:C1;3))

FALSE (C1)

Microsoft Excel μ λΉ μμ΄λ λΉ κ²°κ³Όλ₯Ό κ°λ μμ μμ λν μ°Έμ‘° κ²°κ³Όκ° ν­μ μ«μλ‘ λ°νλ©λλ€. μμ :

Case

Formula

A1: <Empty>

B1: =A1

Displays 0, but is just a reference to an empty cell.

=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