LibreOffice Calc의 μ—°μ‚°μž

LibreOffice Calcμ—μ„œλŠ” λ‹€μŒκ³Ό 같은 μ—°μ‚°μžλ₯Ό μ‚¬μš©ν•  수 μžˆμŠ΅λ‹ˆλ‹€.

μ‚°μˆ  μ—°μ‚°μž

이 μ—°μ‚°μžλŠ” μˆ«μžμƒμ˜ κ²°κ³Όλ₯Ό μ œκ³΅ν•©λ‹ˆλ‹€

μ—°μ‚°μž

이름

Example

+ (ν”ŒλŸ¬μŠ€)

λ§μ…ˆ(+)

1+1

- (λ§ˆμ΄λ„ˆμŠ€)

λΊ„μ…ˆ

2-1

- (λ§ˆμ΄λ„ˆμŠ€)

λΆ€μ •

-5

* (λ³„ν‘œ)

κ³±μ…ˆ

2*2

/ (사선)

λ‚˜λˆ—μ…ˆ

9/3

% (λ°±λΆ„μœ¨)

λ°±λΆ„μœ¨

15%

^ (νƒˆμž 기호)

λˆ„μŠΉ

3^2


note

Prefix "-" (negation) has a higher precedence than "^" (exponentiation). For example -3^2 equals 9, which is the square of a negative number.


비ꡐ μ—°μ‚°μž

이 μ—°μ‚°μžλŠ” 진리값 TRUE λ˜λŠ” WRONG을 μ œκ³΅ν•©λ‹ˆλ‹€.

μ—°μ‚°μž

이름

Example

= (등식 λΆ€ν˜Έ)

동일

A1=B1

> (초과)

초과

A1>B1

< (미만)

미만

A1<B1

>= (ν¬κ±°λ‚˜ κ°™μŒ)

ν¬κ±°λ‚˜ κ°™μŒ

A1>=B1

<= (μž‘κ±°λ‚˜ κ°™μŒ)

μž‘κ±°λ‚˜ κ°™μŒ

A1<=B1

<> (λ™μΌν•˜μ§€ μ•ŠμŒ)

λ™μΌν•˜μ§€ μ•ŠμŒ

A1<>B1


ν…μŠ€νŠΈ μ—°μ‚°μž

이 μ—°μ‚°μžλŠ” 각각의 ν…μŠ€νŠΈλ₯Ό 전체 ν…μŠ€νŠΈμ— μ—°κ²°ν•©λ‹ˆλ‹€.

μ—°μ‚°μž

이름

Example

& (그리고)

ν…μŠ€νŠΈ 링크 AND

"Sun" & "Day"의 κ²°κ³ΌλŠ” "Sunday"μž…λ‹ˆλ‹€


μ°Έμ‘° μ—°μ‚°μž

이 μ—°μ‚°μžλ“€μ€ μ—†κ±°λ‚˜, ν•˜λ‚˜ λ˜λŠ” κ·Έ μ΄μƒμ˜ μ…€ λ²”μœ„λ₯Ό λŒλ €μ€λ‹ˆλ‹€.

λ²”μœ„κ°€ κ°€μž₯ 높은 μš°μ„ μˆœμœ„λ₯Ό κ°€μ§€κ³  κ·Έ λ‹€μŒμ΄ ꡐ집합이며 λ§ˆμ§€λ§‰μœΌλ‘œ ν•©μ§‘ν•©μž…λ‹ˆλ‹€.

μ—°μ‚°μž

이름

Example

: (콜둠)

μ˜μ—­

A1:C108, A:D or 3:13

! (λŠλ‚Œν‘œ)

ꡐ집합

SUM(A1:B6!B5:C12)

ꡐ차된 μ˜μ—­μ— μžˆλŠ” λͺ¨λ“  μ…€μ˜ 합계λ₯Ό κ΅¬ν•©λ‹ˆλ‹€. 예λ₯Ό λ“€μ–΄ μ…€ B5와 B6이 ꡐ차 μ˜μ—­μ— 있으면 κ·Έ 합계가 κ³„μ‚°λ©λ‹ˆλ‹€.

~ (틸데)

μ—°κ²° λ˜λŠ” ν•©μ§‘ν•©

Takes two references and returns a reference list, which is a concatenation of the left reference followed by the right reference. Double entries are referenced twice.

=COUNT(A1:B2~B2:C3) counts values of A1:B2 and B2:C3. Note that the cell B2 is counted twice.

=INDEX(A1:B2~C1:D2;2;1;2) selects cell C2, that is, the first cell of the second row, first column, of the second range (C1:D2) of the range list.


note

A reference list is not allowed inside an array expression.