æ°åŠé¢æ°
ãã®ã«ããŽãªã¯ã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.
[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(æ°å€)
æ° ã¯ã絶察å€ãæ±ããæ°ã§ãã 絶察å€ãšã¯ã+/- 笊å·ãªãã®å€ã§ãã
äŸ
=ABS(-56) ã¯ã56 ãè¿ããŸãã
=ABS(12) ã¯ã12 ãè¿ããŸãã
=ABS(0) ã¯ã0 ãè¿ããŸãã
ACOS
æ°å€ã®ã¢ãŒã¯ã³ãµã€ã³ãè¿ããŸãã
æ§æ
ACOS(æ°å€)
ãã®é¢æ°ã¯ãæ°å€ ã®ã¢ãŒã¯ã³ãµã€ã³ãè¿ããŸããããã¯ãã³ãµã€ã³ã æ°å€ ã®ã©ãžã¢ã³åäœã®è§åºŠã§ãã0 以äžã§ PI ããå°ããè§åºŠãè¿ãããŸãã
è§åºŠã床æ°ã§è¿ãã«ã¯ãDEGREES 颿°ã䜿çšããŸãã
äŸ
=ACOS(-1) ã¯ã3.14159265358979 (PI ã©ãžã¢ã³) ãè¿ããŸãã
=DEGREES(ACOS(0.5)) ã¯ã60 ãè¿ããŸãã60 床ã®ã³ãµã€ã³ã¯ 0.5 ã§ãã
ACOSH
éåæ²ç·ã³ãµã€ã³
æ§æ
ACOSH(æ°å€)
ãã®é¢æ°ã¯ãæ°å€ ã®åæ²ç·éã³ãµã€ã³ãè¿ããŸããããã¯ãåæ²ç·ã³ãµã€ã³ã æ°å€ ã®æ°ã§ãã
1 以äžã®æ°åãå ¥åããŠãã ããã
äŸ
=ACOSH(1) ã¯ã0 ãè¿ããŸãã
=ACOSH(COSH(4)) ã¯ã4 ãè¿ããŸãã
ACOT
æ°å€ã®éã³ã¿ã³ãžã§ã³ã (ã¢ãŒã¯ã³ã¿ã³ãžã§ã³ã) ãè¿ããŸãã
æ§æ
ACOT(æ°å€)
ãã®é¢æ°ã¯ãæ°å€ ã®ã¢ãŒã¯ã³ã¿ã³ãžã§ã³ããè¿ããŸããããã¯ãã³ã¿ã³ãžã§ã³ãã æ°å€ ã®ã©ãžã¢ã³åäœã®è§åºŠã§ãã0 以äžã§ PI ããå°ããè§åºŠãè¿ãããŸãã
è§åºŠã床æ°ã§è¿ãã«ã¯ãDEGREES 颿°ã䜿çšããŸãã
äŸ
=ACOT(1) ã¯ã0.785398163397448 (PI/4 ã©ãžã¢ã³) ãè¿ããŸãã
=DEGREES(ACOT(1)) ã¯ã45 ãè¿ããŸãã45 床ã®ã¿ã³ãžã§ã³ã㯠1 ã§ãã
ACOTH
æ°å€ ã®åæ²ç·éã³ã¿ã³ãžã§ã³ããè¿ããŸãã
æ§æ
ACOTH(æ°å€)
ãã®é¢æ°ã¯ãæ°å€ ã®åæ²ç·éã³ã¿ã³ãžã§ã³ããè¿ããŸããããã¯ãåæ²ç·ã³ã¿ã³ãžã§ã³ãããã®æ°å€ãšãªãå€ã§ãã
æ°åã -1 以äžã1 以äžã®å Žåã¯ãšã©ãŒã«ãªããŸãã
äŸ
=ACOTH(1.1) ã¯ã1.1 ã®åæ²ç·éã³ã¿ã³ãžã§ã³ã (çŽ 1.52226) ãè¿ããŸãã
ASIN
æ°å€ã®ã¢ãŒã¯ãµã€ã³ãè¿ããŸãã
æ§æ
ASIN(æ°å€)
ãã®é¢æ°ã¯ãæ°å€ ã®ã¢ãŒã¯ãµã€ã³ãè¿ããŸããããã¯ããµã€ã³ã æ°å€ ã®ã©ãžã¢ã³åäœã®è§åºŠã§ãã-PI/2 以äžã§ +PI/2 ããå°ããè§åºŠãè¿ãããŸãã
è§åºŠã床æ°ã§è¿ãã«ã¯ãDEGREES 颿°ã䜿çšããŸãã
äŸ
=ASIN(0) ã¯ã0 ãè¿ããŸãã
=ASIN(1) ã¯ã1.5707963267949 (PI/2 ã©ãžã¢ã³) ãè¿ããŸãã
=DEGREES(ASIN(0.5)) ã¯ã30 ãè¿ããŸãã30 床ã®ãµã€ã³ã¯ 0.5 ã§ãã
ASINH
æ°å€ã®åæ²ç·éãµã€ã³ãè¿ããŸãã
æ§æ
ASINH(æ°å€)
ãã®é¢æ°ã¯ãæ°å€ ã®åæ²ç·éãµã€ã³ãè¿ããŸããããã¯ãåæ²ç·ãµã€ã³ã æ°å€ ã®æ°ã§ãã
äŸ
ASINH(-90) ã¯ãçŽ -5.1929877 ãè¿ããŸãã
=ASINH(SINH(4)) ã¯ã4 ãè¿ããŸãã
ATAN
æ°å€ã®ã¢ãŒã¯ã¿ã³ãžã§ã³ããè¿ããŸãã
æ§æ
ATAN(æ°å€)
ãã®é¢æ°ã¯ãæ°å€ ã®ã¢ãŒã¯ã¿ã³ãžã§ã³ããè¿ããŸããããã¯ãã¿ã³ãžã§ã³ãã æ°å€ ã®ã©ãžã¢ã³åäœã®è§åºŠã§ãã-PI/2 以äžã§ PI/2 ããå°ããè§åºŠãè¿ãããŸãã
è§åºŠã床æ°ã§è¿ãã«ã¯ãDEGREES 颿°ã䜿çšããŸãã
äŸ
=ATAN(1) ã¯ã0.785398163397448 (PI/4 ã©ãžã¢ã³) ãè¿ããŸãã
=DEGREES(ATAN(1)) ã¯ã45 ãè¿ããŸãã45 床ã®ã¿ã³ãžã§ã³ã㯠1 ã§ãã
ATAN2
æå®ã® x ããã³ y 座æšã®ã¢ãŒã¯ã¿ã³ãžã§ã³ããè¿ããŸãã
æ§æ
ATAN2(æ°å€ X; æ°å€ Y)
æ°å€ X ã¯ãx 座æšã®å€ã§ãã
æ°å€ Y ã¯ãïœ åº§æšã®å€ã§ãã
ATAN2 ã¯ãã¢ãŒã¯ã¿ã³ãžã§ã³ããè¿ããŸããããã¯ãX è»žãšæ°å€ Xãæ°å€ Y ã®ç¹ãšåç¹ãéãç·ã®éã®ã©ãžã¢ã³åäœã®è§åºŠã§ãã-PI 以äžã§ PI ããå°ããè§åºŠãè¿ãããŸãã
è§åºŠã床æ°ã§è¿ãã«ã¯ãDEGREES 颿°ã䜿çšããŸãã
äŸ
=ATAN2(20;20) ã¯ã0.785398163397448 (PI/4 ã©ãžã¢ã³) ãè¿ããŸãã
=DEGREES(ATAN2(12.3;12.3)) ã¯ã45 ãè¿ããŸãã45 床ã®ã¿ã³ãžã§ã³ã㯠1 ã§ãã
ATANH
æ°å€ã®åæ²ç·éã¿ã³ãžã§ã³ããè¿ããŸãã
æ§æ
ATANH(æ°å€)
ãã®é¢æ°ã¯ãæ°å€ ã®åæ²ç·éã¿ã³ãžã§ã³ããè¿ããŸããããã¯ãåæ²ç·ã¿ã³ãžã§ã³ãã æ°å€ ã®æ°ã§ãã
æ°åã¯ã-1 ãã倧ããã1 æªæºãšããæ¡ä»¶ã«åŸãå¿ èŠããããŸãã
äŸ
=ATANH(0) ã¯ã0 ãè¿ããŸãã
CEILING
æ°å€ãæãåºæºå€ã®åæ°ã®ãã¡ã倧ããæ¹ã®å€ãè¿ããŸãã
æ§æ
CEILING(æ°å€; åºæºå€; ã¢ãŒã)
æ°å€ ã¯ãåãäžãã®å¯Ÿè±¡ãšãªãæ°å€ã§ãã
åºæºå€ ã¯ãåãäžããããå€ããã®åæ°ãšãªãå€ã§ãã
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)
æ°å€ ã¯ãåãäžãã®å¯Ÿè±¡ãšãªãæ°å€ã§ãã
åºæºå€ ã¯ãåãäžããããå€ããã®åæ°ãšãªãå€ã§ãã
äŸ
=CEILING.PRECISE(-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; ã«ãŠã³ã 2)
ã«ãŠã³ã 1 ã¯ãã»ããå ã®é ç®ã®æ°ã§ãã
ã«ãŠã³ã 2 ã¯ãã»ããããéžæããé ç®ã®æ°ã§ãã
COMBIN ã¯ããããã®é ç®ãéžæããæ¹æ³ã®æ°ãè¿ããŸãã ããšãã°ã3 ã€ã®é ç® AãB ããã³ C ãã»ããã®å Žåã3 ã€ã®æ¹æ³ãã€ãŸããABãACãããã³ BC ã®ãã¡ 2 ã€ã®é ç®ãéžæããŸãã
COMBIN ã¯ãæ°åŒ Count1!/(Count2!*(Count1-Count2)!) ãå®è¡ããŸãã
äŸ
=COMBIN(3;2) ã¯ã3 ãè¿ããŸãã
COMBINA
ç¹°ãè¿ããå«ãé ç®ã®ãµãã»ããã®çµã¿åããã®æ°ãè¿ããŸãã
æ§æ
COMBINA(ã«ãŠã³ã 1; ã«ãŠã³ã 2)
ã«ãŠã³ã 1 ã¯ãã»ããå ã®é ç®ã®æ°ã§ãã
ã«ãŠã³ã 2 ã¯ãã»ããããéžæããé ç®ã®æ°ã§ãã
COMBINA ã¯ãããã®é ç®ãéžæããæ¹æ³ã®æ°ãè¿ããŸããéžæé åºã¯ç¡é¢ä¿ã§ãéè€ãèš±ããŸãã ããšãã°ã3 ã€ã®é ç® AãB ããã³ C ãã»ããã®å Žåã2 ã€ã®é ç®ãéžæããã«ã¯ãAAãABãACãBBãCC ã® 6 ã€ã®æ¹æ³ããããŸãã
COMBIN ã¯ãæ°åŒ Count1!/(Count2!*(Count1-Count2)!) ãå®è¡ããŸãã
äŸ
=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(æ°å€)
æ°å€ ã®åæ²ç·ã³ã¿ã³ãžã§ã³ããè¿ããŸãã
äŸ
=COTH(1) ã¯ã1 ã®åæ²ç·ã³ã¿ã³ãžã§ã³ã (çŽ 1.3130) ãè¿ããŸãã
CSC
(ã©ãžã¢ã³è¡šèšã§)äžããããè§åºŠã®ã³ã»ã«ã³ããè¿ããŸããããè§åºŠã®ã³ã»ã«ã³ãã¯1ããã®è§åºŠã®ãµã€ã³ã§å²ã£ããã®ã«çããã§ã
æ§æ
CSC(æ°å€)
æ°å€ã®(äžè§é¢æ°ã®)ã³ã»ã«ã³ããè¿ããŸããè§åºŠã¯ã©ãžã¢ã³ã§è¡šãããŸãã
床æ°ã§è¡šãããè§åºŠã®ã³ã»ã«ã³ããè¿ãã«ã¯ãRADIANS 颿°ã䜿çšããŠãã ããã
äŸ
=CSC(PI()/4) ã¯ãPI/4ã©ãžã¢ã³ã®æ£åŒŠã®éæ°ã§ããçŽ 1.4142135624ãè¿ããŸãã
=CSC(RADIANS(30))30床ã®ã³ã»ã«ã³ãã®ïŒãè¿ããŸãã
CSCH
ããæ°å€ã®åæ²ç·ã³ã»ã«ã³ããè¿ããŸãã
æ§æ
CSCH(æ°å€)
Number ã®åæ²ç·ã³ã»ã«ã³ããè¿ããŸãã
äŸ
=CSCH(1)ã¯è¿äŒŒçã«0.8509181282(1ã®åæ²ç·ã³ã»ã«ã³ã)ãè¿ããŸãã
DEGREES
ã©ãžã¢ã³ã床ã«å€æããŸãã
æ§æ
DEGREES(æ°å€)
Number ã¯ã床æ°ã«å€æãããã©ãžã¢ã³åäœã®è§åºŠã§ãã
äŸ
=DEGREES(PI()) ã¯ã180 床ãè¿ããŸãã
EUROCONVERT
ãšãŒãããååœã®å€ãé貚ãšãŠãŒãã®éã§æç®ãè¡ããŸãã
æ§æ
EUROCONVERT(å€; "å é貚"; "倿é貚", å®å šãªç²ŸåºŠ, äžè§åœ¢ç²ŸåºŠ)
å€ ã¯ã倿ãããé貚ã®é¡ã§ãã
å é貚 ãš å€æé貚 ã¯ãããããæç®å ãšæç®å ã®é貚åäœã§ãããããã¯ããEURãã®ããã«ãé貚ã®å ¬åŒç¥ç§°ã®ããã¹ããšããŸãããŠãŒãã§ç€ºãããã¬ãŒãã¯ã欧å·å§å¡äŒã«ãã£ãŠèšå®ãããŸããã
å®å šãªç²ŸåºŠ(ãªãã·ã§ã³) çç¥ããããFalseã®å Žåãçµæã¯ééã®å°æ°ç¹ä»¥äžãåæšäºå ¥ããŸããTrueãªãã°çµæã®åæšäºå ¥ã¯ããŸããã
äžè§ç²ŸåºŠã¯ãªãã·ã§ã³ã§ããããäžè§ç²ŸåºŠãäžãããã>=3 ãªãã°ãäžè§å€æ(é貚1,EUR,é貚2) ã®äžéçµæã¯ãã®ç²ŸåºŠã«äžžããããŸããããäžè§ç²ŸåºŠãçç¥ããããªããäžéå€ã¯äžžããããŸãããããã«ãé貚ããEURããªãã°ãããããäžè§ç²ŸåºŠãå¿ èŠãã®ããã«äœ¿çšãããEUR ãã EUR ã®å€æãé©çšãããŸãã
äŸ
=EUROCONVERT(100;"ATS";"EUR") ã¯ã100 ãªãŒã¹ããªã¢ã·ãªã³ã°ããŠãŒãã«æç®ããŸãã
=EUROCONVERT(100;"EUR";"DEM") ã¯ã100 ãŠãŒãããã€ããã«ã¯ã«æç®ããŸãã
EVEN
æ£ã®æ°ã次ã®å¶æ°ã«åãäžããè² ã®æ°ã次ã®å¶æ°ã«åãäžããŸãã
æ§æ
EVEN(æ°å€)
ãŒããšã¯éæ¹åã®æ¬¡ã®å¶æ°ã«äžžãã æ°å€ ãè¿ããŸãã
äŸ
=EVEN(2.3) ã¯ã4 ãè¿ããŸãã
=EVEN(2) ã¯ã2 ãè¿ããŸãã
=EVEN(0) ã¯ã0 ãè¿ããŸãã
=EVEN(-0.5) ã¯ã-2 ãè¿ããŸãã
EXP
e ãåºãšããæ°å€ã®ã¹ãä¹ãè¿ããŸãã宿° e ã®å€ã¯çŽ 2.71828182845904 ã§ãã
æ§æ
EXP(æ°å€)
æ°å€ ã¯ãe ãåºãšããã¹ãä¹ã®ææ°ã§ãã
äŸ
=EXP(1) ã¯ãCalc ã®ç²ŸåºŠã®æ°åŠå®æ° eãã€ãŸã 2.71828182845904 ãè¿ããŸãã
FACT
æ°å€ã®éä¹ãè¿ããŸãã
æ§æ
FACT(æ°å€)
1*2*3*4* ... * æ°å€ ãšããŠèšç®ããã æ°å€ ã®éä¹ãNumber! ãè¿ããŸãã
å®çŸ©äžã=FACT(0) 㯠1 ãè¿ããŸãã
è² ã®æ°ã®ä¹æ°ã¯ããç¡å¹ãªåŒæ°ããšã©ãŒãè¿ããŸãã
äŸ
=FACT(3) ã¯ã6 ãè¿ããŸãã
=FACT(0) ã¯ã1 ãè¿ããŸãã
FLOOR
æãè¿ãåºæºå€ã®åæ°ã«åãäžããæ°ãè¿ããŸãã
æ§æ
FLOOR(æ°å€; åºæºå€; ã¢ãŒã)
æ°å€ ã¯ãåãäžããããå€ã§ãã
åºæºå€ ã¯ãåãäžããããå€ããã®åæ°ãšãªãå€ã§ãã
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)
æ°å€ ã¯ãåãäžããããå€ã§ãã
åºæºå€ ã¯ãåãäžããããå€ããã®åæ°ãšãªãå€ã§ãã
äŸ
=FLOOR( -11;-2) ã¯ã-12 ãè¿ããŸãã
GCD
è€æ°ã®æŽæ°ã®æå€§å ¬çŽæ°ãè¿ããŸãã
æå€§å ¬çŽæ°ã¯ãæå®ãããåæŽæ°ãäœããåºãããšãªãå²ãåããæ£ã®æå€§æŽæ°ã§ãã
æ§æ
GCD(æŽæ° 1; æŽæ° 2; ...; æŽæ° 30)
æŽæ° 1 ãã 30 ã¯ãæå€§å ¬çŽæ°ãèšç®ããæé« 30 åã®æŽæ°ã§ãã
äŸ
16ã24ã32 ãå²ãåããæå€§æ°ã¯ 8 ãªã®ã§ã=GCD(16;32;24) 㯠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.
æ§æ
GCD_EXCEL2003(Number(s))
æ°å€ ã¯ãæé« 30 åã®æ°åã®ãªã¹ãã§ãã
äŸ
=GCD_EXCEL2003(5;15;25) returns 5.
INT
æ°å€ãåæšäºå ¥ããŠæŽæ°ã«ããŸãã
æ§æ
INT(æ°å€)
å°æ°ç¹ä»¥äžãåãæšãŠã æ°å€ ãè¿ããŸãã
è² ã®æ°ã¯æ¬¡ã®æŽæ°ã«åãäžããããŸãã
äŸ
=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)
æ°å€ ã¯ãåãäžãã®å¯Ÿè±¡ãšãªãæ°å€ã§ãã
åºæºå€ ã¯ãåãäžããããå€ããã®åæ°ãšãªãå€ã§ãã
äŸ
=CEILING(-11;-2) ã¯ã-10 ãè¿ããŸãã
LCM
è€æ°ã®æŽæ°ã®æå°å ¬åæ°ãè¿ããŸãã
æ§æ
LCM(æŽæ° 1; æŽæ° 2; ...; æŽæ° 30)
æŽæ° 1 ãã 30 ã¯ãæå°å ¬åæ°ãèšç®ããæé« 30 åã®æŽæ°ã§ãã
äŸ
æŽæ° 1ã2ãããã³ 3 ããã¹ãããã¯ã¹ã«æ°å 512ã1024ãããã³ 2000 ãå ¥åãããšãçµæãšã㊠128000 ãè¿ãããŸãã
LCM_EXCEL2003
The result is the lowest common multiple of a list of numbers.
æ§æ
LCM_EXCEL2003(Number(s))
æ°å€ ã¯ãæé« 30 åã®æ°åã®ãªã¹ãã§ãã
äŸ
=LCM_EXCEL2003(5;15;25) returns 75.
LN
æ°å€ã®èªç¶å¯Ÿæ°ã«åºã¥ã宿° e ãè¿ããŸãã 宿° e ã®å€ã¯çŽ 2.71828182845904 ã§ãã
æ§æ
LN(æ°å€)
æ°å€ ã¯ãèªç¶å¯Ÿæ°ãæ±ããå€ã§ãã
äŸ
=LN(3) ã¯ã3 ã®èªç¶å¯Ÿæ° (çŽ 1.0986) ãè¿ããŸãã
=LN(EXP(321)) ã¯ã321 ãè¿ããŸãã
LOG
æå®ã®åºã«å¯Ÿããæ°å€ã®å¯Ÿæ°ãè¿ããŸãã
æ§æ
LOG(æ°å€; åº)
æ°å€ ã¯ã察æ°ãæ±ããå€ã§ãã
åº(ãªãã·ã§ã³) ã¯å¯Ÿæ°èšç®ã®åºã§ããçç¥ããå Žåã¯åºã«10ã䜿çšããŸãã
äŸ
=LOG(10;3) ã¯ã3 ãåºãšãã 10 ã®å¯Ÿæ° (çŽ 2.0959) ãè¿ããŸãã
=LOG(7^4;7) ã¯ã4 ãè¿ããŸãã
LOG10
æ°å€ã® 10 ãåºãšãã察æ°ãè¿ããŸãã
æ§æ
LOG10(æ°å€)
æ°å€ ã® 10 ãåºãšãã察æ°ãè¿ããŸãã
äŸ
=LOG10(5) ã¯ãåºã 10 ã®å Žåã® 5 ã®å¯Ÿæ° (çŽ 0.69897) ãè¿ããŸãã
MOD
ããæŽæ°ãå¥ã®æŽæ°ã§å²ã£ããšãã®äœããè¿ããŸãã
æ§æ
MOD(è¢«é€æ°;逿°)
æŽæ°ã®åŒæ°ã§ã¯ããã®é¢æ°ã¯ Dividend modulo Divisorãã€ãŸã è¢«é€æ° ã 逿° ã§å²ã£ããšãã®äœããè¿ããŸãã
ãã®é¢æ°ã¯ Dividend - Divisor * INT(Dividend/Divisor) ãšããŠå®è¡ãããŸããåŒæ°ãæŽæ°ã§ãªãå Žåããã®æ°åŒã¯çµæãè¿ããŸãã
äŸ
=MOD(22;3) ã¯ã22 ã 3 ã§å²ã£ãäœãã1 ãè¿ããŸãã
=MOD(11.25;2.5) ã¯ã1.25 ãè¿ããŸãã
MROUND
å¥ã®æ°ã®ãã£ãšãè¿ãåæ°ã«åæšäºå ¥ãããæ°ãè¿ããŸãã
æ§æ
MROUND(æ°å€; åæ°)
Multiple ã®ãã£ãšãè¿ãåæ°ã«åæšäºå ¥ããã Number ãè¿ããŸãã
代衚çãªå®è£ 㯠Multiple * ROUND(Number/Multiple) ã§ãã
äŸ
15.5 㯠18 (= 3*6) ãã 15 (= 3*5) ã«è¿ãã®ã§ã=MROUND(15.5;3) 㯠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(æ°å€)
æ°å€ ã¯ãæé« 30 åã®æ°åã®ãªã¹ãã§ãã
äŸ
F11 ãã H11 ã«å€ 2ã3ã4 ãå«ãŸããå Žåã=MULTINOMIAL(F11:H11) 㯠1260 ãè¿ããŸããããã¯ãæ°åŒ =(2+3+4)! / (2!*3!*4!) ã«å¯Ÿå¿ããŸãã
ODD
æãè¿ã奿°ã®æŽæ°ã«åãäžããæ°å€ããã³æãè¿ã奿°ã®æŽæ°ã«åãäžããè² ã®æ°ãè¿ããŸãã
æ§æ
ODD(æ°å€)
ãŒããšã¯éæ¹åã®æ¬¡ã®å¥æ°ã«äžžãã æ°å€ ãè¿ããŸãã
äŸ
=ODD(1.2) ã¯ã3 ãè¿ããŸãã
=ODD(1) ã¯ã1 ãè¿ããŸãã
=ODD(0) ã¯ã1 ãè¿ããŸãã
=ODD(-3.1) ã¯ã5 ãè¿ããŸãã
PI
å°æ°ç¹ä»¥äž 14 æ¡ã®æ°åŠå®æ° PIã3.14159265358979 ãè¿ããŸãã
æ§æ
PI()
äŸ
=PI() ã¯ã3.14159265358979 ãè¿ããŸãã
POWER
ä»ã®æ°ã®ã¹ãä¹ã«ããæ°ãè¿ããŸãã
æ§æ
POWER(åº; ææ°)
åº ã ææ° ã§ã¹ãä¹ããå€ãè¿ããŸãã
ææ°æŒç®å ^ ã䜿çšããŠãåãçµæãåŸãããŸãã
åº^ææ°
äŸ
=POWER(4;3) ã¯ã4 ã 3 ä¹ãã 64 ãè¿ããŸãã
=4^3 ãã4 ã® 3 ä¹ãè¿ããŸãã
PRODUCT
åŒæ°ãšããŠæå®ãããæ°å€ããã¹ãŠä¹ç®ãããã®ç©ãè¿ããŸãã
æ§æ
PRODUCT(æ°å€ 1; æ°å€ 2; ...; æ°å€ 30)
æ°å€1 ãã 30 ã¯ãç©ãèšç®ããæé« 30 åã®åŒæ°ã§ãã
PRODUCT 㯠number1 * number2 * number3 * ... ãè¿ããŸãã
äŸ
=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(æ°å€)
æ°å€ ã¯ãã©ãžã¢ã³ã«å€æãããè§åºŠã§ãã
äŸ
=RADIANS(90) ã¯ãCalc ã®ç²ŸåºŠã® PI/2ã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(Bottom; Top)
æŽæ° äžé 以äžãäžé 以äžã®æŽæ°ã®ä¹±æ°ãè¿ããŸãã
ãã®é¢æ°ã¯ Calc ãåèšç®ããããã³ã«æ°ããä¹±æ°ãäœæããŸããæåã§åŒ·å¶çã«åèšç®ãããã«ã¯ Shift+CommandCtrl+F9 ãæŒããŸãã
絶察ã«åèšç®ãããªãä¹±æ°ãçæããã«ã¯ããã®é¢æ°ãå«ãã»ã«ãã³ããŒãã
ãš ãããŒã¯ãããã ãããŒã¯ãããŠããç¶æ ã§ã ã䜿çšããŸããäŸ
=RANDBETWEEN(20;30) ã¯ã20 ãã 30 ã®éã®æŽæ°ã²ãšã€ãè¿ããŸãã
ROUND
æå®ã®æ¡æ° (å°æ°äœ) ã«æ°å€ãåæšäºå ¥ããŸãã
æ§æ
ROUND(æ°å€; ã«ãŠã³ã)
ã«ãŠã³ã ã®å°æ°äœã«äžžãã æ°å€ ãè¿ããŸããã«ãŠã³ããçç¥ãããŠããå ŽåããŒãã®å Žåã颿°ã¯ãã£ãšãè¿ãæŽæ°ã«åãäžããŸããã«ãŠã³ããè² ã®æ°ã®å Žåã颿°ã¯ãã£ãšãè¿ã 10ã100ã1000 ãªã©ã«åãäžããŸãã
ãã®é¢æ°ã¯ãã£ãšãè¿ãæ°ã«åãäžããŸãã 代ããã«äœ¿çšã§ãã颿°ã«ã€ããŠã¯ã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(æ°å€; ã«ãŠã³ã)
ã«ãŠã³ã ã®å°æ°äœã«ãŒãã«åããŠåãäžãã æ°å€ ãè¿ããŸããã«ãŠã³ããçç¥ãããŠããå ŽåããŒãã®å Žåã颿°ã¯æŽæ°ã«åãäžããããŸããã«ãŠã³ããè² ã®æ°ã®å Žåã颿°ã¯æ¬¡ã® 10ã100ã1000 ãªã©ã«åãäžããããŸãã
ãã®é¢æ°ã¯ãŒãã«åãã£ãŠåæšäºå ¥ããŸãã 代ããã«äœ¿çšã§ãã颿°ã«ã€ããŠã¯ãROUNDUP ãš ROUND ãåç §ããŠãã ããã
äŸ
=ROUNDDOWN(1.234;2) ã¯ã1.23 ãè¿ããŸãã
=ROUNDDOWN(45.67;0) ã¯ã45 ãè¿ããŸãã
=ROUNDDOWN(-45.67) ã¯ã-45 ãè¿ããŸãã
=ROUNDDOWN(987.65;-2) ã¯ã900 ãè¿ããŸãã
ROUNDUP
æ°ããŒãããç¹å®ã®ç²ŸåºŠã«åãäžããŸãã
æ§æ
ROUNDUP(æ°å€; ã«ãŠã³ã)
ã«ãŠã³ã ã®å°æ°äœã«ãŒããšã¯éæ¹åã«åããŠåãäžãã æ°å€ ãè¿ããŸããã«ãŠã³ããçç¥ãããŠããå ŽåããŒãã®å Žåã颿°ã¯æŽæ°ã«åãäžããããŸããã«ãŠã³ããè² ã®æ°ã®å Žåã颿°ã¯æ¬¡ã® 10ã100ã1000 ãªã©ã«åãäžããããŸãã
ãã®é¢æ°ã¯ãŒãããé¢ããããã«åæšäºå ¥ããŸãã 代ããã«äœ¿çšã§ãã颿°ã«ã€ããŠã¯ãROUNDDOWN ãš ROUNDUP ãåç §ããŠãã ããã
äŸ
=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
äžãããã(ã©ãžã¢ã³ã§ã®)è§åºŠã®ã»ã«ã³ããè¿ããŸããããè§åºŠã®ã»ã«ã³ãã¯ã³ãµã€ã³ã®éæ°ã«çããã§ã
æ§æ
SEC(æ°å€)
ã©ãžã¢ã³ã§ã®è§åºŠNumberã®(äžè§é¢æ°ã®)ã»ã«ã³ããè¿ããŸã
床æ°ã§è¡šããããè§åºŠã®ãµã€ã³ãè¿ãã«ã¯ãRADIANS 颿°ã䜿çšããŸãã
äŸ
=SEC(PI()/4ã¯è¿äŒŒçã«1.4142135624(PI/4ã©ãžã¢ã³ã®ã³ãµã€ã³ã®éæ°)ãè¿ããŸãã
=SEC(RADIANS(60))ã¯2(60床ã®ã»ã«ã³ã)ãè¿ããŸãã
SECH
ããæ°å€ã®åæ²ç·ã»ã«ã³ããè¿ããŸãã
æ§æ
SECH(æ°å€)
Number ã®åæ²ç·ã»ã«ã³ããè¿ããŸãã
äŸ
=SECH(0)ã¯1(0ã®åæ²ç·ã»ã«ã³ã)ãè¿ããŸãã
SERIESSUM
ã¹ãçŽæ°ã®æåã®é ãåèšããŸãã
SERIESSUM(x;n;m;ä¿æ°) = ä¿æ°1*x^n + ä¿æ°2*x^(n+m) + ä¿æ°3*x^(n+2m) +...+ ä¿æ°i*x^(n+(i-1)m)
æ§æ
SERIESSUM(X; N; M; ä¿æ°)
X ã¯ãã¹ãçŽæ°ã®å ¥åå€ã§ãã
N ã¯ã¹ãä¹ã®åæå€ã§ãã
M ã¯ãN ãå¢å ãããå¢å åã§ãã
ä¿æ° ã¯ãäžé£ã®ä¿æ°ã§ããä¿æ°ããšã«ãçŽæ°ã®åã 1 ã»ã¯ã·ã§ã³å»¶é·ãããŸãã
SIGN
æ°å€ã®ç¬Šå·ãè¿ããŸãã æ°ãæ£ã®å Žå㯠1ãè² ã®å Žå㯠-1ããŒãã®å Žå㯠0 ãè¿ããŸãã
æ§æ
SIGN(æ°å€)
æ°å€ ã¯ãæ£è² ãæ€æ»ããæ°å€ã§ãã
äŸ
=SIGN(3.4) ã¯ã1 ãè¿ããŸãã
=SIGN(-4.5) ã¯ã-1 ãè¿ããŸãã
SIN
ã©ãžã¢ã³åäœã§æå®ãããå€ã®ãµã€ã³ãè¿ããŸãã
æ§æ
SIN(æ°å€)
æ°å€ ã®ãµã€ã³ãã©ãžã¢ã³åäœã®è§åºŠãè¿ããŸãã
è§åºŠã®ãµã€ã³ã床æ°ã§è¿ãã«ã¯ãRADIANS 颿°ã䜿çšããŸãã
äŸ
=SIN(PI()/2) ã¯ãPI/2 ã©ãžã¢ã³ã®ãµã€ã³ã衚ã 1 ãè¿ããŸãã
=SIN(RADIANS(30)) ã¯ã30 床ã®ãµã€ã³ã衚ã 0.5 ãè¿ããŸãã
SINH
æ°å€ã®åæ²ç·ãµã€ã³ãè¿ããŸãã
æ§æ
SINH(æ°å€)
æ°å€ ã®åæ²ç·ãµã€ã³ãè¿ããŸãã
äŸ
=SINH(0) ã¯ã0 ã®åæ²ç·ãµã€ã³ã衚ã 0 ãè¿ããŸãã
SQRT
æ°å€ã®æ£ã®å¹³æ¹æ ¹ãè¿ããŸãã
æ§æ
SQRT(æ°å€)
æ°å€ ã®æ£ã®å¹³æ¹æ ¹ãè¿ããŸãã
æ°åã¯æ£ã®æ°ã«ããŸãã
äŸ
=SQRT(16) ã¯ã4 ãè¿ããŸãã
=SQRT(-16) ã¯ãinvalid argument ãšã©ãŒãè¿ããŸãã
SQRTPI
(PI x æ°) ã®å¹³æ¹æ ¹ãè¿ããŸãã
æ§æ
SQRTPI(Number)
PI ã« æ°å€ ãæããæ°ã®æ£ã®å¹³æ¹æ ¹ãè¿ããŸãã
ããã¯ãSQRT(PI()*æ°å€) ãšåãã§ãã
äŸ
=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 |
MAX |
5 |
105 |
MIN |
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 åã®åŒæ°ã§ãã
äŸ
æ°å 1ã2ãããã³ 3 ããã¹ãããã¯ã¹ã«æ°å 2ã3ãããã³ 4 ãå ¥åãããšãçµæãšã㊠9 ãè¿ãããŸãã
=SUM(A1;A3;B5) ã¯ã3 ã€ã®ã»ã«ã®åèšãèšç®ããŸãã=SUM (A1:E10) ã¯ãA1 ãã E10 ã®ã»ã«ç¯å²ã®ãã¹ãŠã®ã»ã«ã®åèšãèšç®ããŸãã
SUM() 颿°ã§æ¡ä»¶ã«è«çç©ãé©çšããå Žåãæ¬¡ã®ãããªæ¹æ³ã䜿çšããŸãã
äŸã®åææ¡ä»¶:衚ã«è«æ±æžãå ¥åããŠããŸããå A ã«ã¯è«æ±æžã®æ¥ä»ãå B ã«ã¯éé¡ãå«ãŸããŠããŸããããšãã°ã2008-01-01 ãã 2008-02-01 ããåãŸã§ã®æéã®éé¡ã®ããã«ãç¹å®ã®æã ãã®åèšéé¡ãè¿ãããã«äœ¿çšã§ããæ°åŒã調ã¹ãŸããæ¥ä»å€ã®ç¯å²ã¯ A1:A40 ã§ãåèšããéé¡ãå«ãŸããŠããç¯å²ã¯ B1:B40 ã§ããC1 ã«ã¯ã察象ãšãªãè«æ±æžã®éå§æ¥ 2008-01-01 ãå«ãŸããC2 ã«ã¯æ¥ä» 2008-02-01 ãå«ãŸããŸããC2 ã®æ¥ä»ã¯ç¯å²å€ã«ãªããŸãã
æ¬¡ã®æ°åŒãè¡ååŒãšããŠå ¥åããŸãã
=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)
ãã®æ°åŒãè¡ååŒãšããŠå ¥åããã«ã¯ãæ°åŒãéãããšãã«ãEnter ããŒã ããæŒãã®ã§ã¯ãªããShift + Command + Ctrl + Enter ããŒãäžç·ã«æŒãå¿ èŠããããŸãããã®çµæããã®æ°åŒã¯ æ°åŒããŒã«ãäžãã£ãã«å²ãŸããŠè¡šç€ºãããŸãã
{=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)}
æ°åŒã¯ãæ¯èŒçµæãæ¡ä»¶ãæºããå Žå㯠1ãæºãããªãå Žå㯠0 ãšããäºå®ã«åºã¥ããŠããŸããåã ã®æ¯èŒçµæã¯è¡åãšããŠæ±ãããè¡åä¹ç®ã§äœ¿çšãããŸããæåŸã«åã ã®å€ãåèšãããçµæè¡åãèšç®ãããŸãã
SUMIF
æ¡ä»¶ãæºããã»ã«ã®åèšãè¿ããŸãããã®é¢æ°ã䜿ããšãç¯å²å ã§ç¹å®ã®å€ãæ€çŽ¢ã§ããŸãã
æ§æ
SUMIF(ç¯å²; æ¡ä»¶; åèšç¯å²)
ç¯å² ã¯ãæ¡ä»¶ãé©çšããç¯å²ã§ãã
æ¡ä»¶ ã¯ãæ€çŽ¢æ¡ä»¶ã衚瀺ãããŠããã»ã«ããŸãã¯æ€çŽ¢æ¡ä»¶ãã®ãã®ã§ããæ¡ä»¶ãæ°åŒäžã«æžãå Žåã¯ãäºéåŒçšç¬Šã§å²ãå¿ èŠããããŸãã
åèšç¯å² ã¯ãå€ãåèšããç¯å²ã§ãããã®ãã©ã¡ãŒã¿ãŒãæå®ãããŠããªãå Žåã¯ãç¯å²ã®å€ãåèšããŸãã

SUMIF ã¯ããªãã·ã§ã³ã®åèšç¯å²ãã©ã¡ãŒã¿ãŒãæå®ãããŠããªãå Žåã ããæ¡ä»¶ãã©ã¡ãŒã¿ãŒã§ã®ã¿åç §é£çµæŒç®å (~) ããµããŒãããŠããŸãã
äŸ
è² ã®æ°ã ããåèšããã«ã¯: =SUMIF(A1:A10;"<0")
=SUMIF(A1:A10;">0";B1:10) ã¯ãç¯å² A1:A10 ã®å¯Ÿå¿ããå€ã 0 ãã倧ããå Žåã ããç¯å² B1:B10 ã®å€ãåèšããŸãã
SUMIF() ã§äœ¿çšã§ããæ§æäŸãããã«èŠããå Žåã¯ãCOUNTIF() ãåç §ããŠãã ããã
SUMSQ
æ°å€ã®å¹³æ¹å (åŒæ°ã®äºä¹ãå ç®ãããã®) ãèšç®ããã«ã¯ãããããããã¹ããã£ãŒã«ãã«å ¥åããŸãã
æ§æ
SUMSQ(æ°å€ 1; æ°å€ 2; ...; æ°å€ 30)
æ°å€ 1 ãã 30 ã¯ãå¹³æ¹ã®åèšãèšç®ããæé« 30 åã®åŒæ°ã§ãã
äŸ
æ°å 1ã2ãããã³ 3 ããã¹ãããã¯ã¹ã«æ°å 2ã3ãããã³ 4 ãå ¥åãããšãçµæãšã㊠29 ãè¿ãããŸãã
TAN
ã©ãžã¢ã³åäœã§æå®ãããå€ã®ã¿ã³ãžã§ã³ããè¿ããŸãã
æ§æ
TAN(æ°å€)
æ°å€ ã®ã¿ã³ãžã§ã³ããã©ãžã¢ã³åäœã®è§åºŠãè¿ããŸãã
è§åºŠã®ã¿ã³ãžã§ã³ãã床æ°ã§è¿ãã«ã¯ãRADIANS 颿°ã䜿çšããŸãã
äŸ
=TAN(PI()/4) ã¯ãPI/4 ã©ãžã¢ã³ã®ã¿ã³ãžã§ã³ãã衚ã 1 ãè¿ããŸãã
=TAN(RADIANS(45)) ã¯ã45 床ã®ã¿ã³ãžã§ã³ãã§ãã 1 ãè¿ããŸãã
TANH
æ°å€ã®åæ²ç·ã¿ã³ãžã§ã³ããè¿ããŸãã
æ§æ
TANH(æ°å€)
æ°å€ ã®åæ²ç·ã¿ã³ãžã§ã³ããè¿ããŸãã
äŸ
=TANH(0) ã¯ã0 ã®åæ²ç·ã¿ã³ãžã§ã³ãã衚ã 0 ãè¿ããŸãã
TRUNC
å°æ°ç¹ä»¥äžãåé€ããŠæ°ãåãæšãŠãŸãã
æ§æ
TRUNC(æ°å€; ã«ãŠã³ã)
ã«ãŠã³ã ãæå€§ã§å°æ°äœã® æ°å€ ãè¿ããŸããäœåãªå°æ°äœã¯ã笊å·ã«ãããããåã«åé€ãããŸãã
TRUNC(æ°å€; 0) ã¯æ£ã®æ°ã§ã¯ INT(æ°å€) ãšããŠåäœããè² ã®æ°ã§ã¯ãŒãã«åããå¹ççãªäžžãã§ãã

çµæã®å°æ°ç¹ç¬¬äœäœãŸã§ã衚瀺ããã®ã㯠LibreOffice â èšå®ããŒã« â ãªãã·ã§ã³ â LibreOffice Calc - èšç®åŒ ã§èšå®ããŸãã
äŸ
=TRUNC(1.239;2) ã¯ã1.23 ãè¿ããŸãã9 ã¯å€±ãããŸãã
=TRUNC(-1.234999;3) ã¯ã-1.234 ãè¿ããŸãããã¹ãŠã® 9 ã倱ãããŸãã