계산

μŠ€ν”„λ ˆλ“œμ‹œνŠΈμ˜ 계산 섀정을 μ§€μ •ν•©λ‹ˆλ‹€. μˆœν™˜ μ°Έμ‘°, λ‚ μ§œ μ„€μ •, μ†Œμˆ˜μ  μ΄ν•˜ 자릿수, μ‹œνŠΈμ—μ„œ 검색할 λ•Œ λŒ€λ¬Έμž λ˜λŠ” μ†Œλ¬Έμžλ₯Ό ꡬ뢄할지 μ—¬λΆ€ 등을 μ‚¬μš©ν•˜μ—¬ μŠ€ν”„λ ˆλ“œμ‹œνŠΈμ˜ λ™μž‘μ„ μ§€μ •ν•©λ‹ˆλ‹€.

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

Open a spreadsheet document, choose - LibreOffice Calc - Calculate.


μˆœν™˜λ˜λŠ” μ°Έμ‘°

이 μ„Ήμ…˜μ—μ„œλŠ” 반볡 계산 쀑에 μˆ˜ν–‰λ˜λŠ” μΆ”μ • 단계 수λ₯Ό μ œν•œν•  수 μžˆμŠ΅λ‹ˆλ‹€. λ˜ν•œ λŒ€λ‹΅μ˜ 정확도λ₯Ό 지정할 수 μžˆμŠ΅λ‹ˆλ‹€.

Iterations

μˆœν™˜ μ°Έμ‘°κ°€ μžˆλŠ” μˆ˜μ‹, 즉 λ¬Έμ œκ°€ 해결될 λ•ŒκΉŒμ§€ 계속 μˆœν™˜λ˜λŠ” μˆ˜μ‹μ„ 정해진 수만큼 λ°˜λ³΅ν•œ 뒀에 계산할지 μ—¬λΆ€λ₯Ό μ§€μ •ν•©λ‹ˆλ‹€. 반볡 ν™•μΈλž€μ„ μ„ νƒν•˜μ§€ μ•ŠμœΌλ©΄ ν…Œμ΄λΈ”μ˜ μˆœν™˜ 참쑰둜 인해 였λ₯˜ λ©”μ‹œμ§€κ°€ ν‘œμ‹œλ©λ‹ˆλ‹€.

예: λΆ€κ°€κ°€μΉ˜μ„Έλ₯Ό μ œμ™Έν•˜κ³  ν•­λͺ© λΉ„μš©μ„ κ³„μ‚°ν•©λ‹ˆλ‹€.

  1. μ…€ A5μ—λŠ” '판맀 가격', μ…€ A6μ—λŠ” 'μ •κ°€'λΌλŠ” ν…μŠ€νŠΈ, μ…€ A7μ—λŠ” 'λΆ€κ°€κ°€μΉ˜μ„Έ'λž€ ν…μŠ€νŠΈλ₯Ό μž…λ ₯ν•©λ‹ˆλ‹€.

  2. 이제 μ…€ B5에 판맀 가격(예: 100)을 μž…λ ₯ν•©λ‹ˆλ‹€. μ •κ°€λŠ” μ…€ B6에 ν‘œμ‹œν•˜κ³  λΆ€κ°€κ°€μΉ˜μ„ΈλŠ” μ…€ B7에 ν‘œμ‹œν•΄μ•Ό ν•©λ‹ˆλ‹€.

  3. λΆ€κ°€κ°€μΉ˜μ„ΈλŠ” 'μ •κ°€*15%'둜 κ³„μ‚°λ˜κ³  판맀 κ°€κ²©μ—μ„œ λΆ€κ°€κ°€μΉ˜μ„Έλ₯Ό λΉΌλ©΄ μ •κ°€κ°€ λ©λ‹ˆλ‹€. B6에 μˆ˜μ‹ =B5-B7을 μž…λ ₯ν•˜μ—¬ μ •κ°€λ₯Ό κ³„μ‚°ν•˜κ³  μ…€ B7에 =B6*0.15λ₯Ό μž…λ ₯ν•˜μ—¬ λΆ€κ°€κ°€μΉ˜μ„Έλ₯Ό κ³„μ‚°ν•©λ‹ˆλ‹€.

  4. μˆ˜μ‹μ„ μ˜¬λ°”λ₯΄κ²Œ κ³„μ‚°ν•˜λ €λ©΄ 반볡 κ³„μ‚°μœΌλ‘œ μ „ν™˜ν•©λ‹ˆλ‹€. 그렇지 μ•ŠμœΌλ©΄ 'μˆœν™˜ μ°Έμ‘°' 였λ₯˜ λ©”μ‹œμ§€κ°€ μƒνƒœ ν‘œμ‹œμ€„μ— ν‘œμ‹œλ©λ‹ˆλ‹€.

A

B

5

VK

100

6

Netto

=B5 B7

7

MwSt

=B6*0.15


단계

μ΅œλŒ€ 반볡 단계 수λ₯Ό μ„€μ •ν•©λ‹ˆλ‹€.

μ΅œμ†Œ λ³€κ²½κ°’

두 κ°€μ§€μ˜ 연속적인 반볡 단계 결과의 차이λ₯Ό μ§€μ •ν•©λ‹ˆλ‹€. 반볡 κ²°κ³Όκ°€ μ΅œμ†Œ λ³€κ²½ 값보닀 μž‘μœΌλ©΄ 반볡이 μ€‘μ§€λ©λ‹ˆλ‹€.

λ‚ μ§œ

λ‚ μ§œμ—μ„œ 숫자둜 λ‚΄λΆ€ λ³€ν™˜μ„ μ‹œμž‘ν•  λ‚ μ§œλ₯Ό μ„ νƒν•©λ‹ˆλ‹€.

1899.12.30 (ν‘œμ€€)

1899/12/30을 0일둜 μ„€μ •ν•©λ‹ˆλ‹€.

1900.01.01 (StarCalc 1.0)

1900/01/01을 0일둜 μ„€μ •ν•©λ‹ˆλ‹€. λ‚ μ§œ ν•­λͺ©μ„ ν¬ν•¨ν•˜λŠ” StarCalc 1.0 μŠ€ν”„λ ˆλ“œμ‹œνŠΈμ—λŠ” 이 섀정을 μ‚¬μš©ν•©λ‹ˆλ‹€.

1904.01.01

1904/01/01을 0일둜 μ„€μ •ν•©λ‹ˆλ‹€. μ™Έκ΅­ ν˜•μ‹μœΌλ‘œ κ°€μ Έμ˜¨ μŠ€ν”„λ ˆλ“œμ‹œνŠΈμ—λŠ” 이 섀정을 μ‚¬μš©ν•©λ‹ˆλ‹€.

λŒ€/μ†Œλ¬Έμž 유의

μ…€ λ‚΄μš©μ„ 비ꡐ할 λ•Œ ν…μŠ€νŠΈμ˜ λŒ€/μ†Œλ¬Έμžλ₯Ό ꡬ뢄할지 μ—¬λΆ€λ₯Ό μ§€μ •ν•©λ‹ˆλ‹€.

예: μ…€ A1μ—λŠ” 'Test' ν…μŠ€νŠΈλ₯Ό μž…λ ₯ν•˜κ³  B1μ—λŠ” 'test' ν…μŠ€νŠΈλ₯Ό μž…λ ₯ν•©λ‹ˆλ‹€. 그런 λ‹€μŒ μ…€ C1에 "=A1=B1" μˆ˜μ‹μ„ μž…λ ₯ν•©λ‹ˆλ‹€. λŒ€/μ†Œλ¬Έμž ꡬ뢄 μƒμžλ₯Ό μ„ νƒν•˜λ©΄ 셀에 FALSEκ°€ ν‘œμ‹œλ˜κ³ , 그렇지 μ•ŠμœΌλ©΄ TRUEκ°€ ν‘œμ‹œλ©λ‹ˆλ‹€.

note

ν…μŠ€νŠΈ κΈ°λŠ₯ IDENTICAL은 이 λŒ€ν™” μƒμžμ—μ„œμ˜ μ„€μ •κ³ΌλŠ” 상관 없이 항상 λŒ€/μ†Œλ¬Έμžλ₯Ό κ³ λ €ν•©λ‹ˆλ‹€.


warning

Disable case sensitivity for spreadsheets that need to be interoperable with Microsoft Excel.


λ³΄μ—¬μ§€λŠ” 정확도

μ‹œνŠΈμ— ν‘œμ‹œλœ 반올림된 값을 μ‚¬μš©ν•˜μ—¬ 계산할지 μ—¬λΆ€λ₯Ό μ§€μ •ν•©λ‹ˆλ‹€. μ°¨νŠΈμ™€ ν‘œμ‹œλœ 값이 ν•¨κ»˜ λ‚˜νƒ€λ‚©λ‹ˆλ‹€. ν‘œμ‹œλœ 정밀도 μ‚¬μš© μ˜΅μ…˜μ„ μ„ νƒν•˜μ§€ μ•ŠμœΌλ©΄ ν‘œμ‹œλ˜λŠ” 숫자만 반올림되고 λ‚΄λΆ€μ μœΌλ‘œλŠ” λ°˜μ˜¬λ¦Όλ˜μ§€ μ•Šμ€ 숫자λ₯Ό μ‚¬μš©ν•˜μ—¬ κ³„μ‚°ν•©λ‹ˆλ‹€.

검색 κΈ°μ€€ =와 <>λ₯Ό 전체 셀에 적용

Calc λ°μ΄ν„°λ² μ΄μŠ€ κΈ°λŠ₯에 λŒ€ν•΄ μ„€μ •ν•œ 검색 기쀀이 전체 μ…€κ³Ό μ •ν™•ν•˜κ²Œ μΌμΉ˜ν•˜λ„λ‘ μ§€μ •ν•©λ‹ˆλ‹€. 검색 κΈ°μ€€ =와 <>λ₯Ό 전체 셀에 적용 ν™•μΈλž€μ„ μ„ νƒν•˜λ©΄ λ°μ΄ν„°λ² μ΄μŠ€ ν•¨μˆ˜λ‘œ 셀을 검색할 λ•Œ LibreOffice Calcκ°€ MS Excelκ³Ό λ™μΌν•œ λ°©μ‹μœΌλ‘œ μž‘λ™ν•©λ‹ˆλ‹€.

λ‹€μŒ μœ„μΉ˜μ—μ„œμ˜ .* :

찾기에 λŒ€ν•œ 영ν–₯:

win

win은 μ°Ύμ§€λ§Œ win95μ΄λ‚˜ os2win, gewindeλŠ” 찾지 λͺ»ν•©λ‹ˆλ‹€

win.*

winκ³Ό win95λŠ” μ°Ύμ§€λ§Œ os2winμ΄λ‚˜ gewindeλŠ” 찾지 λͺ»ν•©λ‹ˆλ‹€

.*win

winκ³Ό os2winλŠ” μ°Ύμ§€λ§Œ win95λ‚˜ gewindeλŠ” 찾지 λͺ»ν•©λ‹ˆλ‹€

win.*

win, win95, os2win, gewindeλ₯Ό μ°ΎμŠ΅λ‹ˆλ‹€


검색 κΈ°μ€€ =와 <>λ₯Ό 전체 셀에 μ μš©μ„ ν™œμ„±ν™”ν•˜μ§€ μ•ŠμœΌλ©΄ "win" 검색 νŒ¨ν„΄μ€ ".*win.*"와 λ˜‘κ°™μ΄ μž‘λ™ν•©λ‹ˆλ‹€. Calc λ°μ΄ν„°λ² μ΄μŠ€ κΈ°λŠ₯을 μ‚¬μš©ν•˜μ—¬ 검색할 κ²½μš°μ—λŠ” 검색 νŒ¨ν„΄μ„ μ…€ λ‚΄μ˜ μ–΄λ–€ μœ„μΉ˜μ—λ‚˜ λ‘˜ 수 μžˆμŠ΅λ‹ˆλ‹€.

warning

Enable whole cell match for spreadsheets that need to be interoperable with Microsoft Excel.


Enable wildcards in formulas

Specifies that wildcards are enabled when searching and also for character string comparisons.

warning

Enable wildcards in formulas for spreadsheets that need to be interoperable with Microsoft Excel.


μˆ˜μ‹μ—μ„œ 일반적 ν‘œν˜„ κ°€λŠ₯

Specifies that regular expressions instead of simple wildcards are enabled when searching and also for character string comparisons.

warning

Do not enable regular expressions in formulas for spreadsheets that need to be interoperable with Microsoft Excel.


No wildcards or regular expressions in formulas

Specifies that only literal strings are used when searching and also for character string comparisons.

warning

Do not disable wildcards in formulas for spreadsheets that need to be interoperable with Microsoft Excel.


μ—΄κ³Ό ν–‰μ˜ λ ˆμ΄λΈ” μžλ™μœΌλ‘œ μ°ΎκΈ°

μž„μ˜μ˜ μ…€μ˜ ν…μŠ€νŠΈλ₯Ό ν…μŠ€νŠΈ μ•„λž˜μ— μžˆλŠ” μ—΄μ΄λ‚˜ ν…μŠ€νŠΈ 였λ₯Έμͺ½μ— μžˆλŠ” ν–‰μ˜ λ ˆμ΄λΈ”λ‘œ μ‚¬μš©ν•  수 μžˆλ„λ‘ μ§€μ •ν•©λ‹ˆλ‹€. ν…μŠ€νŠΈλŠ” λ°˜λ“œμ‹œ ν•œ 단어 μ΄μƒμœΌλ‘œ κ΅¬μ„±λ˜μ–΄μ•Ό ν•˜λ©° μ—°μ‚°μžλ₯Ό 포함할 수 μ—†μŠ΅λ‹ˆλ‹€.

예: μ…€ E5λŠ” "Europe" ν…μŠ€νŠΈλ₯Ό ν¬ν•¨ν•©λ‹ˆλ‹€. μ•„λž˜ μ…€ E6μ—λŠ” κ°’ 100, μ…€ E7μ—λŠ” κ°’ 200이 μžˆμŠ΅λ‹ˆλ‹€. μ—΄κ³Ό ν–‰μ˜ λ ˆμ΄λΈ” μžλ™μœΌλ‘œ μ°ΎκΈ° μƒμžλ₯Ό μ„ νƒν•˜λ©΄ μ…€ A1에 =SUM(Europe) μˆ˜μ‹μ„ μ“Έ 수 μžˆμŠ΅λ‹ˆλ‹€.

Limit decimals for general number format

You can specify the maximum number of decimal places that are shown by default for cells with General number format. If not enabled, cells with General number format show as many decimal places as the column width allows.

μ†Œμˆ˜μ  자리

Defines the number of decimals to be displayed for numbers with the General number format. The numbers are displayed as rounded numbers, but are not saved as rounded numbers.

Please support us!