빈 μ…€ 처리

이 μ†Œν”„νŠΈμ›¨μ–΄μ˜ 이전 λ²„μ „μ—μ„œλŠ” 빈 μ…€μ˜ μ²˜λ¦¬κ°€ 일뢀 λ¬Έλ§₯μ—μ„œλŠ” 숫자 0으둜, λ‹€λ₯Έ κ³³μ—μ„œλŠ” 빈 λ¬Έμžμ—΄λ‘œ κ°•μ œ μ„€μ •λ˜μ—ˆμŠ΅λ‹ˆλ‹€. 그리고 =A1=0κ³Ό =A1="" 같은 직접 λΉ„κ΅λŠ” μ˜ˆμ™Έλ‘œ μ²˜λ¦¬λ˜μ—ˆμŠ΅λ‹ˆλ‹€. 이와 같은 κ²½μš°μ—λŠ” A1이 λΉ„μ—ˆμ„ 경우 λͺ¨λ‘ TRUE 값을 κ°–κ²Œ λ©λ‹ˆλ‹€. μ΄λŸ¬ν•œ μ²˜λ¦¬λŠ” 계속 μœ μ§€λ˜μ–΄, =VLOOKUP(...)=0κ³Ό =VLOOKUP(...)=""의 경우 빈 셀이 κ²°κ³Όκ°’μœΌλ‘œ λ°˜ν™˜λ  경우 TRUE 값을 κ°–μŠ΅λ‹ˆλ‹€.

빈 셀에 λŒ€ν•œ λ‹¨μˆœ μ°Έμ‘°λŠ” 숫자 0으둜 ν‘œμ‹œλ˜μ§€λ§Œ 숫자 ν˜•μ‹μΌ ν•„μš”λŠ” μ—†μŠ΅λ‹ˆλ‹€. λ”°λΌμ„œ μ°Έμ‘°ν•˜λŠ” μ…€κ³Όμ˜ 비ꡐ도 μ˜ˆμƒλŒ€λ‘œ λ™μž‘ν•©λ‹ˆλ‹€.

λ‹€μŒ μ˜ˆμ œμ—μ„œλŠ”, A1 μ—λŠ” 숫자, B1 은 빈 μ…€, C1 μ—λŠ” B1 에 λŒ€ν•œ μ°Έμ‘°κ°€ ν¬ν•¨λ˜μ–΄ μžˆμŠ΅λ‹ˆλ‹€.

Case

Formula

Results and comments

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

Results and comments

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


Please support us!