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

This category contains the Logical functions.

Handling non-logical arguments in logical functions

์ด ๋ช…๋ น์„ ์‚ฌ์šฉํ•˜๋ ค๋ฉด...

์‚ฝ์ž… - ํ•จ์ˆ˜ - ๋ฒ”์ฃผ ๋…ผ๋ฆฌ์ 


AND

๋ชจ๋“  ์ธ์ˆ˜๊ฐ€ TRUE์ด๋ฉด TRUE๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค. ์š”์†Œ ์ค‘ ํ•˜๋‚˜๊ฐ€ FALSE์ด๋ฉด ์ด ํ•จ์ˆ˜๋Š” FALSE ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

์ธ์ˆ˜๋Š” ๋…ผ๋ฆฌ ๊ฐ’์„ ๊ตฌํ•˜๋Š” ๋…ผ๋ฆฌ์‹ ์ž์ฒด(TRUE, 1<5, 2+3=7, B8<10)์ด๊ฑฐ๋‚˜ ๋…ผ๋ฆฌ ๊ฐ’์„ ํฌํ•จํ•˜๋Š” ๋ฐฐ์—ด (A1:C3)์ž…๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

AND(๋…ผ๋ฆฌ๊ฐ’1; ๋…ผ๋ฆฌ๊ฐ’2 ... ๋…ผ๋ฆฌ๊ฐ’30)

LogicalValue1; LogicalValue2 ...LogicalValue30 are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range. The result is TRUE if the logical value in all cells within the cell range is TRUE.

์˜ˆ

12<13, 14>12 ๋ฐ 7<6 ํ•ญ๋ชฉ์˜ ๋…ผ๋ฆฌ ๊ฐ’์ด ๊ฒ€์‚ฌ๋ฉ๋‹ˆ๋‹ค.

=AND(12<13;14>12;7<6)๋Š” FALSE ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

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

FALSE

๋…ผ๋ฆฌ๊ฐ’ FALSE๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค. FALSE() ํ•จ์ˆ˜๋Š” ์ธ์ˆ˜๊ฐ€ ํ•„์š”ํ•˜์ง€ ์•Š์œผ๋ฉฐ ํ•ญ์ƒ ๋…ผ๋ฆฌ๊ฐ’ FALSE๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

FALSE()

์˜ˆ

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

=NOT(FALSE())๋Š” TRUE ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

IF

์ˆ˜ํ–‰ํ•  ๋…ผ๋ฆฌ ๊ฒ€์‚ฌ๋ฅผ ์ง€์ •ํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

IF(์กฐ๊ฑด๋ฌธ; ์ฐธ๊ฐ’; ๊ฑฐ์ง“๊ฐ’)

ํ…Œ์ŠคํŠธ๋Š” 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.

์˜ˆ

๋งŒ์ผ A1 ์…€์˜ ๊ฐ’์ด 5๋ณด๋‹ค ํฌ๋‹ค๋ฉด, =IF(A1>5;100;"๊ฐ’์ด ๋„ˆ๋ฌด ์ž‘์Šต๋‹ˆ๋‹ค")๋Š” ํ•จ์ˆ˜๊ฐ€ ์žˆ๋Š” ์…€์— 100์„ ์ž…๋ ฅํ•ฉ๋‹ˆ๋‹ค. ๋งŒ์ผ A1์…€์˜ ๊ฐ’์ด 5๋ณด๋‹ค ์ž‘๊ฑฐ๋‚˜ ๊ฐ™๋‹ค๋ฉด ์ง€์ •๋œ โ€œ๊ฐ’์ด ๋„ˆ๋ฌด ์ž‘์Šต๋‹ˆ๋‹คโ€(๋”ฐ์˜ดํ‘œ ์ œ์™ธ) ๋ฌธ์žฅ์ด ์ž…๋ ฅ๋ฉ๋‹ˆ๋‹ค.

NOT

๋ณ€ํ™˜ํ•  ๋…ผ๋ฆฌ๊ฐ’์„ ์ฑ„์›Œ๋„ฃ์œผ์‹ญ์‹œ์š”.

๊ตฌ๋ฌธ

NOT(๋…ผ๋ฆฌ๊ฐ’)

๋…ผ๋ฆฌ๊ฐ’์€ ์–ด๋– ํ•œ ๊ฐ’์ด๋ผ๋„ ํฌํ•จ๋˜์–ด์•ผ ํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=NOT(A)์€ ์ˆ˜ํ•™์—์„œ์˜ ์—ญ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค. A=TRUE(์ฐธ)์ผ ๋•Œ NOT(A)๋Š” FALSE(๊ฑฐ์ง“)๋กœ ํ‰๊ฐ€๋ฉ๋‹ˆ๋‹ค.

OR

์ตœ์†Œํ•œ ํ•˜๋‚˜ ์ด์ƒ์˜ ์ธ์ˆ˜๊ฐ€ TRUE์ด๋ฉด TRUE๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค. ๋ชจ๋“  ์ธ์ˆ˜๊ฐ€ ๋…ผ๋ฆฌ๊ฐ’ FALSE๋ฅผ ๊ฐ€์ง€๋ฉด FALSE ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค

์ธ์ˆ˜๋Š” ๋…ผ๋ฆฌ ๊ฐ’์„ ๊ตฌํ•˜๋Š” ๋…ผ๋ฆฌ์‹ ์ž์ฒด(TRUE, 1<5, 2+3=7, B8<10)์ด๊ฑฐ๋‚˜ ๋…ผ๋ฆฌ ๊ฐ’์„ ํฌํ•จํ•˜๋Š” ๋ฐฐ์—ด (A1:C3)์ž…๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

OR(๋…ผ๋ฆฌ๊ฐ’1; ๋…ผ๋ฆฌ๊ฐ’2 ...๋…ผ๋ฆฌ๊ฐ’30)

LogicalValue1; LogicalValue2 ...LogicalValue30 are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range.

์˜ˆ

12<11; 13>22 ๋ฐ 45=45 ํ•ญ๋ชฉ์˜ ๋…ผ๋ฆฌ ๊ฐ’์ด ๊ฒ€์‚ฌ๋ฉ๋‹ˆ๋‹ค.

=OR(12<11;13>22;45=45)๋Š” TRUE ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

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

TRUE

๋…ผ๋ฆฌ ๊ฐ’์€ TRUE๋กœ ์„ค์ •๋ฉ๋‹ˆ๋‹ค. TRUE() ํ•จ์ˆ˜๋Š” ์ธ์ˆ˜๊ฐ€ ํ•„์š”ํ•˜์ง€ ์•Š์œผ๋ฉฐ ํ•ญ์ƒ ๋…ผ๋ฆฌ๊ฐ’ TRUE๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

TRUE()

์˜ˆ

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)์ž…๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

OR(๋…ผ๋ฆฌ๊ฐ’1; ๋…ผ๋ฆฌ๊ฐ’2 ...๋…ผ๋ฆฌ๊ฐ’30)

์˜ˆ

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

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

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