๋ผ๋ฆฌ ํจ์

This category contains the Logical functions.

Handling non-logical arguments in logical functions

• Zero (0) is equivalent to FALSE and all other numbers are equivalent to TRUE.

• Empty cells and text in cells are ignored.

• A #VALUE error is raised if all arguments are ignored.

• A #VALUE error is raised if one argument is direct text (not text in a cell).

• Errors as argument lead to an error.

์ด ๋ช๋ น์ ์ฌ์ฉํ๋ ค๋ฉด...

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 contain an error value, or the alternative value if it does.

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.

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๋ฅผ ๊ตฌํฉ๋๋ค.

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.

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๋ฅผ ๊ตฌํฉ๋๋ค.

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)์๋๋ค.

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