๋…ผ๋ฆฌ ํ•จ์ˆ˜

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)๋Š” 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)์€ 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

=AND (FALSE;TRUE)๋Š” FALSE๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=OR(FALSE;TRUE)์€ TRUE ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=OR(FALSE;TRUE)์€ TRUE ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

Please support us!