์ˆ˜ํ•™ ํ•จ์ˆ˜

์ด ๋ฒ”์ฃผ์—๋Š” Calc์˜ ์ˆ˜ํ•™ ํ•จ์ˆ˜๊ฐ€ ํฌํ•จ๋ฉ๋‹ˆ๋‹ค. ํ•จ์ˆ˜ ๋งˆ๋ฒ•์‚ฌ๋ฅผ ์—ด๋ ค๋ฉด ์‚ฝ์ž… - ํ•จ์ˆ˜๋ฅผ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.

[text/scalc/01/func_aggregate.xhp#aggregate_head not found].

This function returns an aggregate result of the calculations in the range. You can use different aggregate functions listed below. The Aggregate function enables you to omit hidden rows, errors, SUBTOTAL and other AGGREGATE function results in the calculation.

RAWSUBTRACT

Subtracts a set of numbers and gives the result without eliminating small roundoff errors.

HOUR

Return a numeric value calculated by a combination of three colors (red, green and blue) and the alpha channel, in the RGBA color system. The result depends on the color system used by your computer.

[text/scalc/01/func_sumifs.xhp#sumifs_head not found].

Returns the sum of the values of cells in a range that meets multiple criteria in multiple ranges.

ABS

์ˆซ์ž์˜ ์ ˆ๋Œ€๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

ABS(Number)

์ˆซ์ž๋Š” ์ ˆ๋Œ€๊ฐ’์„ ๊ณ„์‚ฐํ•  ์ˆ˜์ž…๋‹ˆ๋‹ค. ์ ˆ๋Œ€๊ฐ’์€ ํ•ด๋‹น ์ˆ˜์—์„œ +/- ๊ธฐํ˜ธ๋ฅผ ๋บ€ ๊ฐ’์ž…๋‹ˆ๋‹ค.

์˜ˆ

=ABS(-56)๋Š” 56์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=ABS(12)์€ 12์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=ABS(0)๋Š” 0์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

ACOS

์ˆซ์ž์˜ ์—ญ์‚ผ๊ฐ ์ฝ”์‚ฌ์ธ์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

ACOS(Number)

์ด ํ•จ์ˆ˜๋Š” ์ฃผ์–ด์ง„ Number์— ๋Œ€ํ•œ ์—ญ ์ฝ”์‚ฌ์ธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค. ์ด๋Š” ์ฃผ์–ด์ง„ ์ˆ˜๋ฅผ ์ฝ”์‚ฌ์ธ ๊ฐ’์œผ๋กœ ๊ฐ€์ง€๋Š” ๊ฐ์˜ ๋ผ๋””์•ˆ ๊ฐ’์„ ์˜๋ฏธํ•˜๋ฉฐ, ๊ฐ์€ 0์—์„œ PI ์‚ฌ์ด์˜ ๋ฒ”์œ„์—์„œ ์ •์˜๋ฉ๋‹ˆ๋‹ค.

๋„ ๋‹จ์œ„ ๊ฐ๋„ ๊ฐ’์„ ๊ตฌํ•˜๋ ค๋ฉด DEGREES ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=ACOS(-1)์€ 3.14159265358979(PI ๋ผ๋””์•ˆ)๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=DEGREES(ACOS(0.5))์€ 30์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. 60๋„์˜ ์ฝ”์‚ฌ์ธ ๊ฐ’์€ 0.5์ž…๋‹ˆ๋‹ค.

ACOSH

์ˆซ์ž์˜ ์—ญ ์Œ๊ณก์„  ์ฝ”์‚ฌ์ธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

ACOSH(Number)

์ด ํ•จ์ˆ˜๋Š” ์ฃผ์–ด์ง„ Number์˜ ์—ญ ์Œ๊ณก ์ฝ”์‚ฌ์ธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค. ์ด๋Š” ๊ฒฐ๊ณผ ๊ฐ’์˜ ์Œ๊ณก ์ฝ”์‚ฌ์ธ ๊ฐ’์ด Number๊ฐ€ ๋˜๋Š” ์ˆ˜์น˜๋ฅผ ๋งํ•ฉ๋‹ˆ๋‹ค.

์ˆ˜๋Š” 1 ์ด์ƒ์ด์–ด์•ผ๋งŒ ํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=ACOSH(1)๋Š” 0์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

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

ACOT

ํ•ด๋‹น ์ˆซ์ž์— ๋Œ€ํ•œ ์—ญ ์ฝ”ํƒ„์  ํŠธ(์•„ํฌ ์ฝ”ํƒ„์  ํŠธ) ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

ACOT(Number)

์ด ํ•จ์ˆ˜๋Š” ์ฃผ์–ด์ง„ Number์˜ ์—ญ์ฝ”ํƒ„์  ํŠธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค. ์—ญ์ฝ”ํƒ„์  ํŠธ ๊ฐ’์€ ์ฃผ์–ด์ง„ ์ˆ˜๋ฅผ ์ฝ”ํƒ„์  ํŠธ ๊ฐ’์œผ๋กœ ํ•˜๋Š” ๊ฐ์˜ ํฌ๊ธฐ๋ฅผ ์˜๋ฏธํ•˜๋ฉฐ ์ด ๊ฐ์€ 0๊ณผ PI์˜ ๋ฒ”์œ„์—์„œ ๊ณ„์‚ฐ๋ฉ๋‹ˆ๋‹ค.

๋„ ๋‹จ์œ„ ๊ฐ๋„ ๊ฐ’์„ ๊ตฌํ•˜๋ ค๋ฉด DEGREES ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=ACOT(1)๋Š” 0.785398163397448(PI/4 ๋ผ๋””์•ˆ)์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=DEGREES(ACOT(1))๋Š” 1์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. 45๋„์˜ ํƒ„์  ํŠธ ๊ฐ’์€ 1์ž…๋‹ˆ๋‹ค.

ACOTH

์ฃผ์–ด์ง„ ์ˆซ์ž์˜ ์—ญ ์Œ๊ณก์„  ์ฝ”ํƒ„์  ํŠธ๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

ACOTH(Number)

์ฃผ์–ด์ง„ Number์˜ ์—ญ ์Œ๊ณก ์ฝ”ํƒ„์  ํŠธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค. ์ด๋Š” ๊ตฌํ•ด์ง„ ๊ฐ’์˜ ์Œ๊ณก ์ฝ”ํƒ„์  ํŠธ ๊ฐ’์ด ์ˆ˜์™€ ๊ฐ™์€ ๊ฐ’์„ ๋งํ•ฉ๋‹ˆ๋‹ค.

์ˆ˜๊ฐ€ -1 ๊ณผ 1 ์‚ฌ์ด์— ์žˆ์„ ๊ฒฝ์šฐ ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒ๋ฉ๋‹ˆ๋‹ค.

์˜ˆ

=ACOTH(1.1) 1.1 ์˜ ์—ญ์ฝ”ํƒ„์  ํŠธ ์Œ๊ณกํ•จ์ˆ˜๊ฐ’์˜ ๊ทผ์‚ฌ์น˜์ธ 1.52226 ์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

ASIN

์ˆซ์ž์˜ ์—ญ์‚ผ๊ฐ ์‚ฌ์ธ์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

ASIN(Number)

์ด ํ•จ์ˆ˜๋Š” ์ฃผ์–ด์ง„ Number์˜ ์—ญ์‚ฌ์ธ ๊ฐ’์„ ๊ณ„์‚ฐํ•ฉ๋‹ˆ๋‹ค. ์ฆ‰ ๊ฒฐ๊ณผ๊ฐ’์€ ํ•ด๋‹นNumber๋ฅผ ์‚ฌ์ธ๊ฐ’์œผ๋กœ ๊ฐ€์ง€๋Š” ๊ฐ๋„์˜ ๋ผ๋””์•ˆ ๊ฐ’์ด๋ฉฐ, ๊ทธ ๋ฒ”์œ„๋Š” -PI/2 ์ด์ƒ PI/2 ์ดํ•˜์ž…๋‹ˆ๋‹ค.

๋„ ๋‹จ์œ„ ๊ฐ๋„ ๊ฐ’์„ ๊ตฌํ•˜๋ ค๋ฉด DEGREES ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=ASIN(0)๋Š” 0์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=ASIN(1)๋Š” 1.5707963267949(PI/2 ๋ผ๋””์•ˆ)๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=DEGREES(ASIN(0.5))์€ 30์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. 30๋„์˜ ์‚ฌ์ธ ๊ฐ’์€ 0.5์ž…๋‹ˆ๋‹ค.

ASINH

์ˆซ์ž์˜ ์—ญ ์Œ๊ณก์„  ์‚ฌ์ธ์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

ASINH(Number)

์ด ํ•จ์ˆ˜๋Š” ์ฃผ์–ด์ง„ Number์˜ ์—ญ ์Œ๊ณก ์‚ฌ์ธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค. ์ด๋Š” ๊ฒฐ๊ณผ ๊ฐ’์˜ ์Œ๊ณก ์‚ฌ์ธ ๊ฐ’์ด Number๊ฐ€ ๋˜๋Š” ์ˆ˜์น˜๋ฅผ ๋งํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=ASINH(-90)๋Š” ์•ฝ -5.1929877์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

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

ATAN

์ˆซ์ž์˜ ์—ญ์‚ผ๊ฐ ํƒ„์  ํŠธ๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

ATAN(Number)

์ด ํ•จ์ˆ˜๋Š” ์ฃผ์–ด์ง„ Number์˜ ๋ผ๋””์•ˆ ์—ญํƒ„์  ํŠธ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ์ฆ‰, ๊ฒฐ๊ณผ๊ฐ’์€ ํ•ด๋‹นํ•˜๋Š” ๊ฐ’์„ ๊ฐ€์ง€๋Š” ๋ผ๋””์•ˆ(ํ˜ธ๊ฐ) ๊ฐ๋„๊ฐ€ ๋˜๋ฉฐ, ๊ฒฐ๊ณผ๊ฐ’์˜ ๋ฒ”์œ„๋Š” -PI/2์ดˆ๊ณผ PI/2 ๋ฏธ๋งŒ์ด ๋ฉ๋‹ˆ๋‹ค.

๋„ ๋‹จ์œ„ ๊ฐ๋„ ๊ฐ’์„ ๊ตฌํ•˜๋ ค๋ฉด DEGREES ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=ATAN(1)๋Š” 0.785398163397448(PI/4 ๋ผ๋””์•ˆ)์˜ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=DEGREES(ATAN(1)) returns 45. The tangent of 45 degrees is 1.

ATAN2

์ง€์ •๋œ x ๋ฐ y ์ขŒํ‘œ์˜ ์—ญ์‚ผ๊ฐ ํƒ„์  ํŠธ๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

ATAN2(์ˆ˜X; ์ˆ˜Y)

์ˆ˜X๋Š” X ์ขŒํ‘œ์˜ ๊ฐ’์„ ์˜๋ฏธํ•ฉ๋‹ˆ๋‹ค.

์ˆ˜Y๋Š” Y ์ขŒํ‘œ์˜ ๊ฐ’์„ ์˜๋ฏธํ•ฉ๋‹ˆ๋‹ค.

ATAN2๋Š” ์Œ๊ณก ํƒ„์  ํŠธ์˜ ์—ญํ•จ์ˆ˜ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ๋Š” x์ถ•๊ณผ NumberX์—์„œ NumberY๋ฅผ ์ž‡๋Š” ์„ ์˜ ๊ฐ๋„๋ฅผ ๋ผ๋””์•ˆ์œผ๋กœ ํ‘œ์‹œํ•œ ๊ฒƒ์œผ๋กœ -PI์ดˆ๊ณผ PI๋ฏธ๋งŒ์˜ ๋ฒ”์œ„์—์„œ ์ •์˜๋ฉ๋‹ˆ๋‹ค.

๋„ ๋‹จ์œ„ ๊ฐ๋„ ๊ฐ’์„ ๊ตฌํ•˜๋ ค๋ฉด DEGREES ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=ATAN2(20;20)๋Š” 0.785398163397448(PI/4 ๋ผ๋””์•ˆ)์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=DEGREES(ATAN2(12.3;12.3))์€ 45๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. 45๋„์˜ ํƒ„์  ํŠธ๊ฐ’์€ 1์ž…๋‹ˆ๋‹ค.

ATANH

์ˆซ์ž์˜ ์—ญ ์Œ๊ณก์„  ํƒ„์  ํŠธ๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

ATANH(Number)

์ด ํ•จ์ˆ˜๋Š” ์ฃผ์–ด์ง„ Number์˜ ์—ญ ์Œ๊ณก ํƒ„์  ํŠธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค. ์ด๋Š” ๊ฒฐ๊ณผ ๊ฐ’์˜ ์Œ๊ณก ํƒ„์  ํŠธ ๊ฐ’์ด Number๊ฐ€ ๋˜๋Š” ์ˆ˜์น˜๋ฅผ ๋งํ•ฉ๋‹ˆ๋‹ค.

์ˆ˜๋Š” ๋ฐ˜๋“œ์‹œ -1 ์ดˆ๊ณผ 1 ๋ฏธ๋งŒ(-1<์ˆ˜<1)์˜ ์กฐ๊ฑด์„ ๋งŒ์กฑํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=ATANH(0)๋Š” 0์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

CEILING

์ˆซ์ž๋ฅผ ๊ฐ€์žฅ ๊ฐ€๊นŒ์šด ์œ ์˜๊ฐ’ ๋ฐฐ์ˆ˜๋กœ ๋ฐ˜์˜ฌ๋ฆผํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

CEILING(Number; Significance; Mode)

Number๋Š” ๋ฐ˜์˜ฌ๋ฆผ๋  ์ˆ˜์ž…๋‹ˆ๋‹ค.

Significance๋Š” ๊ฐ’์„ ๊ทธ ๋ฐฐ์ˆ˜๋กœ ๋ฐ˜์˜ฌ๋ฆผํ•  ์ˆ˜์ž…๋‹ˆ๋‹ค.

Mode is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero.

๊ฒฝ๊ณ  ์•„์ด์ฝ˜

If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero.


์˜ˆ

=CEILING(-11;-2)๋Š” -10์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=CEILING(-11;-2;0)๋Š” -10์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=CEILING(-11;-2;1)๋Š” -12๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

CEILING.MATH

Rounds a number up to the nearest multiple of Significance.

Syntax

CEILING.MATH(Number; Significance; Mode)

Number is the number that is to be rounded up.

Significance is the number to whose multiple the value is to be rounded up.

Mode is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero.

๊ฒฝ๊ณ  ์•„์ด์ฝ˜

This function exists for interoperability with Microsoft Excel 2013 or newer.


Example

=CEILING.MATH(-10;-3) returns -9

=CEILING.MATH(-10;-3;0) returns -9

=CEILING.MATH(-10;-3;1) returns -12

CEILING.PRECISE

Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance

๊ตฌ๋ฌธ

CEILING.PRECISE(Number; Significance)

Number๋Š” ๋ฐ˜์˜ฌ๋ฆผ๋  ์ˆ˜์ž…๋‹ˆ๋‹ค.

Significance๋Š” ๊ฐ’์„ ๊ทธ ๋ฐฐ์ˆ˜๋กœ ๋ฐ˜์˜ฌ๋ฆผํ•  ์ˆ˜์ž…๋‹ˆ๋‹ค.

์˜ˆ

=CEILING(-11;-2)๋Š” -10์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

CEILING.XCL

Rounds a number away from zero to the nearest multiple of Significance.

Syntax

CEILING.XCL(Number; Significance)

Number is the number that is to be rounded.

Significance is the number to whose multiple the value is to be rounded.

๊ฒฝ๊ณ  ์•„์ด์ฝ˜

This function exists for interoperability with Microsoft Excel 2007 or older versions.


Example

=CEILING.XCL(1;3) returns 3

=CEILING.XCL(7;4) returns 8

=CEILING.XCL(-10;-3) returns -12

COMBIN

์š”์†Œ์˜ ๋ถ€๋ถ„์ง‘ํ•ฉ์— ๋Œ€ํ•œ ์กฐํ•ฉ์˜ ์ˆ˜๋ฅผ ์ค‘๋ณต์—†์ด ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

COMBIN(๊ฐฏ์ˆ˜1; Count2)

๊ฐฏ์ˆ˜1๋Š” ์ง‘ํ•ฉ์— ์†ํ•˜๋Š” ์›์†Œ์˜ ๊ฐฏ์ˆ˜์ž…๋‹ˆ๋‹ค.

Count2๋Š” ์ง‘ํ•ฉ์—์„œ ์„ ํƒํ•  ์›์†Œ์˜ ๊ฐฏ์ˆ˜์ž…๋‹ˆ๋‹ค.

COMBIN์€ ํ•ด๋‹น ํ•ญ๋ชฉ์„ ์„ ํƒํ•  ์ˆ˜ ์žˆ๋Š” ๋ฐฉ๋ฒ•์˜ ์ˆ˜๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค. ์˜ˆ๋ฅผ ๋“ค์–ด, ํ•œ ์ง‘ํ•ฉ์— A, B, C์˜ 3๊ฐ€์ง€ ํ•ญ๋ชฉ์ด ์žˆ๋Š” ๊ฒฝ์šฐ 3๊ฐ€์ง€์˜ ๋‹ค๋ฅธ ๋ฐฉ๋ฒ•์œผ๋กœ 2๊ฐœ ํ•ญ๋ชฉ์„ ์„ ํƒํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค(AB, AC, BC).

COMBIN ํ•จ์ˆ˜๋Š” ๋‹ค์Œ ์ˆ˜์‹๊ณผ ๊ฐ™์€ ์—ฐ์‚ฐ์„ ์ˆ˜ํ–‰ํ•ฉ๋‹ˆ๋‹ค. Count1!/(Count2!*(Count1-Count2)!)

์˜ˆ

=COMBIN(3;2)์€ 3์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

COMBINA

ํ•ญ๋ชฉ์˜ ๋ถ€๋ถ„์ง‘ํ•ฉ์— ๋Œ€ํ•œ ์กฐํ•ฉ์˜ ์ˆ˜๋ฅผ ์ค‘๋ณตํ•˜์—ฌ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

COMBINA(๊ฒฝ์šฐ1; ๊ฒฝ์šฐ2)

๊ฐฏ์ˆ˜1๋Š” ์ง‘ํ•ฉ์— ์†ํ•˜๋Š” ์›์†Œ์˜ ๊ฐฏ์ˆ˜์ž…๋‹ˆ๋‹ค.

Count2๋Š” ์ง‘ํ•ฉ์—์„œ ์„ ํƒํ•  ์›์†Œ์˜ ๊ฐฏ์ˆ˜์ž…๋‹ˆ๋‹ค.

COMBINA๋Š” ์„ ํƒ ์ˆœ์„œ๊ฐ€ ๋ฌด๊ด€ํ•˜๊ณ  ํ•ญ๋ชฉ์˜ ๋ฐ˜๋ณต์ด ํ—ˆ์šฉ๋˜๋Š” ์ƒํ™ฉ์—์„œ ์ด๋Ÿฌํ•œ ํ•ญ๋ชฉ์„ ๊ณ ๋ฅด๋Š” ๊ณ ์œ ํ•œ ๋ฐฉ์‹์˜ ์ˆ˜๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ์˜ˆ๋ฅผ ๋“ค์–ด, ์ง‘ํ•ฉ์— A, B, C ์„ธ ๊ฐœ์˜ ํ•ญ๋ชฉ์ด ์žˆ์œผ๋ฉด AA, AB, AC, BB, BC, CC์™€ ๊ฐ™์ด 6๊ฐœ์˜ ๋‹ค๋ฅธ ๋ฐฉ์‹์œผ๋กœ 2๊ฐœ์˜ ํ•ญ๋ชฉ์„ ๊ณ ๋ฅผ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

COMBIN ํ•จ์ˆ˜๋Š” ๋‹ค์Œ ์ˆ˜์‹๊ณผ ๊ฐ™์€ ์—ฐ์‚ฐ์„ ๊ตฌํ˜„ํ•ฉ๋‹ˆ๋‹ค. (Count1+Count2-1)! / (Count2!(Count1-1)!)

์˜ˆ

=COMBINA(3;2)๋Š” 6์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

CONVERT_OOO

๊ฐ’์˜ ํ˜„์žฌ ๋„๋Ÿ‰ํ˜• ๋‹จ์œ„๋ฅผ ๋‹ค๋ฅธ ๋„๋Ÿ‰ํ˜• ๋‹จ์œ„๋กœ ๋ณ€ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ๋ณ€ํ™˜ ๊ณ„์ˆ˜๋Š” ์„ค์ • ๋ชฉ๋ก์— ์ฃผ์–ด์ ธ ์žˆ์Šต๋‹ˆ๋‹ค.

ํ•œ๋•Œ๋Š” ๋ณ€ํ™˜ ๊ณ„์ˆ˜ ๋ชฉ๋ก์— ์ „ํ†ต ์œ ๋Ÿฝ ํ†ตํ™”์™€ ์œ ๋กœ(์•„๋ž˜ ์˜ˆ ์ฐธ๊ณ )๋ฅผ ์‹ค์–ด ๋‘์—ˆ์Šต๋‹ˆ๋‹ค. ์ด์   ์ด ํ†ตํ™”๋“ค์„ ๋ณ€ํ™˜ํ•˜๋ ค๋ฉด EUROCONVERT ํ•จ์ˆ˜๋ฅผ ์ด์šฉํ•  ๊ฒƒ์„ ์ œ์•ˆํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

CONVERT_OOO(value;"text";"text")

์˜ˆ

=CONVERT_OOO(100;"ATS";"EUR") returns the Euro value of 100 Austrian Schillings.

=CONVERT_OOO(100;"EUR";"DEM") converts 100 Euros into German Marks.

COS

ํ•ด๋‹น ๊ฐ๋„(๋ผ๋””์•ˆ)์— ๋Œ€ํ•œ ์ฝ”์‚ฌ์ธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

COS(Number)

์ˆซ์ž(๋ผ๋””์•ˆ ๋‹จ์œ„์˜ ๊ฐ๋„)์— ๋Œ€ํ•œ (์‚ผ๊ฐ) ์ฝ”์‚ฌ์ธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๋„ ๋‹จ์œ„ ๊ฐ๋„์˜ ์ฝ”์‚ฌ์ธ ๊ฐ’์„ ๊ตฌํ•˜๋ ค๋ฉด RADIANS ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=COS(PI()/2)๋Š” PI/2 ๋ผ๋””์•ˆ์˜ ์ฝ”์‚ฌ์ธ๊ฐ’์ธ 0์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=COS(RADIANS(60))๋Š” 60๋„์˜ ์ฝ”์‚ฌ์ธ ๊ฐ’์ธ 0.5๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

COSH

์ˆซ์ž์˜ ์Œ๊ณก์„  ์ฝ”์‚ฌ์ธ์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

COSH(Number)

์ˆซ์ž์— ๋Œ€ํ•œ ์Œ๊ณก์„  ์ฝ”์‚ฌ์ธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=COSH(0) 0์˜ ์Œ๊ณก ์ฝ”์‚ฌ์ธ ๊ฐ’์ธ 1์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

COT

ํ•ด๋‹น ๊ฐ๋„(๋ผ๋””์•ˆ)์— ๋Œ€ํ•œ ์ฝ”ํƒ„์  ํŠธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

COT(Number)

์ˆซ์ž(๋ผ๋””์•ˆ ๋‹จ์œ„์˜ ๊ฐ๋„)์— ๋Œ€ํ•œ (์‚ผ๊ฐ) ์ฝ”ํƒ„์  ํŠธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๋„ ๋‹จ์œ„ ๊ฐ๋„์˜ ์ฝ”ํƒ„์  ํŠธ ๊ฐ’์„ ๊ตฌํ•˜๋ ค๋ฉด RADIANS ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.

๊ฐ๋„์˜ ์ฝ”ํƒ„์  ํŠธ ๊ฐ’์€ 1์„ ํ•ด๋‹น ๊ฐ๋„์˜ ํƒ„์  ํŠธ ๊ฐ’์œผ๋กœ ๋‚˜๋ˆˆ ๊ฒƒ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค.

์˜ˆ:

=COT(PI()/4)๋Š” PI/4 ๋ผ๋””์•ˆ์˜ ์ฝ”ํƒ„์  ํŠธ๊ฐ’์ธ 1์„ ๋ฐ˜ํ™˜ํ•  ๊ฒƒ์ž…๋‹ˆ๋‹ค.

=COT(RADIANS(45))๋Š” 45๋„์˜ ์ฝ”ํƒ„์  ํŠธ ๊ฐ’์ธ 1์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

COTH

์ฃผ์–ด์ง„ ์ˆซ์ž(๊ฐ๋„)์˜ ์—ญ ์Œ๊ณก์„  ์ฝ”ํƒ„์  ํŠธ๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

COTH(Number)

Number์— ๋Œ€ํ•œ ์Œ๊ณก ์ฝ”ํƒ„์  ํŠธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=COTH(1) 1์˜ ์Œ๊ณก ์ฝ”ํƒ„์  ํŠธ ๊ฐ’์˜ ๊ทผ์‚ฌ์น˜์ธ 1.3130์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

CSC

Returns the cosecant of the given angle (in radians). The cosecant of an angle is equivalent to 1 divided by the sine of that angle

๊ตฌ๋ฌธ

COSH(Number)

์ˆซ์ž(๋ผ๋””์•ˆ ๋‹จ์œ„์˜ ๊ฐ๋„)์— ๋Œ€ํ•œ (์‚ผ๊ฐ) ์ฝ”์‚ฌ์ธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๋„ ๋‹จ์œ„ ๊ฐ๋„์˜ ์ฝ”์‚ฌ์ธ ๊ฐ’์„ ๊ตฌํ•˜๋ ค๋ฉด RADIANS ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=CSC(PI()/4) returns approximately 1.4142135624, the inverse of the sine of PI/4 radians.

=COS(RADIANS(60))๋Š” 60๋„์˜ ์ฝ”์‚ฌ์ธ ๊ฐ’์ธ 0.5๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

CSCH

์ˆซ์ž์˜ ์Œ๊ณก์„  ์ฝ”์‚ฌ์ธ์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

COSH(Number)

์ˆซ์ž์— ๋Œ€ํ•œ ์Œ๊ณก์„  ์ฝ”์‚ฌ์ธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=CSCH(1) returns approximately 0.8509181282, the hyperbolic cosecant of 1.

DEGREES

๋ผ๋””์•ˆ์„ ๋„๋กœ ๋ณ€ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

DEGREES(์ˆซ์ž)

์ˆซ์ž๋Š” ๊ฐ๋„ ๋‹จ์œ„๋กœ ๋ณ€ํ™˜ํ•˜๋ ค๋Š” ๋ผ๋””์•ˆ ๋‹จ์œ„์˜ ๊ฐ๋„์ž…๋‹ˆ๋‹ค.

์˜ˆ

=DEGREES(PI())๋Š” 180๋„๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

EUROCONVERT

์ด์ „ ์œ ๋Ÿฝ ๊ตญ๊ฐ€๋ณ„ ํ†ตํ™”์™€ ์œ ๋กœ ํ†ตํ™”๋ฅผ ํ™˜์‚ฐํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

EUROCONVERT(Value; "From_currency"; "To_currency", full_precision, triangulation_precision)

Value๋Š” ๋ณ€ํ™˜ํ•  ํ†ตํ™”์˜ ์–‘์ž…๋‹ˆ๋‹ค.

From_currency๋Š” ๋ณ€ํ™˜ํ•  ํ†ตํ™”, To_currency๋Š” ๋ณ€ํ™˜๋  ํ†ตํ™”์ž…๋‹ˆ๋‹ค. ๊ฐ’์€ ํ…์ŠคํŠธ์ด์–ด์•ผํ•˜๋ฉฐ "EUR" ๋“ฑ์˜ ๊ณต์‹์ ์ธ ์•ฝ์นญ๊ณผ ํ™˜์œจ์€ ์œ ๋Ÿฝ์œ„์›ํšŒ(European Commision)์ด ์ •ํ•œ ๊ฐ’์— ๋”ฐ๋ฆ…๋‹ˆ๋‹ค.

๋์ˆ˜ ํ‘œ๊ธฐ๋Š” ์„ ํƒ ์‚ฌํ•ญ์ž…๋‹ˆ๋‹ค. ๋งŒ์•ฝ ์ƒ๋žตํ•˜๊ฑฐ๋‚˜ ๋น„ํ™œ์„ฑํ™”ํ•˜๋ฉด ํ†ตํ™”์— ๋”ฐ๋ผ ๋์ž๋ฆฌ๋ฅผ ๋ฐ˜์˜ฌ๋ฆผํ•ฉ๋‹ˆ๋‹ค. ํ™œ์„ฑํ™”ํ–ˆ์„ ๋•Œ, ๊ฒฐ๊ณผ์— ๋์ˆ˜๊ฐ€ ๋ฐ˜์˜๋ฉ๋‹ˆ๋‹ค.

์‚ผ๊ฐ ํ‘œ๊ธฐ๋Š” ์„ ํƒ ์‚ฌํ•ญ์ž…๋‹ˆ๋‹ค. ๋งŒ์•ฝ ์‚ผ๊ฐ ํ‘œ๊ธฐ๊ฐ€ ์ฃผ์–ด์กŒ๊ฑฐ๋‚˜ >=3์ผ ๋•Œ, (currency1,EUR,currency2)์˜ ์‚ผ๊ฐ ์น˜ํ™˜์— ์˜ํ•œ ์ค‘๊ฐ„ ๊ฒฐ๊ณผ์— ๋ฐ˜์˜ฌ๋ฆผ ์ฒ˜๋ฆฌ๊ฐ€ ์ด๋ฃจ์–ด์ง‘๋‹ˆ๋‹ค. ์‚ผ๊ฐ ํ‘œ๊ธฐ๊ฐ€ ์ƒ๋žต๋˜์—ˆ์„ ๊ฒฝ์šฐ, ์ค‘๊ฐ„ ๊ฒฐ๊ณผ๋Š” ๋ฐ˜์˜ฌ๋ฆผ๋˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค. ๋˜ํ•œ, ํ†ตํ™”๊ฐ€ "EUR(์œ ๋กœ)"๋ผ๋ฉด, ์‚ผ๊ฐ ํ‘œ๊ธฐ๋Š” ์‚ผ๊ฐ ์ธก๋Ÿ‰์ด ํ•„์š”ํ•˜๊ณ  EUR(์œ ๋กœ)์—์„œ EUR(์œ ๋กœ)๋กœ ๋ณ€ํ™˜ํ•œ ๊ฒƒ์ฒ˜๋Ÿผ ์ ์šฉ๋ฉ๋‹ˆ๋‹ค.

์˜ˆ

=EUROCONVERT(100;"ATS";"EUR")๋Š” 100 ์˜ค์ŠคํŠธ๋ฆฌ์•„ ์‹ค๋ง์„ ์œ ๋กœ๋กœ ๋ณ€ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=EUROCONVERT(100;"EUR";"DEM")๋Š” 100 ์œ ๋กœ๋ฅผ ๋…์ผ ๋งˆ๋ฅดํฌ๋กœ ๋ณ€ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

EVEN

์–‘์ˆ˜๋Š” ๊ฐ€์žฅ ๊ฐ€๊นŒ์šด ์ง์ˆ˜์ธ ์ •์ˆ˜๋กœ ์˜ฌ๋ฆผํ•˜๊ณ  ์Œ์ˆ˜๋Š” ๊ฐ€์žฅ ๊ฐ€๊นŒ์šด ์ง์ˆ˜์ธ ์ •์ˆ˜๋กœ ๋ฒ„๋ฆผํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

EVEN(Number)

์ฃผ์–ด์ง„ Number๊ฐ€ 0์—์„œ ๋ฉ€์–ด์ง€๋„๋ก ๊ฐ€๊นŒ์šด ์ง์ˆ˜ ์ •์ˆ˜๋กœ ์˜ฌ๋ฆผ๊ฐ’์„ ๊ณ„์‚ฐํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

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

=EVEN(2)์€ 2๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=EVEN(0)์€ 0์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=EVEN(-0.5)๋Š” -2๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

EXP

์ˆซ์ž์˜ ์ง€์ˆ˜๋งŒํผ ๊ฑฐ๋“ญ ์ œ๊ณฑ๋˜๋Š” e๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค. ์ƒ์ˆ˜ e์˜ ๊ฐ’์€ ์•ฝ 2.71828182845904์ž…๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

EXP(Number)

Number๋Š” e๋ฅผ ์ œ๊ณฑํ•˜๋Š” ์ง€์ˆ˜์ž…๋‹ˆ๋‹ค.

์˜ˆ

=EXP(1)์ˆ˜ํ•™ ์ƒ์ˆ˜ e์— ๋Œ€ํ•œ Calc์˜ ์ •์˜์— ๋”ฐ๋ผ 2.71828182845904๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

FACT

์ˆซ์ž์— ๋Œ€ํ•œ ๊ณ„์Šน๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

FACT(Number)

"์ˆ˜!" ์ˆ˜์‹์€ ์ฃผ์–ด์ง„ ์ˆ˜์˜ ํŒฉํ† ๋ฆฌ์–ผ(๊ณ„์Šน)์„ ์˜๋ฏธํ•ฉ๋‹ˆ๋‹ค. ํŒฉํ† ๋ฆฌ์–ผ์„ ๊ณ„์‚ฐํ•˜๋Š” ๋ฐฉ๋ฒ•์€ ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค. ์ˆ˜*(์ˆ˜-1)*(์ˆ˜-2)* ... *2*1

FACT(0)์€ ์ •์˜์— ๋”ฐ๋ผ 1์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

์Œ์ˆ˜๋กœ ๊ณ„์Šน๊ฐ’์„ ๊ณ„์‚ฐํ•˜๋ฉด "์œ ํšจํ•˜์ง€ ์•Š์€ ์ธ์ˆ˜" ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=FACT(3)๋Š” 6์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=FACT(0)๋Š” 1์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

FLOOR

์ˆซ์ž๋ฅผ ๊ฐ€์žฅ ๊ฐ€๊นŒ์šด ์œ ์˜๊ฐ’ ๋ฐฐ์ˆ˜๋กœ ๋ฐ˜๋ฒ„๋ฆผํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

FLOOR(์ˆซ์ž;์œ ์˜๊ฐ’;Mode)

Number๋ฒ„๋ฆด ์ˆ˜์ž…๋‹ˆ๋‹ค.

์œ ์˜๊ฐ’์€ ์ˆซ์ž๋ฅผ ๊ทธ ๋ฐฐ์ˆ˜๋กœ ๋‚ด๋ฆผํ•˜๋Š” ๊ฐ’์ž…๋‹ˆ๋‹ค.

Mode is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded towards zero. If the Mode value is equal to zero or is not given, negative numbers are rounded away from zero.

๊ฒฝ๊ณ  ์•„์ด์ฝ˜

If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero.


์˜ˆ

=FLOOR( -11;-2)๋Š” -12๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=FLOOR( -11;-2;0)๋Š” -12๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=FLOOR( -11;-2;1)๋Š” -10์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

FLOOR.PRECISE

Rounds a number down to the nearest multiple of Significance, regardless of sign of Significance

๊ตฌ๋ฌธ

FLOOR.PRECISE(Number; Significance)

Number๋ฒ„๋ฆด ์ˆ˜์ž…๋‹ˆ๋‹ค.

์œ ์˜๊ฐ’์€ ์ˆซ์ž๋ฅผ ๊ทธ ๋ฐฐ์ˆ˜๋กœ ๋‚ด๋ฆผํ•˜๋Š” ๊ฐ’์ž…๋‹ˆ๋‹ค.

์˜ˆ

=FLOOR( -11;-2)๋Š” -12๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

GCD

๋‘˜ ์ด์ƒ ์ •์ˆ˜์˜ ์ตœ๋Œ€ ๊ณต์•ฝ์ˆ˜๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

์ตœ๋Œ€ ๊ณต์•ฝ์ˆ˜๋Š” ์ œ๊ณต๋œ ๊ฐ ์ •์ˆ˜๋ฅผ ๋‚˜๋จธ์ง€ ์—†์ด ๋‚˜๋ˆŒ ์ˆ˜ ์žˆ๋Š” ๊ฐ€์žฅ ํฐ ์–‘์˜ ์ •์ˆ˜์ž…๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

GCD(์ •์ˆ˜1; ์ •์ˆ˜2; ...; ์ •์ˆ˜30)

์ •์ˆ˜1, ์ •์ˆ˜2, ... 30์€ ์ตœ๋Œ€๊ณต์•ฝ์ˆ˜๋ฅผ ๊ตฌํ•˜๊ธฐ ์œ„ํ•œ ์ตœ๋Œ€ 30๊ฐœ์˜ ์ •์ˆ˜ ๋ฆฌ์ŠคํŠธ์ž…๋‹ˆ๋‹ค.

์˜ˆ

=GCD(16;32;24)๋Š” ์ฃผ์–ด์ง„ ์ˆซ์ž๋“ค์˜ ๊ณต์•ฝ์ˆ˜์ธ 8, 16, 24, 32 ์ค‘ ์ตœ๋Œ€๊ณต์•ฝ์ˆ˜์ธ 8์„ ๊ฒฐ๊ณผ๋กœ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

B1, B2, B3๊ฐ€ ๊ฐ๊ฐ 9, 12, 9์˜ ๊ฐ’์„ ๊ฐ€์ง„๋‹ค๋ฉด =GCD(B1:B3)๋Š” 3์„ ๊ฒฐ๊ณผ๋กœ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

GCD_EXCEL2003

The result is the greatest common divisor of a list of numbers.

์ฐธ๊ณ  ์•„์ด์ฝ˜

The functions whose names end with _ADD or _EXCEL2003 return the same results as the corresponding Microsoft Excel 2003 functions without the suffix. Use the functions without suffix to get results based on international standards.


๊ตฌ๋ฌธ

GCD_EXCEL2003(Number(s))

Number๋Š” ์ตœ๋Œ€ 30๊ฐœ๊นŒ์ง€์˜ ์ •์ˆ˜ ๋ฆฌ์ŠคํŠธ์ž…๋‹ˆ๋‹ค.

์˜ˆ

=GCD_EXCEL2003(5;15;25) returns 5.

INT

๊ฐ€์žฅ ๊ฐ€๊นŒ์šด ์ •์ˆ˜๋กœ ๋ฐ˜๋ฒ„๋ฆผํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

INT(Number)

์ฃผ์–ด์ง„ Number๋ฅผ ๊ฐ€์žฅ ๊ฐ€๊นŒ์šด ์ •์ˆ˜๋กœ ๋‚ด๋ฆผํ•œ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

์Œ์ˆ˜์˜ ๊ฒฝ์šฐ์—๋Š” ๋‚ฎ์€ ์ •์ˆ˜๋กœ ๋ฒ„๋ฆผ๋ฉ๋‹ˆ๋‹ค.

์˜ˆ

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

=INT(-1.3)๋Š” -2๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

ISO.CEILING

Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance

๊ตฌ๋ฌธ

ISO.CEILING(Number; Significance)

Number๋Š” ๋ฐ˜์˜ฌ๋ฆผ๋  ์ˆ˜์ž…๋‹ˆ๋‹ค.

Significance๋Š” ๊ฐ’์„ ๊ทธ ๋ฐฐ์ˆ˜๋กœ ๋ฐ˜์˜ฌ๋ฆผํ•  ์ˆ˜์ž…๋‹ˆ๋‹ค.

์˜ˆ

=CEILING(-11;-2)๋Š” -10์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

LCM

ํ•˜๋‚˜ ์ด์ƒ ์ •์ˆ˜์˜ ์ตœ์†Œ ๊ณต๋ฐฐ์ˆ˜๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

LCM(์ •์ˆ˜1; ์ •์ˆ˜2; ...; ์ •์ˆ˜30)

์ •์ˆ˜1๋ถ€ํ„ฐ 30์€ ์ตœ์†Œ๊ณต๋ฐฐ์ˆ˜๋ฅผ ๊ณ„์‚ฐํ•  ์ตœ๋Œ€ 30๊ฐœ๊นŒ์ง€์˜ ์ •์ˆ˜ ๋ฆฌ์ŠคํŠธ์ž…๋‹ˆ๋‹ค.

์˜ˆ

๋งŒ์ผ 512, 1024๊ณผ 2000๋ฅผ ๊ฐ๊ฐ ์ •์ˆ˜1, 2, 3์— ์ž…๋ ฅํ•œ๋‹ค๋ฉด, 128000์ด ๊ฒฐ๊ณผ๊ฐ’์œผ๋กœ ๋ฐ˜ํ™˜๋  ๊ฒƒ์ž…๋‹ˆ๋‹ค.

LCM_EXCEL2003

The result is the lowest common multiple of a list of numbers.

์ฐธ๊ณ  ์•„์ด์ฝ˜

The functions whose names end with _ADD or _EXCEL2003 return the same results as the corresponding Microsoft Excel 2003 functions without the suffix. Use the functions without suffix to get results based on international standards.


๊ตฌ๋ฌธ

LCM_EXCEL2003(Number(s))

Number๋Š” ์ตœ๋Œ€ 30๊ฐœ๊นŒ์ง€์˜ ์ •์ˆ˜ ๋ฆฌ์ŠคํŠธ์ž…๋‹ˆ๋‹ค.

์˜ˆ

=LCM_EXCEL2003(5;15;25) returns 75.

LN

์ˆซ์ž์˜ ์ƒ์ˆ˜ e๋ฅผ ๊ธฐ์ค€์œผ๋กœ ์ž์—ฐ ๋กœ๊ทธ๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค. ์ƒ์ˆ˜ e์˜ ๊ฐ’์€ ์•ฝ 2.71828182845904์ž…๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

LN(Number)

์ˆซ์ž๋Š” ์ž์—ฐ ๋กœ๊ทธ๋ฅผ ๊ณ„์‚ฐํ•  ๊ฐ’์ž…๋‹ˆ๋‹ค.

์˜ˆ

=LN(3)๋Š” 3์˜ ์ž์—ฐ๋กœ๊ทธ ๊ฐ’(์•ฝ 1.0986)์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=LN(EXP(321))๋Š” 321์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

LOG

์ง€์ •ํ•œ ๋ฐ‘์— ๋Œ€ํ•œ ๋กœ๊ทธ๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

LOG(์ง„์ˆ˜; ๋ฐ‘)

Number๋Š” ๋กœ๊ทธ๊ฐ€ ๊ณ„์‚ฐ๋  ๊ฐ’์ž…๋‹ˆ๋‹ค.

Base(์„ ํƒ ์‚ฌํ•ญ)๋Š” ๋กœ๊ทธ ๊ณ„์‚ฐ์„ ์œ„ํ•œ ๋ฐ‘์ž…๋‹ˆ๋‹ค. ๋ฌด์‹œํ•  ๋•Œ์—” 10์ด ๋ฐฐ์ •๋ฉ๋‹ˆ๋‹ค.

์˜ˆ

=LOG(10;3)๋Š” 10์˜ ๋ฐ‘์„ 3์œผ๋กœ ํ•˜๋Š” ๋กœ๊ทธ๊ฐ’(์•ฝ 2.0959)์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=LOG(7^4;7)๋Š” 4๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

LOG10

์ˆซ์ž์˜ ๋ฐ‘์ˆ˜๊ฐ€ 10์ธ ๋กœ๊ทธ๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

LOG10(Number)

์ฃผ์–ด์ง„ Number์˜ ์ƒ์šฉ๋กœ๊ทธ(10์„ ๋ฐ‘์œผ๋กœ ํ•˜๋Š” ๋กœ๊ทธ) ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=LOG10(5)๋Š” 5์˜ 10์„ ๋ฐ‘์œผ๋กœ ํ•˜๋Š” ์ƒ์šฉ๋กœ๊ทธ๊ฐ’(์•ฝ 0.69897)์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

MOD

ํ•œ ์ •์ˆ˜๋ฅผ ๋‹ค๋ฅธ ์ •์ˆ˜๋กœ ๋‚˜๋ˆˆ ๋‚˜๋จธ์ง€๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

MOD(Dividend; Divisor)

๋ณ€์ˆ˜๊ฐ€ ์ •์ˆ˜์ผ ๋•Œ ์ด ํ•จ์ˆ˜๋Š” ํ”ผ์ œ์ˆ˜๊ฐ€ ์ œ์ˆ˜๋กœ ๋‚˜๋ˆ„์–ด์ง€๊ณ  ๋‚จ์€ ๋‚˜๋จธ์ง€๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

์ด ํ•จ์ˆ˜๋Š” ํ”ผ์ œ์ˆ˜ - ์ œ์ˆ˜ * INT(ํ”ผ์ œ์ˆ˜/์ œNumber)๋กœ ํ‘œํ˜„๋˜๋ฉฐ ์ด ์ˆ˜์‹์€ ๋ณ€์ˆ˜๊ฐ€ ์ •์ˆ˜๊ฐ€ ์•„๋‹ ๋•Œ์—๋„ ์›ํ•˜๋Š” ๊ฒฐ๊ณผ๋ฅผ ์–ป์„ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

์˜ˆ

=MOD(22;3)๋Š” 22๋ฅผ 3์œผ๋กœ ๋‚˜๋ˆ„๊ณ  ๋‚จ์€ ๋‚˜๋จธ์ง€์ธ 1์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=MOD(11.25;2.5)์€ 1.25๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

MROUND

์ง€์ •๋œ ์ˆซ์ž๋ฅผ ๋‹ค๋ฅธ ์ˆซ์ž์˜ ๊ฐ€์žฅ ๊ฐ€๊นŒ์šด ๋ฐฐ์ˆ˜๋กœ ๋ฐ˜์˜ฌ๋ฆผํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

MROUND(Number; Multiple)

์ง€์ •ํ•œ ๋ฐฐ์ˆ˜์— ๋Œ€ํ•œ ๋ฐฐ์ˆ˜๊ฐ’ ์ค‘ ๊ฐ€์žฅ ๊ฐ€๊นŒ์šด ๊ฐ’์œผ๋กœ ์ˆซ์ž๋ฅผ ๋ฐ˜์˜ฌ๋ฆผํ•ฉ๋‹ˆ๋‹ค.

๋‹ค๋ฅธ ๊ตฌํ˜„ ๋ฐฉ๋ฒ•์œผ๋กœ ๋ฐฐ์ˆ˜ * ROUND(์ˆซ์ž/๋ฐฐNumber)๋ฅผ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

์˜ˆ

=MROUND(15.5;3)์ผ ๋•Œ, 15.5๋Š” 3*6์ธ 18๋ณด๋‹ค 3*5์ธ 15์— ๊ฐ€๊น๊ธฐ ๋•Œ๋ฌธ์— ๊ฒฐ๊ณผ๊ฐ’์œผ๋กœ๋Š” 15๊ฐ€ ๋ฐ˜ํ™˜๋ฉ๋‹ˆ๋‹ค.

=MROUND(1.4;0.5)๋Š” 1.5( = 0.5*3)๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

MULTINOMIAL

Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments.

๊ตฌ๋ฌธ

MULTINOMIAL(Number)

Number๋Š” ์ตœ๋Œ€ 30๊ฐœ๊นŒ์ง€์˜ ์ •์ˆ˜ ๋ฆฌ์ŠคํŠธ์ž…๋‹ˆ๋‹ค.

์˜ˆ

๋งŒ์ผ F11๋ถ€ํ„ฐ H11๊นŒ์ง€์˜ ์…€์ด ๊ฐ๊ฐ 2, 3, 4๋ผ๋ฉด =MULTINOMIAL(F11:H11)๋Š” =(2+3+4)! / (2!*3!*4!)๋ฅผ ๊ณ„์‚ฐํ•œ ๊ฐ’์ธ 1260์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

ODD

์–‘์ˆ˜๋Š” ๊ฐ€์žฅ ๊ฐ€๊นŒ์šด ํ™€์ˆ˜์ธ ์ •์ˆ˜๋กœ ๋ฐ˜์˜ฌ๋ฆผํ•˜๊ณ  ์Œ์ˆ˜๋Š” ๊ฐ€์žฅ ๊ฐ€๊นŒ์šด ํ™€์ˆ˜์ธ ์ •์ˆ˜๋กœ ๋ฐ˜๋ฒ„๋ฆผํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

ODD(Number)

Number๋ฅผ 0์—์„œ ๋จผ ๋ฐฉํ–ฅ์œผ๋กœ ๊ฐ€์žฅ ๊ฐ€๊นŒ์šด ํ™€์ˆ˜ ์ •์ˆ˜๋กœ ๊ทผ์‚ฌ์‹œํ‚จ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=ODD(1.2)๋Š” 3์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=ODD(0)์€ 1์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=ODD(0)์€ 1์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=ODD(-3.1)๋Š” -5๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

PI

์ƒ์ˆ˜ PI์˜ ๊ฐ’์„ 14๋ฒˆ์งธ ์†Œ์ˆ˜์  ์ดํ•˜ ์ž๋ฆฟ์ˆ˜๊นŒ์ง€ ํ‘œ์‹œํ•˜์—ฌ 3.14159265358979๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

PI()

์˜ˆ

=PI()๋Š” 3.14159265358979์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

POWER

๋‹ค๋ฅธ ์ˆ˜๋กœ ์ œ๊ณฑ๋˜๋Š” ์ˆ˜๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

POWER(Base; Exponent)

Base๋ฅผ Exponent๋กœ ์ œ๊ณฑํ•œ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

๋ˆ„์Šน ์—ฐ์‚ฐ์ž ^๋ฅผ ์‚ฌ์šฉํ•˜๋ฉด ์ด์™€ ๋™์ผํ•œ ๊ฒฐ๊ณผ๋ฅผ ์–ป์„ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

Base^Exponent

์˜ˆ

=POWER(4;3)๋Š” 4์˜ 3์ œ๊ณฑ์ธ 64๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=4^3 ์™ผ์ชฝ ์ˆ˜์‹ ๋˜ํ•œ 4์˜ 3์ œ๊ณฑ์„ ์˜๋ฏธํ•ฉ๋‹ˆ๋‹ค.

PRODUCT

์ธ์ˆ˜๋กœ ์ œ๊ณต๋œ ๋ชจ๋“  ์ˆซ์ž๋ฅผ ๊ณฑํ•˜๊ณ  ๊ณฑ์„ ๊ณ„์‚ฐํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

PRODUCT(์ˆ˜1; ์ˆ˜2; ...; ์ˆ˜30)

์ˆ˜1๋ถ€ํ„ฐ 30๋Š” ๊ทธ ๊ณฑํ•œ ๊ฐ’์„ ๊ตฌํ•˜๊ธฐ ์›ํ•˜๋Š” ์ •์ˆ˜์ž…๋‹ˆ๋‹ค. 30๊ฐœ๊นŒ์ง€ ์ž…๋ ฅํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

PRODUCT๋Š” ์ˆซ์ž1 * ์ˆซ์ž2 * ์ˆซ์ž3 * ...์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=PRODUCT(2;3;4)๋Š” 24๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

QUOTIENT

๋‚˜๋ˆ—์…ˆ ์—ฐ์‚ฐ์˜ ์ •์ˆ˜ ๋ถ€๋ถ„์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

QUOTIENT(ํ”ผ์—ฐ์‚ฐ์ž; ์—ฐ์‚ฐ์ž)

๋ถ„์ž๋ฅผ ๋ถ„๋ชจ๋กœ ๋‚˜๋ˆ„์–ด ๊ทธ ๋ชซ์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

QUOTIENT is equivalent to INT(numerator/denominator) for same-sign numerator and denominator, except that it may report errors with different error codes. More generally, it is equivalent to INT(numerator/denominator/SIGN(numerator/denominator))*SIGN(numerator/denominator).

์˜ˆ

=QUOTIENT(11;3)๋Š” 3์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ๋‚˜๋จธ์ง€๊ฐ’์ธ 2๋Š” ๋ฒ„๋ ค์ง‘๋‹ˆ๋‹ค.

RADIANS

๋„๋ฅผ ๋ผ๋””์•ˆ์œผ๋กœ ๋ณ€ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

RADIANS(Number)

Number๋Š” ๋ผ๋””์•ˆ ๊ฐ’์œผ๋กœ ๋ณ€ํ™˜ํ•˜๋ ค๋Š” ๊ฐ๋„์ž…๋‹ˆ๋‹ค.

์˜ˆ

=RADIANS(90)๋Š” PI/2์— ๋Œ€ํ•œ Calc์˜ ์ •์˜์— ๋”ฐ๋ผ 1.5707963267949๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

RAND

0์—์„œ 1 ์‚ฌ์ด์˜ ๋‚œ์ˆ˜๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

RAND()

This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press F9.

๋‚œ์ˆ˜ ๊ฐ’์„ ์ƒ์„ฑํ•œ ํ›„ ๊ทธ ๊ฐ’ ๊ทธ๋Œ€๋กœ๋ฅผ ๋ณต์‚ฌํ•ด ๋ถ™์—ฌ๋„ฃ๊ธฐ ์œ„ํ•ด์„œ๋Š” =RAND() ํ•จ์ˆ˜๋ฅผ ์ด์šฉํ•ด ๋‚œ์ˆ˜๋ฅผ ์ƒ์„ฑํ•œํ›„ ํ•ด๋‹น ์…€์„ ๋ณต์‚ฌํ•ด ํŽธ์ง‘ - ์„ ํƒํ•˜์—ฌ ๋ถ™์—ฌ๋„ฃ๊ธฐ์—์„œ ๋ชจ๋‘ ๋ถ™์—ฌ๋„ฃ๊ธฐ์™€ ์ˆ˜์‹์„ ์ฒดํฌ ํ•ด์ œํ•˜๊ณ  ์ˆซ์ž๋ฅผ ์ฒดํฌํ•œ ์ƒํƒœ์—์„œ ๋ถ™์—ฌ๋„ฃ์œผ์‹œ๋ฉด ๋ฉ๋‹ˆ๋‹ค.

์˜ˆ

=RAND()๋Š” 0๊ณผ 1 ์‚ฌ์ด์˜ ์ˆ˜๋ฅผ ๋ฌด์ž‘์œ„๋กœ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

RANDBETWEEN

์ง€์ •๋œ ๋ฒ”์œ„์—์„œ ๋ฌด์ž‘์œ„ ์ •์ˆ˜๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

RANDBETWEEN(์‹œ์ž‘ ์ˆซ์ž; ๋ ์ˆซ์ž)

์ฒซ์ˆ˜์ด์ƒ ๋์ˆ˜์ดํ•˜์˜ ๋ฒ”์œ„์—์„œ ๋ฌด์ž‘์œ„์˜ ์ •์ˆ˜๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

์ด ํ•จ์ˆ˜๋Š” ์žฌ๊ณ„์‚ฐํ• ๋•Œ๋งˆ๋‹ค ์ƒˆ๋กœ์šด ๋‚œ์ˆ˜๋ฅผ ๋งŒ๋“ค์–ด๋ƒ…๋‹ˆ๋‹ค. ๊ฐ•์ œ๋กœ ๋‹ค์‹œ ๊ณ„์‚ฐํ•˜๊ฒŒ ํ•˜๋ ค๋ฉด Shift + + F9 ํ‚ค๋ฅผ ๋ˆ„๋ฅด์‹ญ์‹œ์˜ค.

๋‚œ์ˆ˜ ๊ฐ’์„ ์ƒ์„ฑํ•œ ํ›„ ๊ทธ ๊ฐ’ ๊ทธ๋Œ€๋กœ๋ฅผ ๋ณต์‚ฌํ•ด ๋ถ™์—ฌ๋„ฃ๊ธฐ ์œ„ํ•ด์„œ๋Š” ์ด ํ•จ์ˆ˜๋ฅผ ์ด์šฉํ•ด ๋‚œ์ˆ˜๋ฅผ ์ƒ์„ฑํ•œํ›„ ํ•ด๋‹น ์…€์„ ๋ณต์‚ฌํ•ด ํŽธ์ง‘ - ์„ ํƒํ•˜์—ฌ ๋ถ™์—ฌ๋„ฃ๊ธฐ์—์„œ ๋ชจ๋‘ ๋ถ™์—ฌ๋„ฃ๊ธฐ์™€ ์ˆ˜์‹์„ ์ฒดํฌ ํ•ด์ œํ•˜๊ณ  ์ˆซ์ž๋ฅผ ์ฒดํฌํ•œ ์ƒํƒœ์—์„œ ๋ถ™์—ฌ๋„ฃ์œผ์‹œ๋ฉด ๋ฉ๋‹ˆ๋‹ค.

์˜ˆ

=RANDBETWEEN(20;30)๋Š” 20์ด์ƒ 30์ดํ•˜์˜ ์ •์ˆ˜ ์ค‘ ํ•˜๋‚˜๋ฅผ ๋ฌด์ž‘์œ„๋กœ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

ROUND

์ˆซ์ž๋ฅผ ํŠน์ • ์†Œ์ˆ˜์  ์ดํ•˜ ์ž๋ฆฟ์ˆ˜๋กœ ๋ฐ˜์˜ฌ๋ฆผํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

ROUND(์ˆ˜; ์ž๋ฆฟNumber)

Number๋ฅผ ์†Œ์ˆ˜ ์ž๋ฆฟ์ˆ˜์—์„œ ๋ฐ˜์˜ฌ๋ฆผํ•œ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ์ž๋ฆฟ์ˆ˜๋ฅผ ์ƒ๋žตํ•˜๊ฑฐ๋‚˜ 0์œผ๋กœ ์ž…๋ ฅํ•œ ๊ฒฝ์šฐ, ํ•จ์ˆ˜๋Š” ์†Œ์ˆ˜์  ์•„๋ž˜๋ฅผ ์ „๋ถ€ ๋ฒ„๋ฆฌ๊ณ  ์ •์ˆ˜ ํ˜•ํƒœ๋กœ ๋งŒ๋“ญ๋‹ˆ๋‹ค. ์ž๋ฆฟ์ˆ˜๋ฅผ ์Œ์ˆ˜๋กœ ์ž…๋ ฅํ•œ ๊ฒฝ์šฐ, ํ•ด๋‹นํ•˜๋Š” ์‹ญ์ง„ ์ž๋ฆฌ์ˆ˜๊นŒ์ง€์˜ ๋ฒ„๋ฆผ์ˆ˜๋ฅผ ์ถœ๋ ฅํ•ฉ๋‹ˆ๋‹ค.

์ด ํ•จ์ˆ˜๋Š” ๊ฐ€์žฅ ๊ฐ€๊นŒ์šด ์ˆซ์ž๋กœ ๋ฐ˜์˜ฌ๋ฆผํ•ฉ๋‹ˆ๋‹ค. ๋‹ค๋ฅธ ๋ฐฉ๋ฒ•์œผ๋กœ๋Š” ROUNDDOWN๊ณผ ROUNDUP์ด ์žˆ์Šต๋‹ˆ๋‹ค.

์˜ˆ

=ROUND(2.348;2)๋Š” 2.35๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=ROUND(-32.4834;3)๋Š” -32.483๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ์…€ ์„œ์‹์„ ๋ฐ”๊พธ์–ด์„œ ๋ชจ๋“  ์ž๋ฆฌ์ˆ˜๋ฅผ ํ™•์ธํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

=ROUND(2.348;0)์€ 2๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=ROUND(2.5)๋Š” 3์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=ROUND(987.65;-2)๋Š” 1000์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

ROUNDDOWN

์ˆซ์ž๋ฅผ ํŠน์ • ์ž๋ฆฟ์ˆ˜๋กœ ๋ฒ„๋ฆผํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

ROUNDDOWN(์ˆ˜; ์ž๋ฆฌNumber)

์ž…๋ ฅ๋œ Number๋ฅผ 10์˜ ์ž๋ฆฟ์ˆ˜ ์ œ๊ณฑํ•œ ์ž๋ฆฌ์—์„œ 0์—์„œ ๊ฐ€๊นŒ์šด ์ •์ˆ˜๋กœ ๊ทผ์‚ฌํ•œ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ์ž๋ฆฌ์ˆ˜๋ฅผ ์ƒ๋žตํ•˜๊ฑฐ๋‚˜ 0์œผ๋กœ ์ž…๋ ฅํ•œ ๊ฒฝ์šฐ ์†Œ์ˆ˜์  ์•„๋ž˜๋ฅผ ์ „๋ถ€ ๋ฒ„๋ฆฌ๊ณ  ์ •์ˆ˜ ํ˜•ํƒœ๋กœ ๋งŒ๋“ญ๋‹ˆ๋‹ค. ์ž๋ฆฌ์ˆ˜๋ฅผ ์Œ์ˆ˜๋กœ ์ž…๋ ฅํ•œ ๊ฒฝ์šฐ, ํ•ด๋‹นํ•˜๋Š” 10์˜ ์ œ๊ณฑ ์ž๋ฆฌ์ˆ˜๊นŒ์ง€์˜ ๋ฒ„๋ฆผ์ˆ˜๋ฅผ ์ถœ๋ ฅํ•ฉ๋‹ˆ๋‹ค.

์ด ํ•จ์ˆ˜๋Š” ์ˆซ์ž๋ฅผ ๋ฒ„๋ฆผํ•ฉ๋‹ˆ๋‹ค. ๋‹ค๋ฅธ ๋ฐฉ๋ฒ•์œผ๋กœ๋Š” ROUNDUP๊ณผ ROUND๊ฐ€ ์žˆ์Šต๋‹ˆ๋‹ค.

์˜ˆ

=ROUNDDOWN(1.234;2)๋Š” 1.23์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=ROUNDDOWN(45.67;0)๋Š” 45๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=ROUNDDOWN(-45.67)๋Š” -45๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=ROUNDDOWN(987.65;-2)๋Š” ๊ฒฐ๊ณผ๊ฐ’์œผ๋กœ 900์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

ROUNDUP

์ˆซ์ž๋ฅผ ํŠน์ • ์ž๋ฆฟ์ˆ˜๋กœ ์˜ฌ๋ฆผํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

ROUNDUP(์ˆ˜; ์ž๋ฆฟNumber)

์ž…๋ ฅ๋œ Number๋ฅผ 10์˜ ์ž๋ฆฟ์ˆ˜ ์ œ๊ณฑํ•œ ์ž๋ฆฌ์—์„œ 0์—์„œ ๋จผ ์ •์ˆ˜๋กœ ๊ทผ์‚ฌํ•œ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ์ž๋ฆฌ์ˆ˜๋ฅผ ์ƒ๋žตํ•˜๊ฑฐ๋‚˜ 0์œผ๋กœ ์ž…๋ ฅํ•œ ๊ฒฝ์šฐ ์†Œ์ˆ˜์  ์•„๋ž˜๋ฅผ ์ „๋ถ€ ๋ฒ„๋ฆฌ๊ณ  ์ •์ˆ˜ ํ˜•ํƒœ๋กœ ๋งŒ๋“ญ๋‹ˆ๋‹ค. ์ž๋ฆฌ์ˆ˜๋ฅผ ์Œ์ˆ˜๋กœ ์ž…๋ ฅํ•œ ๊ฒฝ์šฐ, ํ•ด๋‹นํ•˜๋Š” 10์˜ ์ œ๊ณฑ ์ž๋ฆฌ์ˆ˜๊นŒ์ง€์˜ ๋ฒ„๋ฆผ์ˆ˜๋ฅผ ์ถœ๋ ฅํ•ฉ๋‹ˆ๋‹ค.

์ด ํ•จ์ˆ˜๋Š” ์ˆซ์ž๋ฅผ ์˜ฌ๋ฆผํ•ฉ๋‹ˆ๋‹ค. ๋‹ค๋ฅธ ๋ฐฉ๋ฒ•์œผ๋กœ๋Š” ROUNDDOWN๊ณผ ROUND๊ฐ€ ์žˆ์Šต๋‹ˆ๋‹ค.

์˜ˆ

=ROUNDUP(1.1111;2)๋Š” 1.12๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=ROUNDUP(1.2345;1)๋Š” 1.3์„ ๊ฒฐ๊ณผ๊ฐ’์œผ๋กœ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=ROUNDUP(45.67;0)์€ 46์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=ROUNDUP(-45.67)๋Š” -46์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=ROUNDUP(987.65;-2)๋Š” 1000์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

SEC

Returns the secant of the given angle (in radians). The secant of an angle is equivalent to 1 divided by the cosine of that angle

๊ตฌ๋ฌธ

SIN(Number)

Number์˜ ์‚ฌ์ธ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ๊ฐ๋„๋Š” ๋ผ๋””์•ˆ์œผ๋กœ ๊ณ„์‚ฐ๋ฉ๋‹ˆ๋‹ค.

๋„ ๋‹จ์œ„ ๊ฐ๋„์˜ ์‚ฌ์ธ ๊ฐ’์„ ๊ตฌํ•˜๋ ค๋ฉด RADIANS ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=SEC(PI()/4) returns approximately 1.4142135624, the inverse of the cosine of PI/4 radians.

=COS(RADIANS(60))๋Š” 60๋„์˜ ์ฝ”์‚ฌ์ธ ๊ฐ’์ธ 0.5๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

SECH

์ˆซ์ž์˜ ์Œ๊ณก์„  ์‚ฌ์ธ์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

SINH(Number)

Number์— ๋Œ€ํ•œ ์Œ๊ณก ์‚ฌ์ธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=SINH(0)๋Š” 0์˜ ์Œ๊ณก ์‚ฌ์ธ ๊ฐ’์ธ 0์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

SERIESSUM

๋ฉฑ๊ธ‰์ˆ˜์˜ 1์ฐจ ํ•ญ์— ๋Œ€ํ•œ ์ด๊ณ„๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

SERIESSUM(x;n;m;๊ณ„Number) = coefficient_1*x^n + coefficient_2*x^(n+m) + coefficient_3*x^(n+2m) +...+ coefficient_i*x^(n+(i-1)m)

๊ตฌ๋ฌธ

SERIESSUM(X; N; M; ๊ณ„Number)

X๋Š” ์ฃผ์–ด์ง„ ๊ธ‰์ˆ˜ ๋ฐฐ์—ด์˜ ์ž…๋ ฅ ๊ฐ’์ž…๋‹ˆ๋‹ค.

N๋Š” ์ดˆ๊ธฐ ์ œ๊ณฑ์ˆ˜์ž…๋‹ˆ๋‹ค.

M๋Š” N์˜ ์ฆ๋ถ„์ž…๋‹ˆ๋‹ค.

Coefficients๋Š” ๋ฐฐ์—ด ๊ธ‰์ˆ˜์ž…๋‹ˆ๋‹ค. ๊ฐ๊ฐ์˜ ๋ฐฐ์—ด์— ๋Œ€ํ•ด ํ•œ ๊ธ‰์”ฉ ์ฆ๊ฐ€ํ•ฉ๋‹ˆ๋‹ค.

SIGN

์ˆซ์ž์˜ ๊ธฐํ˜ธ๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค. ์ˆซ์ž๊ฐ€ ์–‘์ˆ˜์ด๋ฉด 1์„, ์Œ์ˆ˜์ด๋ฉด -1์„, 0์ด๋ฉด 0์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

SIGN(Number)

Number๋Š” ๋ถ€ํ˜ธ๊ฐ€ ์ง€์ •๋˜์–ด์•ผ ํ•˜๋Š” ์ˆ˜์ž…๋‹ˆ๋‹ค.

์˜ˆ

=SIGN(3.4)๋Š” 1์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=SIGN(-4.5)๋Š” -1์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

SIN

ํ•ด๋‹น ๊ฐ๋„(๋ผ๋””์•ˆ)์— ๋Œ€ํ•œ ์‚ฌ์ธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

SIN(Number)

Number์˜ ์‚ฌ์ธ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ๊ฐ๋„๋Š” ๋ผ๋””์•ˆ์œผ๋กœ ๊ณ„์‚ฐ๋ฉ๋‹ˆ๋‹ค.

๋„ ๋‹จ์œ„ ๊ฐ๋„์˜ ์‚ฌ์ธ ๊ฐ’์„ ๊ตฌํ•˜๋ ค๋ฉด RADIANS ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=SIN(PI()/2)๋Š” PI/2 ๋ผ๋””์•ˆ์˜ ์‚ฌ์ธ๊ฐ’์ธ 1์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=SIN(RADIANS(30))์€ 30๋„์˜ ์‚ฌ์ธ ๊ฐ’์ธ 0.5๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

SINH

์ˆซ์ž์˜ ์Œ๊ณก์„  ์‚ฌ์ธ์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

SINH(Number)

Number์— ๋Œ€ํ•œ ์Œ๊ณก ์‚ฌ์ธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=SINH(0)๋Š” 0์˜ ์Œ๊ณก ์‚ฌ์ธ ๊ฐ’์ธ 0์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

SQRT

์ˆซ์ž์— ๋Œ€ํ•œ ์–‘์˜ ์ œ๊ณฑ๊ทผ์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

SQRT(Number)

์ฃผ์–ด์ง„ Number์˜ ์–‘์ˆ˜ ์ œ๊ณฑ๊ทผ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

์ˆ˜๋Š” ์–‘์ˆ˜์—ฌ์•ผ๋งŒ ํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

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

=SQRT(-16)๋Š” ๋ถˆ๋Šฅ์กฐ๊ฑด ์˜ค๋ฅ˜๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

SQRTPI

(PI x ์ˆซ์ž)์˜ ์ œ๊ณฑ๊ทผ์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

SQRTPI(Number)

์–‘์ˆ˜ ์ œ๊ณฑ๊ทผ ๊ฐ’์„(ํŒŒ์ด(PI)์˜ ์ •์ˆ˜๋ฐฐ) ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

์ด๊ฒƒ์€ SQRT(PI()*Number) ์ˆ˜์‹์„ ์ง์ ‘ ์ž…๋ ฅํ•˜๋Š” ๊ฒƒ๊ณผ ๊ฐ™์€ ์—ฐ์‚ฐ์„ ์ˆ˜ํ–‰ํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=SQRTPI(2)๋Š” 2PI์˜ ์ œ๊ณฑ๊ทผ ๊ฐ’์ธ ์•ฝ 2.506628์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

SUBTOTAL

๋ถ€๋ถ„ํ•ฉ์„ ๊ณ„์‚ฐํ•ฉ๋‹ˆ๋‹ค. ๋ฒ”์œ„์— ์ด๋ฏธ ํฌํ•จ๋œ ๋ถ€๋ถ„ํ•ฉ์€ ์ถ”๊ฐ€ ๊ณ„์‚ฐ์— ์‚ฌ์šฉ๋˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค. ํ•„ํ„ฐ๋ง๋œ ๋ ˆ์ฝ”๋“œ๋งŒ ๊ณ ๋ คํ•˜๋ ค๋ฉด ์ด ํ•จ์ˆ˜์™€ ํ•จ๊ป˜ ์ž๋™ ํ•„ํ„ฐ๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

SUBTOTAL(ํ•จ์ˆ˜; ๋ฒ”์œ„)

ํ•จ์ˆ˜๋Š” ๋‹ค์Œ ํ•จ์ˆ˜ ์ค‘ ํ•˜๋‚˜๋ฅผ ๋‚˜ํƒ€๋‚ด๋Š” ๋ฒˆํ˜ธ์ž…๋‹ˆ๋‹ค.

ํ•จ์ˆ˜ ์ƒ‰์ธ

(includes hidden values)

Function index

(ignores hidden values)

ํ•จ์ˆ˜

1

101

AVERAGE

2

102

COUNT

3

103

COUNTA

4

104

์ตœ๋Œ€๊ฐ’

5

105

์ตœ์†Œ๊ฐ’

6

106

PRODUCT

7

107

STDEV

8

108

STDEVP

9

109

SUM

10

110

VAR

11

111

VARP


Use numbers 1-11 to include manually hidden rows or 101-111 to exclude them; filtered-out cells are always excluded.

์˜์—ญ๋Š” ์…€์ด ํฌํ•จ๋œ ๋ฒ”์œ„์ž…๋‹ˆ๋‹ค.

์˜ˆ

You have a table in the cell range A1:B6 containing a bill of material for 10 students. Row 2 (Pen) is manually hidden. You want to see the sum of the figures that are displayed; that is, just the subtotal for the filtered rows. In this case the correct formula would be:

A

B

1

ITEM

QUANTITY

2

Pen

10

3

Pencil

10

4

Notebook

10

5

Rubber

10

6

Sharpener

10


=SUBTOTAL(9;B2:B6) returns 50.

=SUBTOTAL(109;B2:B6) returns 40.

SUM

์…€ ๋ฒ”์œ„์˜ ๋ชจ๋“  ์ˆซ์ž๋ฅผ ๋”ํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

SUM(์ˆ˜1; ์ˆ˜2; ...; ์ˆ˜30)

์ฃผ์–ด์ง„ ์ˆ˜1 ๋ถ€ํ„ฐ ์ˆ˜30๊นŒ์ง€ ์ตœ๋Œ€ 30๊ฐœ ์ˆ˜์˜ ํ•ฉ์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

2, 3 , 4๋ฅผ ๊ฐ๊ฐ ์ˆ˜1, ์ˆ˜2, ์ˆ˜3 ์ˆœ์œผ๋กœ ์ž…๋ ฅํ•œ๋‹ค๋ฉด ๊ฒฐ๊ณผ๊ฐ’์œผ๋กœ๋Š” 9๊ฐ€ ๋ฐ˜ํ™˜๋  ๊ฒƒ ์ž…๋‹ˆ๋‹ค.

=SUM(A1;A3;B5)์€ ์ฃผ์–ด์ง„ ์„ธ ์…€์˜ ๊ฐ’์„ ํ•ฉ์‚ฐํ•ฉ๋‹ˆ๋‹ค. =SUM (A1:E10)๋Š” A1๋ถ€ํ„ฐ E10 ์…€๊นŒ์ง€์˜ ๋ฒ”์œ„ ์•ˆ์— ์žˆ๋Š” ๋ชจ๋“  ์…€์˜ ๊ฐ’์„ ํ•ฉ์‚ฐํ•ฉ๋‹ˆ๋‹ค.

AND๋กœ ์—ฐ๊ฒฐ๋œ ์กฐ๊ฑด์„ ๋‹ค์Œ ๋ฐฉ๋ฒ•์œผ๋กœ SUM() ํ•จ์ˆ˜์™€ ํ•จ๊ป˜ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

์˜ˆ๋ฅผ ๋“ค์–ด ์ฒญ๊ตฌ์„œ์˜ ์ •๋ณด๋ฅผ ์ž…๋ ฅํ•œ๋‹ค๊ณ  ๊ฐ€์ •ํ•ฉ๋‹ˆ๋‹ค. A ์—ด์— ์ฒญ๊ตฌ์„œ์˜ ๋‚ ์งœ ์ •๋ณด๋ฅผ ์ €์žฅํ•˜๊ณ , B ์—ด์—๋Š” ์ฒญ๊ตฌ ๋‚ด์—ญ์„ ์ €์žฅํ•œ๋‹ค๊ณ  ๊ฐ€์ •ํ•ฉ๋‹ˆ๋‹ค. ์ด๋•Œ ํŠน์ •ํ•œ ๋‹ฌ(2008๋…„ 1์›”์˜ ๊ฒฝ์šฐ >=2008-01-01 ์—์„œ <2008-02-01๋กœ ์ •์˜๋  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค)์˜ ์†Œ๊ณ„๋ฅผ ๊ตฌํ•˜๋Š” ์ˆ˜์‹์€ ์•„๋ž˜์™€ ๊ฐ™์ด ์ง€์ •ํ•  ์ˆ˜ ์žˆ์„ ๊ฒƒ์ž…๋‹ˆ๋‹ค. ๋จผ์ € ๊ตฌํ•˜๊ณ  ์‹ถ์€ ๋ฒ”์œ„๊ฐ€ ์‹œ์ž‘ํ•˜๋Š” ๋‚ ์งœ๋ฅผ C1 ์…€์— 2008-01-01๊ณผ ๊ฐ™์ด ์ž…๋ ฅํ•˜๊ณ  C2 ์…€์—๋Š” ๋ฒ”์œ„๊ฐ€ ๋๋‚˜๋Š” ๋‹ค์Œ ๋‚ ์งœ๋ฅผ 2008-02-01๊ณผ ๊ฐ™์ด ์ž…๋ ฅํ•ฉ๋‹ˆ๋‹ค.

๋‹ค์Œ ์ˆ˜์‹์„ ๋ฐฐ์—ด ์ˆ˜์‹์œผ๋กœ ์ž…๋ ฅํ•ฉ๋‹ˆ๋‹ค.

=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)

์ด ์ˆ˜์‹์„ ๋ฐฐ์—ด ์ˆ˜์‹์œผ๋กœ ์ž…๋ ฅํ•˜๋ ค๋ฉด ๋‹จ์ˆœํžˆ Enter ํ‚ค๋ฅผ ๋ˆ„๋ฅด๋Š” ๋Œ€์‹  ๋ฐ˜๋“œ์‹œ Shift + + Enter ํ‚ค๋ฅผ ๋ˆŒ๋Ÿฌ ์ˆ˜์‹์„ ๋‹ซ์•„์•ผ ํ•ฉ๋‹ˆ๋‹ค. ์ด๋ ‡๊ฒŒ ํ•˜๋ฉด ์ˆ˜์‹ ํ‘œ์‹œ์ค„์— ์ˆ˜์‹์ด ์ค‘๊ด„ํ˜ธ๋กœ ๋ฌถ์—ฌ ํ‘œ์‹œ๋ฉ๋‹ˆ๋‹ค.

{=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)}

์ด ์ˆ˜์‹์€ ์กฐ๊ฑด์‹ ๋‘๊ฐœ์™€ B์—ด์— ํ•ด๋‹นํ•˜๋Š” ์…€์˜ ๊ฐ’์˜ ๊ณฑ์„ ํ•ฉ์‚ฐํ•˜๋Š” ํ˜•ํƒœ์ธ๋ฐ, ์ด๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์ด ์ดํ•ดํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ๋งŒ์ผ A์—ด์˜ ๋‚ ์งœ๊ฐ€ ์›ํ•˜๋Š” ๋ฒ”์œ„ ์•ˆ์— ๋“ค์–ด ์žˆ๋‹ค๋ฉด ์ด ๊ฐ’์€ ๋‘ ์กฐ๊ฑด์‹์„ ๋ชจ๋‘ ๋งŒ์กฑํ•˜๊ธฐ ๋•Œ๋ฌธ์— ๊ฒฐ๊ณผ๊ฐ’์œผ๋กœ ๊ฐ๊ฐ 1์„ ๋‚ด๋†“์„ ๊ฒƒ์ž…๋‹ˆ๋‹ค. ์ด๋•Œ ์ˆ˜์‹์€ 1*1*B์—ด์˜ ๊ฐ’์ด ๋˜๋ฏ€๋กœ B์—ด์— ํ•ด๋‹นํ•˜๋Š” ์…€์€ ํ•ฉ์‚ฐ ํ•จ์ˆ˜ SUM์— ์˜ํ•ด ๋”ํ•ด์ง‘๋‹ˆ๋‹ค. ๋งŒ์ผ ๋‚ ์งœ๊ฐ€ ๋ฒ”์œ„๋ฅผ ๋ฒ—์–ด๋‚œ๋‹ค๋ฉด ๋‘˜์ค‘ ํ•˜๋‚˜์˜ ์กฐ๊ฑด์‹์€ 0์˜ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•˜๋ฏ€๋กœ ๊ณฑ์…ˆ์‹์˜ ๊ฐ’์€ 0์ด ๋˜์–ด์„œ ํ•ฉ์‚ฐ๋˜๋Š” ๊ฐ’์— ์•„๋ฌด ๊ธฐ์—ฌ๋ฅผ ํ•˜์ง€ ์•Š๊ฒŒ ๋ฉ๋‹ˆ๋‹ค. ๋”ฐ๋ผ์„œ ์ „์ฒด ์ˆ˜์‹์˜ ๊ฒฐ๊ณผ๊ฐ’์€ ์›ํ•˜๋Š” ๋ฒ”์œ„ ์•ˆ์— ์žˆ๋Š” B์—ด์˜ ์…€ ๊ฐ’์„ ํ•ฉ์‚ฐํ•˜์—ฌ ์˜๋„ํ•œ ๊ณ„์‚ฐ์„ ์ˆ˜ํ–‰ํ•˜๊ฒŒ ๋ฉ๋‹ˆ๋‹ค.

SUMIF

์ฃผ์–ด์ง„ ๊ธฐ์ค€์— ์˜ํ•ด ์ง€์ •๋œ ์…€์„ ์ถ”๊ฐ€ํ•ฉ๋‹ˆ๋‹ค. ์ด ํ•จ์ˆ˜๋Š” ํŠน์ • ๊ฐ’์„ ๊ฒ€์ƒ‰ํ•  ๋•Œ ๋ฒ”์œ„๋ฅผ ํƒ์ƒ‰ํ•˜๋Š” ๋ฐ ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค.

๊ฒ€์ƒ‰์€ ์ •๊ทœ์‹์„ ์ง€์›ํ•ฉ๋‹ˆ๋‹ค. ์˜ˆ๋ฅผ ๋“ค์–ด, "all" ๋‹ค์Œ์— ์•„๋ฌด ๊ธ€์ž๋‚˜ ๋‚˜์˜ค๋Š” ๋‹จ์–ด์˜ ์ฒซ ๋ฒˆ์งธ ์œ„์น˜๋ฅผ ์ฐพ์œผ๋ ค๋ฉด "all.*"์„ ์ž…๋ ฅํ•˜๋ฉด ๋ฉ๋‹ˆ๋‹ค. ์ฐพ์œผ๋ ค๋Š” ํ…์ŠคํŠธ๊ฐ€ ์ •๊ทœ์‹์ธ ๊ฒฝ์šฐ์—๋Š” ๋ชจ๋“  ๋ฌธ์ž ์•ž์— \ ๋ฌธ์ž๋ฅผ ๋ถ™์ด๋ฉด ๋ฉ๋‹ˆ๋‹ค. ์ •๊ทœ์‹์˜ ์ž๋™ ํ‰๊ฐ€๋Š” - LibreOffice Calc - ๊ณ„์‚ฐ์—์„œ ์ผœ๊ฑฐ๋‚˜ ๋Œ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

SUMIF(๋ฒ”์œ„; ์กฐ๊ฑด; ํ•ฉ์‚ฐ๋ฒ”์œ„)

์˜์—ญ๋Š” ๊ธฐ์ค€์ด ์ ์šฉ๋˜๋Š” ์˜์—ญ์ž…๋‹ˆ๋‹ค.

Criteria๋Š” ๊ฒ€์ƒ‰ ๊ธฐ์ค€์ด ์ง€์ •๋˜์–ด ์žˆ๋Š” ์…€ ๋˜๋Š” ๊ฒ€์ƒ‰ ๊ธฐ์ค€ ์ž์ฒด์ž…๋‹ˆ๋‹ค. ๊ธฐ์ค€์„ ์ˆ˜์‹์œผ๋กœ ์ž‘์„ฑํ•œ ๊ฒฝ์šฐ์—๋Š” ํฐ ๋”ฐ์˜ดํ‘œ๋กœ ๋ฌถ์–ด์•ผ ํ•ฉ๋‹ˆ๋‹ค.

SumRange๋Š” ๋”ํ•ด์งˆ ๊ฐ’์˜ ๋ฒ”์œ„๋ฅผ ๋งํ•ฉ๋‹ˆ๋‹ค. ๋งŒ์ผ ์ด ๋งค๊ฐœ ๋ณ€์ˆ˜๊ฐ€ ์ž…๋ ฅ๋˜์ง€ ์•Š์œผ๋ฉด ๊ฐ’์„ ๋”ํ•ด์ง„ ๋ฒ”์œ„ ์•ˆ์—์„œ ์ฐพ์•„๋ƒ…๋‹ˆ๋‹ค.

์ฐธ๊ณ  ์•„์ด์ฝ˜

SUMIF ํ•จ์ˆ˜๋Š” ๊ธฐ์ค€ ๋งค๊ฐœ ๋ณ€์ˆ˜ ์•ˆ์—์„œ๋‚˜ ์„ ํƒ์  SumRange ๋งค๊ฐœ ๋ณ€์ˆ˜๊ฐ€ ์ฃผ์–ด์ง€์ง€ ์•Š์•˜์„ ๊ฒฝ์šฐ์—๋งŒ ์ฐธ์กฐ ์—ฐ๊ฒฐ ์—ฐ์‚ฐ์ž(~)๋ฅผ ์ง€์›ํ•ฉ๋‹ˆ๋‹ค.


์˜ˆ

์Œ์ˆ˜๋งŒ ๋”ํ•˜๋ ค๋ฉด =SUMIF(A1:A10;"<0")๋ฅผ ์ž…๋ ฅํ•˜์‹ญ์‹œ์˜ค.

=SUMIF(A1:A10;">0";B1:10)๋Š” B1:B10 ๋ฒ”์œ„์—์„œ A1:A10์˜ ๊ฐ’์ด 0๋ณด๋‹ค ํด ๋•Œ ํ•ด๋‹น B์—ด์˜ ์…€์„ ๋”ํ•ฉ๋‹ˆ๋‹ค.

SUMIF()์— ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋Š” ๊ตฌ๋ฌธ ์˜ˆ๋ฅผ ๋ณด๋ ค๋ฉด COUNTIF()๋ฅผ ์ฐธ์กฐํ•˜์‹ญ์‹œ์˜ค.

SUMSQ

์ˆซ์ž์˜ ์ œ๊ณฑํ•ฉ์„ ๊ณ„์‚ฐํ•˜๋ ค๋ฉด(์ธ์ˆ˜์˜ ์ œ๊ณฑ ํ•ฉ๊ณ„) ์ด๋Ÿฌํ•œ ๊ฐ’์„ ํ…์ŠคํŠธ ํ•„๋“œ์— ์ž…๋ ฅํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

SUMSQ(์ˆ˜1; ์ˆ˜2; ... ; ์ˆ˜30)

์ˆ˜1 ๋ถ€ํ„ฐ 30๊นŒ์ง€๋ฅผ ์ œ๊ณฑํ•œ ํ›„ ๊ทธ ํ•ฉ์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค. ์ตœ๋Œ€ 30๊ฐœ๊นŒ์ง€ ์ž…๋ ฅํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

์˜ˆ

์˜ˆ๋ฅผ ๋“ค์–ด 2; 3, 4๋ฅผ ๊ฐ๊ฐ ์ˆ˜1, ์ˆ˜2, ์ˆ˜3์˜ ์œ„์น˜์— ์ž…๋ ฅํ•œ๋‹ค๋ฉด ๊ฒฐ๊ณผ๊ฐ’์œผ๋กœ๋Š” 29๊ฐ€ ๋ฐ˜ํ™˜๋  ๊ฒƒ์ž…๋‹ˆ๋‹ค.

TAN

ํ•ด๋‹น ๊ฐ๋„(๋ผ๋””์•ˆ)์— ๋Œ€ํ•œ ํƒ„์  ํŠธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

TAN(Number)

์ฃผ์–ด์ง„ Number์˜ ํƒ„์  ํŠธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค. ๊ฐ๋„๋Š” ๋ผ๋””์•ˆ์œผ๋กœ ๊ณ„์‚ฐ๋ฉ๋‹ˆ๋‹ค.

๋„ ๋‹จ์œ„ ๊ฐ๋„์˜ ํƒ„์  ํŠธ ๊ฐ’์„ ๊ตฌํ•˜๋ ค๋ฉด RADIANS ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=TAN(PI()/4) ๋Š” PI/4 ๋ผ๋””์•ˆ์˜ ํƒ„์  ํŠธ ๊ฐ’์ธ 1์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=TAN(RADIANS(45))๋Š” 45๋„์˜ ํƒ„์  ํŠธ ๊ฐ’์ธ 1์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

TANH

์ˆซ์ž์˜ ์Œ๊ณก์„  ํƒ„์  ํŠธ๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

TANH(Number)

Number์— ๋Œ€ํ•œ ์Œ๊ณก ํƒ„์  ํŠธ ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=TANH(0)๋Š” 0์˜ ์Œ๊ณก ํƒ„์  ํŠธ ๊ฐ’์ธ 0์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

TRUNC

์ˆซ์ž์˜ ์†Œ์ˆ˜์  ์ดํ•˜ ์ž๋ฆฟ์ˆ˜๋ฅผ ์ž˜๋ผ๋ƒ…๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

TRUNC(์ˆ˜; ์ž๋ฆฌNumber)

์ฃผ์–ด์ง„ Number์—์„œ Count ๋งŒํผ์˜ ์ž๋ฆฟ์ˆ˜ ์ดํ•˜์˜ ์ˆซ์ž๋Š” ์ž˜๋ผ๋ƒ…๋‹ˆ๋‹ค. ์ˆ˜๋ฅผ ์˜ฌ๋ฆฌ๊ฑฐ๋‚˜ ๋‚ด๋ฆฌ์ง€ ์•Š๊ณ , ๋„˜์น˜๋Š” ์ˆซ์ž๋Š” ๋ถ€ํ˜ธ์— ๊ด€๊ณ„์—†์ด ์ž˜๋ผ๋‚ด๊ธฐ๋งŒ ํ•ฉ๋‹ˆ๋‹ค.

TRUNC(์ˆ˜; 0)๋Š” ์–‘์ˆ˜ ๋ฒ”์œ„์—์„œ๋Š” INT(Number)๊ณผ ๋˜‘๊ฐ™์€ ๊ฒฐ๊ณผ๋ฅผ ๋‚ด ๋†“์ง€๋งŒ ์Œ์ˆ˜ ๋ฒ”์œ„์—์„œ๋Š” ์˜ฌ๋ฆผ์œผ๋กœ ์—ฐ์‚ฐ์ฒ˜๋ฆฌ๋ฉ๋‹ˆ๋‹ค.

๊ฒฝ๊ณ  ์•„์ด์ฝ˜

๊ฒฐ๊ณผ์—์„œ ํ‘œ์‹œ๋˜๋Š” ์†Œ์ˆ˜์  ์ดํ•˜ ์ž๋ฆฌ ์ˆ˜๋Š” - LibreOffice Calc - ๊ณ„์‚ฐ์—์„œ ์ง€์ •๋ฉ๋‹ˆ๋‹ค.


์˜ˆ

=TRUNC(1.239;2)๋Š” 1.23๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. 9๋Š” ๋ฒ„๋ฆฝ๋‹ˆ๋‹ค.

=TRUNC(-1.234999;3)-1.234๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ๋ชจ๋“  9๋Š” ๋ฒ„๋ ค์ง‘๋‹ˆ๋‹ค.