논리 ν•¨μˆ˜

This category contains the Logical functions.

Handling non-logical arguments in logical functions

이 λͺ…령을 μ‚¬μš©ν•˜λ €λ©΄...

Insert - Function - Category Logical


ISNA

셀에 #N/A(μ‚¬μš©ν•  수 μ—†λŠ” κ°’) 였λ₯˜ 값이 ν¬ν•¨λ˜μ–΄ 있으면 TRUEλ₯Ό κ΅¬ν•©λ‹ˆλ‹€.

였λ₯˜ μƒν™©μ—μ„œ ν•¨μˆ˜λŠ” FALSE 값을 λ°˜ν™˜ν•©λ‹ˆλ‹€.

Syntax

ISNA(Values)

NumberλŠ” 검사할 숫자 λ˜λŠ” ν‘œν˜„μž…λ‹ˆλ‹€.

Example

=ISNA(D3)은 κ²°κ³Όκ°’μœΌλ‘œ FALSEλ₯Ό λŒλ €μ€λ‹ˆλ‹€.

ISERROR

Returns the value if the cell does not contains an error value, or the alternative value if it does.

tip

This function is available since LibreOffice 4.0.


Syntax

IFERROR(Value; Alternate_value)

Value is the value or expression to be returned if it is not equal or results in an error.

Alternate_value is the value or expression to be returned if the expression or value of Value is equal or results in an error.

Example

C8 셀이 =1/0의 μˆ˜μ‹μ„ ν¬ν•¨ν•˜λŠ” 경우, 이 μˆ˜μ‹μ€ λΆˆκ°€λŠ₯ν•œ μˆ˜μ‹μ΄λ―€λ‘œ =ISERROR(C8)은 TRUE값을 λ°˜ν™˜ν•©λ‹ˆλ‹€.

C8 셀이 =1/0의 μˆ˜μ‹μ„ ν¬ν•¨ν•˜λŠ” 경우, 이 μˆ˜μ‹μ€ λΆˆκ°€λŠ₯ν•œ μˆ˜μ‹μ΄λ―€λ‘œ =ISERROR(C8)은 TRUE값을 λ°˜ν™˜ν•©λ‹ˆλ‹€.

IFS

IFS is a multiple IF-function.

SWITCH

SWITCH compares expression with value1 to valuen and returns the result belonging to the first value that equals expression. If there is no match and default_result is given, that will be returned.

AND

λͺ¨λ“  μΈμˆ˜κ°€ TRUE이면 TRUEλ₯Ό κ΅¬ν•©λ‹ˆλ‹€. μš”μ†Œ 쀑 ν•˜λ‚˜κ°€ FALSE이면 이 ν•¨μˆ˜λŠ” FALSE 값을 κ΅¬ν•©λ‹ˆλ‹€.

μΈμˆ˜λŠ” 논리 값을 κ΅¬ν•˜λŠ” 논리식 자체(TRUE, 1<5, 2+3=7, B8<10)μ΄κ±°λ‚˜ 논리 값을 ν¬ν•¨ν•˜λŠ” λ°°μ—΄ (A1:C3)μž…λ‹ˆλ‹€.

Syntax

AND(Logical 1 [; Logical 2 [; … [; Logical 255]]])

Logical 1, Logical 2, … , Logical 255 are boolean values, references to cells or to cell ranges of logical values.

note

This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the value highlighting feature.


Example

12<13, 14>12 및 7<6 ν•­λͺ©μ˜ 논리 값이 κ²€μ‚¬λ©λ‹ˆλ‹€.

=AND(12<13;14>12;7<6)λŠ” FALSE 값을 λ°˜ν™˜ν•©λ‹ˆλ‹€.

=AND(FALSE();TRUE()) returns FALSE.

FALSE

논리값 FALSEλ₯Ό κ΅¬ν•©λ‹ˆλ‹€. FALSE() ν•¨μˆ˜λŠ” μΈμˆ˜κ°€ ν•„μš”ν•˜μ§€ μ•ŠμœΌλ©° 항상 논리값 FALSEλ₯Ό κ΅¬ν•©λ‹ˆλ‹€.

Syntax

FALSE()

Example

=FALSE()λŠ” FALSEλ₯Ό λ°˜ν™˜ν•©λ‹ˆλ‹€.

=NOT(FALSE())λŠ” TRUE 값을 λ°˜ν™˜ν•©λ‹ˆλ‹€.

IF

μˆ˜ν–‰ν•  논리 검사λ₯Ό μ§€μ •ν•©λ‹ˆλ‹€.

Syntax

IF(Test [; [ThenValue] [; [OtherwiseValue]]])

ν…ŒμŠ€νŠΈλŠ” TRUE λ˜λŠ” FALSEκ°€ 될 수 μžˆλŠ” μž„μ˜ κ°’ λ˜λŠ” μ‹μž…λ‹ˆλ‹€.

참값은 쑰건문이 TRUE(μ°Έ)일 λ•Œ 셀에 λ°˜ν™˜ν•  κ°’μž…λ‹ˆλ‹€(선택 사항).

거짓값은 쑰건문이 FALSE(κ±°μ§“)일 λ•Œ 셀에 λ°˜ν™˜ν•  κ°’μž…λ‹ˆλ‹€(선택 사항).

In the LibreOffice Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.

Example

=IF(A1>5;100;"too small") If the value in A1 is greater than 5, the value 100 is returned; otherwise, the text too small is returned.

=IF(A1>5;;"too small") If the value in A1 is greater than 5, the value 0 is returned because empty parameters are considered to be 0; otherwise, the text too small is returned.

=IF(A1>5;100;) If the value in A1 is less than 5, the value 0 is returned because the empty OtherwiseValue is interpreted as 0; otherwise 100 is returned.

NOT

λ³€ν™˜ν•  논리값을 μ±„μ›Œλ„£μœΌμ‹­μ‹œμš”.

Syntax

NOT(논리값)

논리값은 μ–΄λ– ν•œ 값이라도 ν¬ν•¨λ˜μ–΄μ•Ό ν•©λ‹ˆλ‹€.

Example

=NOT(A)은 μˆ˜ν•™μ—μ„œμ˜ μ—­κ³Ό κ°™μŠ΅λ‹ˆλ‹€. A=TRUE(μ°Έ)일 λ•Œ NOT(A)λŠ” FALSE(κ±°μ§“)둜 ν‰κ°€λ©λ‹ˆλ‹€.

OR

μ΅œμ†Œν•œ ν•˜λ‚˜ μ΄μƒμ˜ μΈμˆ˜κ°€ TRUE이면 TRUEλ₯Ό κ΅¬ν•©λ‹ˆλ‹€. λͺ¨λ“  μΈμˆ˜κ°€ 논리값 FALSEλ₯Ό κ°€μ§€λ©΄ FALSE 값을 κ΅¬ν•©λ‹ˆλ‹€

μΈμˆ˜λŠ” 논리 값을 κ΅¬ν•˜λŠ” 논리식 자체(TRUE, 1<5, 2+3=7, B8<10)μ΄κ±°λ‚˜ 논리 값을 ν¬ν•¨ν•˜λŠ” λ°°μ—΄ (A1:C3)μž…λ‹ˆλ‹€.

Syntax

OR(Logical 1 [; Logical 2 [; … [; Logical 255]]])

Logical 1, Logical 2, … , Logical 255 are boolean values, references to cells or to cell ranges of logical values.

note

This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the value highlighting feature.


Example

12<11; 13>22 및 45=45 ν•­λͺ©μ˜ 논리 값이 κ²€μ‚¬λ©λ‹ˆλ‹€.

=OR(12<11;13>22;45=45)λŠ” TRUE 값을 λ°˜ν™˜ν•©λ‹ˆλ‹€.

=OR(FALSE();TRUE()) returns TRUE.

TRUE

논리 값은 TRUE둜 μ„€μ •λ©λ‹ˆλ‹€. TRUE() ν•¨μˆ˜λŠ” μΈμˆ˜κ°€ ν•„μš”ν•˜μ§€ μ•ŠμœΌλ©° 항상 논리값 TRUEλ₯Ό κ΅¬ν•©λ‹ˆλ‹€.

Syntax

TRUE()

Example

A=TRUE 및 B=FALSE이면 λ‹€μŒ μ˜ˆκ°€ λ‚˜νƒ€λ‚©λ‹ˆλ‹€.

=AND(A;B)λŠ” FALSEλ₯Ό λ°˜ν™˜ν•©λ‹ˆλ‹€.

=OR(A;B)λŠ” TRUEλ₯Ό λ°˜ν™˜ν•©λ‹ˆλ‹€.

=NOT(AND(A;B))λŠ” TRUE 값을 λ°˜ν™˜ν•©λ‹ˆλ‹€.

XOR

Returns true if an odd number of arguments evaluates to TRUE.

μΈμˆ˜λŠ” 논리 값을 κ΅¬ν•˜λŠ” 논리식 자체(TRUE, 1<5, 2+3=7, B8<10)μ΄κ±°λ‚˜ 논리 값을 ν¬ν•¨ν•˜λŠ” λ°°μ—΄ (A1:C3)μž…λ‹ˆλ‹€.

tip

This function is available since LibreOffice 4.0.


Syntax

XOR(Logical 1 [; Logical 2 [; … [; Logical 255]]])

Logical 1, Logical 2, … , Logical 255 are boolean values, references to cells or to cell ranges of logical values.

Example

=XOR(TRUE();TRUE()) returns FALSE

=XOR(TRUE();TRUE();TRUE()) returns TRUE

=XOR(FALSE();TRUE()) returns TRUE