$BLa$jCM(B[$BL\E*(B]$BJL!]%o!<%/%7!<%H4X?t!&=q<00lMw(B
|
|
$B:w0z(B |
$BJV$jCM(B[$BL\E*(B](Return) |
$B4X?t5Z$S=q<0!J(BFunctions & Syntax$B!K(B |
|
1. |
$B1Q(B |
#N/A $B0J30$N%(%i! |
=ISERR($B%F%9%H$NBP>](B) |
|
2. |
|
1 $BG/$r(B 360 $BF|(B (30 $BF|!_(B12) $B$H2>Dj$7$F!"(B2 $B$D$NF|IU$N4V$NF|?t(B |
=DAYS360($B3+;OF|(B,$B=*N;F|(B,$BJ}<0(B) |
|
3. |
|
10 $B?J?tJQ49(B |
=BIN2DEC($B?tCM(B) |
|
4. |
|
10 $B?J?tJQ49(B |
=HEX2DEC($B?tCM(B) |
|
5. |
|
10 $B?J?tJQ49(B |
=OCT2DEC($B?tCM(B) |
|
6. |
|
16 $B?J?tJQ49(B |
=BIN2HEX($B?tCM(B,$B7e?t(B) |
|
7. |
|
16 $B?J?tJQ49(B |
=DEC2HEX($B?tCM(B,$B7e?t(B) |
|
8. |
|
16 $B?J?tJQ49(B |
=OCT2HEX($B?tCM(B,$B7e?t(B) |
|
9. |
|
2 $B$D$NCM$,Ey$7$$$+$I$&$+$r%F%9%H(B |
=DELTA($B?tCM(B1,$B?tCM(B2) |
|
10. |
|
2 $B?J?tJQ49(B |
=DEC2BIN($B?tCM(B,$B7e?t(B) |
|
11. |
|
2 $B?J?tJQ49(B |
=HEX2BIN($B?tCM(B,$B7e?t(B) |
|
12. |
|
2 $B?J?tJQ49(B |
=OCT2BIN($B?tCM(B,$B7e?t(B) |
|
13. |
|
8 $B?J?tJQ49(B |
=BIN2OCT($B?tCM(B,$B7e?t(B) |
|
14. |
|
8 $B?J?tJQ49(B |
=DEC2OCT($B?tCM(B,$B7e?t(B) |
|
15. |
|
8 $B?J?tJQ49(B |
=HEX2OCT($B?tCM(B,$B7e?t(B) |
|
16. |
|
DLL $B$^$?$O%3!<%I(B $B%j%=!<%9$K4^$^$l$k%W%m%7!<%8%c8F$S=P$7(B |
=CALL($B%l%8%9%?HV9f(B,$B0z?t(B1...) |
|
17. |
|
DLL$B$^$?$O%3!<%I(B $B%j%=!<%9$N$&$A!";XDj$7$?$b$N$N%l%8%9%?(B ID |
=REGISTER.ID($B%b%8%e!<%kL>(B,$B%W%m%7!<%8%c(B,$B%?%$%W(B) |
|
18. |
|
e $B$N$Y$->h(B |
=EXP($B?tCM(B) |
|
19. |
|
F $B3NN(J,I[(B |
=FDIST(x,$B<+M3EY(B1,$B<+M3EY(B2) |
|
20. |
|
F $B3NN(J,I[5U4X?t(B |
=FINV($B3NN((B,$B<+M3EY(B1,$B<+M3EY(B2) |
|
21. |
|
F $B8!Dj7k2L(B |
=FTEST($BG[Ns(B1,$BG[Ns(B2) |
|
22. |
|
z $B8!Dj$NN>B&(B P $BCM(B |
=ZTEST($BG[Ns(B,x,$B&R(B) |
|
23. |
|
$B&P(B $B$NJ?J}:,(B |
=SQRTPI($B?tCM(B) |
|
24. |
$B%"(B |
$B%"!<%/%3%5%$%s(B |
=ACOS($B?tCM(B) |
|
25. |
|
$B%"!<%/%5%$%s(B |
=ASIN($B?tCM(B) |
|
26. |
|
$B%"!<%/%?%s%8%'%s%H(B |
=ATAN($B?tCM(B) |
|
27. |
|
$B%"!<%/%?%s%8%'%s%H(B |
=ATAN2(x$B:BI8(B,y$B:BI8(B) |
|
28. |
$B%$(B |
$B$$$:$l$+$,(B TRUE $B$N$H$-(B TRUE $B!#(B |
=OR($BO@M}<0(B1,$BO@M}<0(B2,...) |
|
29. |
$B%((B |
$B%(%i! |
=ISNA($B%F%9%H$NBP>](B) |
|
30. |
|
$B%(%i! |
=ISERROR($B%F%9%H$NBP>](B) |
|
31. |
|
$B%(%i! |
=ERROR.TYPE($B%(%i! |
|
32. |
$B%+(B |
$B%+%$(B 2 $B>h8!Dj(B |
=CHITEST($B |
|
33. |
|
$B%+%$(B 2 $B>hJ,I[$N5U4X?tCM(B |
=CHIINV($B3NN((B,$B<+M3EY(B) |
|
34. |
|
$B%+%$(B 2 $B>hJ,I[$NJRB&3NN((B |
=CHIDIST(x,$B<+M3EY(B) |
|
35. |
|
$B%,%s%^4X?t(B $B&C(B(x) $B$NCM$N<+A3BP?t(B |
=GAMMALN(x) |
|
36. |
|
$B%,%s%^J,I[4X?t$N5U4X?t$NCM(B |
=GAMMAINV($B3NN((B,$B&A(B,$B&B(B) |
|
37. |
|
$B%,%s%^J,I[4X?tCM(B |
=GAMMADIST(x,$B&A(B,$B&B(B,$B4X?t7A<0(B) |
|
38. |
$B%-(B |
$B%-%c%C%7%e(B $B%U%m!<=$@5FbItMx1WN((B |
=MIRR($BHO0O(B,$B0BA4MxN((B,$B4m81MxN((B) |
|
39. |
|
$B%-%c%C%7%e(B $B%U%m! |
=IRR($BHO0O(B,$B?dDjCM(B) |
|
40. |
$B%3(B |
$B%3%5%$%s(B |
=COS($B?tCM(B) |
|
41. |
$B%5(B |
$B%5%$%s(B |
=SIN($B?tCM(B) |
|
42. |
$B%7(B |
$B%7%j%"%kCMBP1~F|$,$=$NG/$N2?=5L\$K$"$?$k$+(B |
=WEEKNUM($B%7%j%"%kCM(B,$B=5$N4p=`(B) |
|
43. |
|
$B%7%j%"%kCMMKF|JQ49(B |
=WEEKDAY($B%7%j%"%kCM(B,$B |
|
44. |
$B%9(B |
$B%9%A%e!<%G%s%H$N(B t $BJ,I[$K=>$&3NN((B |
=TTEST($BG[Ns(B1,$BG[Ns(B2,$BHxIt(B,$B8!Dj$N |
|
45. |
|
$B%9%A%e!<%G%s%H$N(B t $BJ,I[$N5U4X?tCM(B |
=TINV($B3NN((B,$B<+M3EY(B) |
|
46. |
|
$B%9%A%e!<%G%s%H$N(B t $BJ,I[CM(B |
=TDIST(x,$B<+M3EY(B,$BHxIt(B) |
|
47. |
|
$B$9$Y$F$,(B TRUE $B$N$H$-(B TRUE |
=AND($BO@M}<0(B1,$BO@M}<0(B2,...) |
|
48. |
|
$B$:$i$7;2>H(B |
=OFFSET($B4p=`(B,$B9T?t(B,$BNs?t(B,$B9b$5(B,$BI}(B) |
|
49. |
$B%;(B |
$B%;%kHO0O$N$H$-(B TRUE |
=ISREF($B%F%9%H$NBP>](B) |
|
50. |
$B%?(B |
$B%?%s%8%'%s%H(B |
=TAN($B?tCM(B) |
|
51. |
$B%F(B |
$B%G!<%?7?BP1~?tCM(B |
=TYPE($B%G!<%?%?%$%W(B) |
|
52. |
$B%O(B |
$B%O%$%Q!<%\%j%C%/(B $B%"!<%/%3%5%$%s(B |
=ACOSH($B?tCM(B) |
|
53. |
|
$B%O%$%Q!<%\%j%C%/(B $B%"!<%/%5%$%s(B |
=ASINH($B?tCM(B) |
|
54. |
|
$B%O%$%Q!<%\%j%C%/(B $B%"!<%/%?%s%8%'%s%H(B |
=ATANH($B?tCM(B) |
|
55. |
|
$B%O%$%Q!<%\%j%C%/(B $B%3%5%$%s(B |
=COSH($B?tCM(B) |
|
56. |
|
$B%O%$%Q!<%\%j%C%/(B $B%5%$%s(B |
=SINH($B?tCM(B) |
|
57. |
|
$B%O%$%Q!<%\%j%C%/(B $B%?%s%8%'%s%H(B |
=TANH($B?tCM(B) |
|
58. |
|
$B%O%$%Q!<%j%s%/(B |
=HYPERLINK($B%j%s%/@h(B,$BJLL>(B) |
|
59. |
$B%R(B |
$B%T%"%=%s$N@QN(Aj4X78?t$r(B 2 $B>hCM(B |
=RSQ($B4{CN$N(By,$B4{CN$N(Bx) |
|
60. |
|
$B%T%"%=%s$N@QN(Aj4X78?tCM(B |
=PEARSON($BG[Ns(B1,$BG[Ns(B2) |
|
61. |
|
$B%T%\%C%H%F!<%V%k$K3JG<$5$l$F$$$k%G!<%?(B |
=GETPIVOTDATA($B%T%\%C%H%F!<%V%k(B,$BL>A0(B) |
|
62. |
$B%U(B |
$B%U%#%C%7%c! |
=FISHERINV(y) |
|
63. |
|
$B%U%#%C%7%c! |
=FISHER(x) |
|
64. |
|
$B$U$j$,$J(B |
=PHONETIC($BHO0O(B) |
|
65. |
$B%X(B |
$B$Y$->h(B |
=POWER($B?tCM(B,$B;X?t(B) |
|
66. |
|
$B$Y$->hB?9`<0$NCM(B |
=SERIESSUM(x,n,m,$B78?t(B) |
|
67. |
|
$B%Y%C%;%k4X?t(B Jn(x) |
=BESSELJ(x,n) |
|
68. |
|
$B%Y%C%;%k4X?t(B Yn(x) |
=BESSELY(x,n) |
|
69. |
$B%[(B |
$B%]%"%=%s3NN(J,I[CM(B |
=POISSON($B%$%Y%s%H?t(B,$BJ?6Q(B,$B4X?t7A<0(B) |
|
70. |
$B%^(B |
$B%^%3!<%l! |
=MDURATION($B |
|
71. |
|
$B%^%3!<%l!<78?t(B |
=DURATION($B |
|
72. |
$B%a(B |
$B%a%8%"%s(B |
=MEDIAN($B?tCM(B1,$B?tCM(B2,...) |
|
73. |
$B%i(B |
$B%i%8%"%sJQ49(B |
=RADIANS($B3QEY(B) |
|
74. |
$B%m(B |
$B%m!<%^?t;zJQ49(B |
=ROMAN($B?tCM(B,$B=q<0(B) |
|
75. |
$B%o(B |
$B%o%$%V%kJ,I[$NCM(B |
=WEIBULL(x,$B&A(B,$B&B(B,$B4X?t7A<0(B) |
|
76. |
$B$$(B |
$B0u:~$G$-$J$$J8;z:o=|(B |
=CLEAN($BJ8;zNs(B) |
|
77. |
$B$((B |
$B1QBgJ8;zJQ49(B |
=UPPER($BJ8;zNs(B) |
|
78. |
|
$B1QF,J8;zBgJ8;zJQ49(B |
=PROPER($BJ8;zNs(B) |
|
79. |
|
$B1Q>.J8;zJQ49(B |
=LOWER($BJ8;zNs(B) |
|
80. |
|
$B1_<~N(&P$NCM(B |
=PI() |
|
81. |
|
$B1_=q<0@_DjJQ49;M |
=YEN($B?tCM(B,$B7e?t(B) |
|
82. |
$B$+(B |
$B2A3J(B1 $B4|L\F|?tH>C<3[LL(B $100 $BEv$?$j(B |
=ODDLPRICE($B |
|
83. |
|
$B2A3J3[LL(B $100 $BEv$?$j(B (TB) |
=TBILLPRICE($B |
|
84. |
|
$B2TF0F|?t(B |
=NETWORKDAYS($B3+;OF|(B,$B=*N;F|(B,$B:WF|(B) |
|
85. |
|
$B2TF0F|?t$@$1A0$^$?$O8e$NF|IUBP1~%7%j%"%kCM(B |
=WORKDAY($B3+;OF|(B,$BF|?t(B,$B:WF|(B) |
|
86. |
|
$B2s5"D>@~$N79$-(B |
=SLOPE($B4{CN$N(By,$B4{CN$N(Bx) |
|
87. |
|
$B2s5"D>@~$N8DJL$N(B x $B$NCM$KBP$9$k(B y $B$NM=B,CM$NI8=`8m:9(B |
=STEYX($B4{CN$N(By,$B4{CN$N(Bx) |
|
88. |
|
$B2s5"D>@~$N@ZJR$NCM(B |
=INTERCEPT($B4{CN$N(By,$B4{CN$N(Bx) |
|
89. |
|
$B2s5"D>@~>eCM(B |
=FORECAST(x,$B4{CN$N(By,$B4{CN$N(Bx) |
|
90. |
|
$B3+;OF|$+$i5/;;$7$F!";XDj$5$l$?7n?t$@$1A0$^$?$O8e$N7n$N:G=*F|BP1~%7%j%"%kCM(B |
=EOMONTH($B3+;OF|(B,$B7n(B) |
|
91. |
|
$B3,>h(B |
=FACT($B?tCM(B) |
|
92. |
|
$B30It$N%G!<%?(B $B%=!<%9$H@\B3$7!"%o!<%/%7!<%H$+$i%/%(%j!<$r |
=SQL.REQUEST($B@\B3%3!<%I(B,$B=PNO%;%k(B,$B%@%$%"%m%0I=<((B,$B%9%F!<%H%a%s%H(B,$BNsL>I=<((B) |
|
93. |
|
$B3F2q7W4|8:2A=~5QHq%U%i%s%9(B |
=AMORDEGRC($B |
|
94. |
|
$B3F2q7W4|8:2A=~5QHq%U%i%s%9(B |
=AMORLINC($B |
|
95. |
|
$B3NN((B |
=PROB(x$BHO0O(B,$B3NN(HO0O(B,$B2<8B(B,$B>e8B(B) |
|
96. |
|
$B3NN(!"8DJL9`$NFs9`J,I[(B |
=BINOMDIST($B@.8y?t(B,$B;n9T2s?t(B,$B@.8yN((B,$B4X?t7A<0(B) |
|
97. |
|
$B3[LL(B $100 $BEv$?$j2A3J(B |
=ODDFPRICE($B |
|
98. |
|
$B4A?t;zI=<(=q<0(B1$B!A(B3 |
=NUMBERSTRING($B?tCM(B,$B=q<0(B) |
|
99. |
|
$B4V@\;2>H(B |
=INDIRECT($B;2>HJ8;zNs(B,$B;2>H7A<0(B) |
|
100. |
$B$-(B |
$B4q?t$N$H$-(B TRUE |
=ISODD($B?tCM(B) |
|
101. |
|
$B5U9TNs(B |
=MINVERSE($BG[Ns(B) |
|
102. |
|
$B6&J,;6(B |
=COVAR($BG[Ns(B1,$BG[Ns(B2) |
|
103. |
|
$B9T8!:w(B |
=HLOOKUP($B8!:wCM(B,$BHO0O(B,$B9THV9f(B,$B8!:w$N7?(B) |
|
104. |
|
$B9T?t(B |
=ROWS($BG[Ns(B) |
|
105. |
|
$B9THV9f(B |
=ROW($BHO0O(B) |
|
106. |
|
$B9TNs(B |
=MDETERM($BG[Ns(B) |
|
107. |
|
$B9TNs@Q(B |
=MMULT($BG[Ns(B1,$BG[Ns(B2) |
|
108. |
|
$B9TNsJQ49(B |
=TRANSPOSE($BG[Ns(B) |
|
109. |
|
$B@Z$j |
=ROUNDDOWN($B?tCM(B,$B7e?t(B) |
|
110. |
|
$B@Z$j |
=TRUNC($B?tCM(B,$B7e?t(B) |
|
111. |
|
$B@Z$j |
=INT($B?tCM(B) |
|
112. |
|
$B@Z$j |
=FLOOR($B?tCM(B,$B4p=`CM(B) |
|
113. |
|
$B@Z$j>e$2$F7e?t;XDj(B |
=ROUNDUP($B?tCM(B,$B7e?t(B) |
|
114. |
|
$B@Z$j>e$2D>6a4q?t(B |
=ODD($B?tCM(B) |
|
115. |
|
$B@Z$j>e$2D>6a6v?t(B |
=EVEN($B?tCM(B) |
|
116. |
|
$B@Z$j>e$2G\?t6a;wCM(B |
=CEILING($B?tCM(B,$B4p=`CM(B) |
|
117. |
$B$/(B |
$B6uGr%;%k$N8D?t(B |
=COUNTBLANK($BHO0O(B) |
|
118. |
|
$B6uGr$N$H$-(B TRUE |
=ISBLANK($B%F%9%H$NBP>](B) |
|
119. |
|
$B6v?t$N$H$-(B TRUE |
=ISEVEN($B?tCM(B) |
|
120. |
$B$1(B |
$B78?tCM!";X?t6J@~(B |
=LOGEST($B4{CN$N(By,$B4{CN$N(Bx,$BDj?t(B,$BJd@5(B) |
|
121. |
|
$B78?tCM!"D>@~(B |
=LINEST($B4{CN$N(By,$B4{CN$N(Bx,$BDj?t(B,$BJd@5(B) |
|
122. |
|
$B7n?t$@$1A0$^$?$O8e$NF|IUBP1~%7%j%"%kCM(B |
=EDATE($B3+;OF|(B,$B7n(B) |
|
123. |
|
$B7nJQ49(B |
=MONTH($B%7%j%"%kCM(B) |
|
124. |
|
$B8!::(B |
=MATCH($B8!::CM(B,$B8!::HO0O(B,$B>H9g$N7?(B) |
|
125. |
|
$B8!:w(B |
=INDEX($BG[Ns(B,$B9THV9f(B,$BNsHV9f(B) |
|
126. |
|
$B8!:w(B |
=LOOKUP($B8!::CM(B,$B8!::HO0O(B,$BBP1~HO0O(B) |
|
127. |
|
$B8=:_$NA`:n4D6->pJs(B |
=INFO($B8!::$N |
|
128. |
|
$B8=:_$NF|IU$H;~9oBP1~%7%j%"%kCM(B |
=NOW() |
|
129. |
|
$B8=:_$NF|IUBP1~%7%j%"%kCM(B |
=TODAY() |
|
130. |
$B$3(B |
$B8D?t(B |
=COUNT($BCM(B1,$BCM(B2,...) |
|
131. |
|
$B8D?t!"%;%k(B |
=DCOUNT(Database,$B%U%#!<%k%I(B,Criteria) |
|
132. |
|
$B8D?t!"6uGr$G$J$$%;%k(B |
=DCOUNTA(Database,$B%U%#!<%k%I(B,Criteria) |
|
133. |
|
$B8D?t!"O@M}CM$r4^$`(B |
=COUNTA($BCM(B1,$BCM(B2,...) |
|
134. |
|
$B8D?t8!:w>r7o0lCW%;%k(B |
=COUNTIF($BHO0O(B,$B8!:w>r7o(B) |
|
135. |
|
$B8D?tA*BrAH$_9g$o$;(B |
=COMBIN($BAm?t(B,$BH4$- |
|
136. |
|
$B8m:94X?t$N@QJ,CM(B |
=ERF($B2<8B(B,$B>e8B(B) |
|
137. |
|
$B9g7W(B |
=SUM($B?tCM(B1,$B?tCM(B2,...) |
|
138. |
|
$B9g7W!"(B 2 $B>h$N(B |
=SUMSQ($B?tCM(B1,$B?tCM(B2,...) |
|
139. |
|
$B9g7W!"8!:w>r7o0lCW%;%kCM(B |
=SUMIF($BHO0O(B,$B8!:w>r7o(B,$B9g7WHO0O(B) |
|
140. |
|
$B9g7W!":9$r(B 2 $B>h(B |
=SUMXMY2($BG[Ns(B1,$BG[Ns(B2) |
|
141. |
|
$B9g7W!">r7oIU$-(B |
=DSUM(Database,$B%U%#!<%k%I(B,Criteria) |
|
142. |
|
$B9g7W!"@Q(B |
=SUMPRODUCT($BG[Ns(B1,$BG[Ns(B2,$BG[Ns(B3,...) |
|
143. |
|
$B9g7W!"J?J}:9(B |
=SUMX2MY2($BG[Ns(B1,$BG[Ns(B2) |
|
144. |
|
$B9g7W!"J?J}OB(B |
=SUMX2PY2($BG[Ns(B1,$BG[Ns(B2) |
|
145. |
$B$5(B |
$B:8>e6y%;%k>pJs(B |
=CELL($B8!::$N |
|
146. |
|
$B:G>.8xG\?t(B |
=LCM($B?tCM(B1,$B?tCM(B2,...) |
|
147. |
|
$B:G>.CM(B |
=MIN($B?tCM(B1,$B?tCM(B2,...) |
|
148. |
|
$B:G>.CM(B |
=DMIN(Database,$B%U%#!<%k%I(B,Criteria) |
|
149. |
|
$B:G>.CM!"O@M}CM$r4^$`(B |
=MINA($BCM(B1,$BCM(B2,...) |
|
150. |
|
$B:GBg8xLs?t(B |
=GCD($B?tCM(B1,$B?tCM(B2,...) |
|
151. |
|
$B:GBgCM(B |
=MAX($B?tCM(B1,$B?tCM(B2,...) |
|
152. |
|
$B:GBgCM(B |
=DMAX(Database,$B%U%#!<%k%I(B,Criteria) |
|
153. |
|
$B:GBgCM!"O@M}CM$r4^$`(B |
=MAXA($BCM(B1,$BCM(B2,...) |
|
154. |
|
$B:GIQCM(B |
=MODE($B?tCM(B1,$B?tCM(B2,...) |
|
155. |
|
$B;2>HJ8;zNs:n@.(B |
=ADDRESS($B9THV9f(B,$BNsHV9f(B,$B;2>H$N7?(B,$B;2>H7A<0(B,$B%7!<%HL>(B) |
|
156. |
$B$7(B |
$B;M |
=ROUND($B?tCM(B,$B7e?t(B) |
|
157. |
|
$B;MJ,0L?tCj=P(B |
=QUARTILE($BG[Ns(B,$BLa$jCM(B) |
|
158. |
|
$B;X?t6J@~>e$NCM(B |
=GROWTH($B4{CN$N(By,$B4{CN$N(Bx,$B?7$7$$(Bx,$BDj?t(B) |
|
159. |
|
$B;X?tJ,I[4X?tCM(B |
=EXPONDIST(x,$B&K(B,$B4X?t7A<0(B) |
|
160. |
|
$B;XDj4|4VB_IU6b856bN_7W(B |
=CUMPRINC($BMxN((B,$B4|4V(B,$B8=:_2ACM(B,$B3+;O4|(B,$B=*N;4|(B,$B;YJ'4|F|(B) |
|
161. |
|
$B;XDj4|4VB_IU6bMxB)N_7W(B |
=CUMIPMT($BMxN((B,$B4|4V(B,$B8=:_2ACM(B,$B3+;O4|(B,$B=*N;4|(B,$B;YJ'4|F|(B) |
|
162. |
|
$B;~9oBP1~%7%j%"%kCM(B |
=TIME($B;~(B,$BJ,(B,$BIC(B) |
|
163. |
|
$B;~9oJ8;zNs%7%j%"%kCMJQ49(B |
=TIMEVALUE($B;~9oJ8;zNs(B) |
|
164. |
|
$B;~JQ49(B |
=HOUR($B%7%j%"%kCM(B) |
|
165. |
|
$B<+A3BP?t(B |
=LN($B?tCM(B) |
|
166. |
|
$B |
=EFFECT($BL>L\MxN((B,$BJ#Mx7W;;4|4V(B) |
|
167. |
|
$B |
=COMPLEX($B |
|
168. |
|
$B |
=CHOOSE($B%$%s%G%C%/%9(B,$BCM(B1,$BCM(B2,...) |
|
169. |
|
$B=$@5%Y%C%;%k4X?t(B In(x) |
=BESSELI(x,n) |
|
170. |
|
$B=$@5%Y%C%;%k4X?t(B Kn(x) |
=BESSELK(x,n) |
|
171. |
|
$B=87W(B |
=SUBTOTAL($B=87WJ}K!(B,$BHO0O(B1,...) |
|
172. |
|
$B=g0L(B k $BHVL\$K>.$5$JCM(B |
=SMALL($BHO0O(B,$B=g0L(B) |
|
173. |
|
$B=g0L!"(Bk $BHVL\$KBg$-$J%G!<%?(B |
=LARGE($BHO0O(B,$B=g0L(B) |
|
174. |
|
$B=gNs(B |
=PERMUT($BI8K\?t(B,$BH4$- |
|
175. |
|
$B=i4|Ej;q856b>-Mh2ACM(B |
=FVSCHEDULE($B856b(B,$BMxN(G[Ns(B) |
|
176. |
|
$B=xNs(B |
=RANK($B?tCM(B,$BHO0O(B,$B=g=x(B) |
|
177. |
|
$B>&$N@0?tIt(B |
=QUOTIENT($BJ,;R(B,$BJ,Jl(B) |
|
178. |
|
$B>.?tJQ49(B |
=DOLLARDE($BJ,;R(B,$BJ,Jl(B) |
|
179. |
|
$B>oMQBP?t(B |
=LOG10($B?tCM(B) |
|
180. |
|
$B>r7o$rK~$?$9%l%3!<%I$N@Q(B |
=DPRODUCT(Database,$B%U%#!<%k%I(B,Criteria) |
|
181. |
$B$9(B |
$B?tCM$,$7$-$$CM$h$jBg$-$$$+$I$&$+$r%F%9%H(B |
=GESTEP($B?tCM(B,$B$7$-$$CM(B) |
|
182. |
|
$B?tCM$N$H$-(B TRUE |
=ISNUMBER($B%F%9%H$NBP>](B) |
|
183. |
|
$B?tCMJQ49(B |
=N($BCM(B) |
|
184. |
|
$B@5Ii$KBP1~?tCM(B |
=SIGN($B?tCM(B) |
|
185. |
$B$;(B |
$B@Q(B |
=PRODUCT($B?tCM(B1,$B?tCM(B2,...) |
|
186. |
|
$B@dBPCM(B |
=ABS($B?tCM(B) |
|
187. |
|
$B@dBPJP:9J?6Q(B |
=AVEDEV($B?tCM(B1,$B?tCM(B2,...) |
|
188. |
|
$B@hF,J8;zBP1~(B ASCII $B$^$?$O(B JIS $B%3!<%I(B |
=CODE($BJ8;zNs(B) |
|
189. |
|
$B@mEY(B |
=KURT($B?tCM(B1,$B?tCM(B2,...) |
|
190. |
$B$=(B |
$BAj4X78?t(B |
=CORREL($BG[Ns(B1,$BG[Ns(B2) |
|
191. |
|
$BAj>hJ?6Q(B |
=GEOMEAN($B?tCM(B1,$B?tCM(B2,...) |
|
192. |
|
$BAjJd8m:94X?t$N@QJ,CM(B |
=ERFC(x) |
|
193. |
$B$?(B |
$BBP?t@55,N_@QJ,I[4X?t$N5U4X?tCM(B |
=LOGINV($B3NN((B,$BJ?6Q(B,$BI8=`JP:9(B) |
|
194. |
|
$BBP?t@55,N_@QJ,I[4X?tCM(B |
=LOGNORMDIST(x,$BJ?6Q(B,$BI8=`JP:9(B) |
|
195. |
|
$BC10LJQ49(B |
=CONVERT($B?tCM(B,$BJQ49A0C10L(B,$BJQ498eC10L(B) |
|
196. |
$B$A(B |
$BCf4V9`J?6Q(B |
=TRIMMEAN($BG[Ns(B,$B3d9g(B) |
|
197. |
|
$BCj=P(B |
=DGET(Database,$B%U%#!<%k%I(B,Criteria) |
|
198. |
|
$BD4OBJ?6Q(B |
=HARMEAN($B?tCM(B1,$B?tCM(B2,...) |
|
199. |
|
$BD64v2?J,I[4X?t$NCM(B |
=HYPGEOMDIST($BI8K\$N@.8y?t(B,$BI8K\?t(B,$BJl=8CD$N@.8y?t(B,$BJl=8CD$NBg$-$5(B) |
|
200. |
|
$BD>@~>e$NCM(B |
=TREND($B4{CN$N(By,$B4{CN$N(Bx,$B?7$7$$(Bx,$BDj?t(B) |
|
201. |
$B$D(B |
$B>o$K%(%i! |
=NA() |
|
202. |
|
$B>o$KO@M}CM(B FALSE |
=FALSE() |
|
203. |
|
$B>o$KO@M}CM(B TRUE |
=TRUE() |
|
204. |
$B$F(B |
$BDj3[D~8:K!8:2A=~5QHq(B |
=SYD($B |
|
205. |
|
$BDj3[K!8:2A=~5QHq(B |
=SLN($B |
|
206. |
|
$BDj4|MxB);YJ'3[LL(B $100 $BEv$?$j2A3J(B |
=PRICE($B |
|
207. |
|
$BDj4|MxB)L$<}MxB)3[(B |
=ACCRINT($BH/9TF|(B,$B:G=i$NMxJ'F|(B,$B |
|
208. |
|
$BDjN(K!8:2A=~5QHq(B |
=DB($B |
|
209. |
|
$BDl$KBP$9$kBP?t(B |
=LOG($B?tCM(B,$BDl(B) |
|
210. |
$B$H(B |
$BEY(B ($B!k(B)$BJQ49(B |
=DEGREES($B3QEY(B) |
|
211. |
|
$BEj;q4|4VFb;XDj4|;YJ'6bMx(B |
=IPMT($BMxN((B,$B4|(B,$B4|4V(B,$B8=:_2ACM(B,$B>-Mh2ACM(B,$B;YJ'4|F|(B) |
|
212. |
|
$BEj;q4|4VFb;XDj4|;YJ'6bMx(B |
=ISPMT($BMxN((B,$B4|(B,$B4|4V(B,$B8=:_2ACM(B) |
|
213. |
|
$BEj;q4|4VFb;XDj4|;YJ'856b(B |
=PPMT($BMxN((B,$B4|(B,$B4|4V(B,$B8=:_2ACM(B,$B>-Mh2ACM(B,$B;YJ'4|F|(B) |
|
214. |
|
$BEj;q8=:_2ACM(B |
=PV($BMxN((B,$B4|4V(B,$BDj4|;YJ'3[(B,$B>-Mh2ACM(B,$B;YJ'4|F|(B) |
|
215. |
|
$BEj;q>-Mh2ACM(B |
=FV($BMxN((B,$B4|4V(B,$BDj4|;YJ'3[(B,$B8=:_2ACM(B,$B;YJ'4|F|(B) |
|
216. |
|
$BEj;q@5L#8=:_2ACM(B |
=NPV($B3d0zN((B,$BCM(B1,$BCM(B2,...) |
|
217. |
|
$BEj;qA43[>Z7tMxN((B |
=INTRATE($B |
|
218. |
|
$BEj;qI,MW;YJ'2s?t(B |
=NPER($BMxN((B,$BDj4|;YJ'3[(B,$B8=:_2ACM(B,$B>-Mh2ACM(B,$B;YJ'4|F|(B) |
|
219. |
|
$BEj;qI,MWDj4|;YJ'3[(B |
=PMT($BMxN((B,$B4|4V(B,$B8=:_2ACM(B,$B>-Mh2ACM(B,$B;YJ'4|F|(B) |
|
220. |
|
$BEj;qK~4|F|;YJ'6b3[A43[(B |
=RECEIVED($B |
|
221. |
|
$BEj;qMxN((B |
=RATE($B4|4V(B,$BDj4|;YJ'3[(B,$B8=:_2ACM(B,$B>-Mh2ACM(B,$B;YJ'4|F|(B,$B?dDjCM(B) |
|
222. |
$B$K(B |
$BFs=E3,>h(B |
=FACTDOUBLE($B?tCM(B) |
|
223. |
|
$BF|?t!"7n?t!"$^$?$OG/?t(B |
=DATEDIF($B3+;OF|(B,$B=*N;F|(B,$BC10L(B) |
|
224. |
|
$BF|IUBP1~%7%j%"%kCM(B |
=DATE($BG/(B,$B7n(B,$BF|(B) |
|
225. |
|
$BF|IUJ8;zNs%7%j%"%kCMJQ49(B |
=DATEVALUE($BF|IUJ8;zNs(B) |
|
226. |
|
$BF|JQ99(B |
=DAY($B%7%j%"%kCM(B) |
|
227. |
$B$M(B |
$BG/C10L(B |
=YEARFRAC($B3+;OF|(B,$B=*N;F|(B,$B4p=`(B) |
|
228. |
|
$BG/JQ49(B |
=YEAR($B%7%j%"%kCM(B) |
|
229. |
$B$O(B |
$BG\?t@Z$j>e$2!"@Z$j |
=MROUND($B?tCM(B,$BG\?t(B) |
|
230. |
|
$BG\N(K!4|ESCf;q;:8:2A=~5QHq(B |
=VDB($B |
|
231. |
|
$BG\N(K!8:2A=~5QHq(B |
=DDB($B |
|
232. |
$B$R(B |
$BHf!"OB$N3,>h$H!"3,>h$N@Q(B |
=MULTINOMIAL($B?tCM(B1,$B?tCM(B2,...) |
|
233. |
|
$BI4J,0L$G(B k $BHVL\$K0LCV$9$kCM(B |
=PERCENTILE($BG[Ns(B,$BN((B) |
|
234. |
|
$BI4J,N((B |
=PERCENTRANK($BG[Ns(B,x,$BM-8z7e?t(B) |
|
235. |
|
$BI8=`2=JQNL(B |
=STANDARDIZE(x,$BJ?6Q(B,$BI8=`JP:9(B) |
|
236. |
|
$BICJQ49(B |
=SECOND($B%7%j%"%kCM(B) |
|
237. |
|
$BIQEYJ,I[$r=DJ}8~G[Ns(B |
=FREQUENCY($B%G!<%?G[Ns(B,$B6h4VG[Ns(B) |
|
238. |
$B$U(B |
$BITDj4|%-%c%C%7%e(B $B%U%m!<@5L#8=:_2ACM(B |
=XNPV($B3d0zN((B,$B%-%c%C%7%e%U%m!<(B,$BF|IU(B) |
|
239. |
|
$BITDj4|%-%c%C%7%e(B $B%U%m! |
=XIRR($BHO0O(B,$BF|IU(B,$B?dDjCM(B) |
|
240. |
|
$BJ#AG?t$N(B 2 $B$rDl$H$9$kBP?t(B |
=IMLOG2($BJ#AG?t(B) |
|
241. |
|
$BJ#AG?t$N%3%5%$%s(B |
=IMCOS($BJ#AG?t(B) |
|
242. |
|
$BJ#AG?t$N%5%$%s(B |
=IMSIN($BJ#AG?t(B) |
|
243. |
|
$BJ#AG?t$N$Y$->h(B |
=IMEXP($BJ#AG?t(B) |
|
244. |
|
$BJ#AG?t$N5u?t78?t(B |
=IMAGINARY($BJ#AG?t(B) |
|
245. |
|
$BJ#AG?t$N6K7A<0$NJP3Q&H(B |
=IMARGUMENT($BJ#AG?t(B) |
|
246. |
|
$BJ#AG?t$N:9(B |
=IMSUB($BJ#AG?t(B1,$BJ#AG?t(B2) |
|
247. |
|
$BJ#AG?t$N<+A3BP?t(B |
=IMLN($BJ#AG?t(B) |
|
248. |
|
$BJ#AG?t$N |
=IMREAL($BJ#AG?t(B) |
|
249. |
|
$BJ#AG?t$N>&(B |
=IMDIV($BJ#AG?t(B1,$BJ#AG?t(B2) |
|
250. |
|
$BJ#AG?t$N>oMQBP?t(B |
=IMLOG10($BJ#AG?t(B) |
|
251. |
|
$BJ#AG?t$N@0?t>h(B |
=IMPOWER($BJ#AG?t(B,$B?tCM(B) |
|
252. |
|
$BJ#AG?t$N@Q(B2 $B!A(B 29 $B8D(B |
=IMPRODUCT($BJ#AG?t(B1,$BJ#AG?t(B2,...) |
|
253. |
|
$BJ#AG?t$N@dBPCM(B |
=IMABS($BJ#AG?t(B) |
|
254. |
|
$BJ#AG?t$NJ#AG6&Lr(B |
=IMCONJUGATE($BJ#AG?t(B) |
|
255. |
|
$BJ#AG?t$NJ?J}:,(B |
=IMSQRT($BJ#AG?t(B) |
|
256. |
|
$BJ#AG?t$NOB(B2 $B!A(B 29 $B8D(B |
=IMSUM($BJ#AG?t(B1,$BJ#AG?t(B2,...) |
|
257. |
|
$BJ,?tJQ49(B |
=DOLLARFR($B>.?tCM(B,$BJ,Jl(B) |
|
258. |
|
$BJ,I[!"@55,J,I[4X?t$N5U4X?tCM(B |
=NORMINV($B3NN((B,$BJ?6Q(B,$BI8=`JP:9(B) |
|
259. |
|
$BJ,I[!"@55,J,I[4X?tCM(B |
=NORMDIST(x,$BJ?6Q(B,$BI8=`JP:9(B,$B4X?t7A<0(B) |
|
260. |
|
$BJ,I[!"I8=`@55,N_@QJ,I[4X?t$N5U4X?tCM(B |
=NORMSINV($B3NN((B) |
|
261. |
|
$BJ,I[!"I8=`@55,N_@QJ,I[4X?tCM(B |
=NORMSDIST(z) |
|
262. |
|
$BJ,I[!"Ii$NFs9`(B |
=NEGBINOMDIST($B<:GT?t(B,$B@.8y?t(B,$B@.8yN((B) |
|
263. |
|
$BJ,I[ODEY(B |
=SKEW($B?tCM(B1,$B?tCM(B2,...) |
|
264. |
|
$BJ,JQ49(B |
=MINUTE($B%7%j%"%kCM(B) |
|
265. |
$B$X(B |
$BJ?6QCM(B |
=DAVERAGE(Database,$B%U%#!<%k%I(B,Criteria) |
|
266. |
|
$BJ?6QCM(B |
=AVERAGE($B?tCM(B1,$B?tCM(B2,...) |
|
267. |
|
$BJ?6QCM!"O@M}CM$r4^$`(B |
=AVERAGEA($BCM(B1,$BCM(B2,...) |
|
268. |
|
$BJ?J}:,(B |
=SQRT($B?tCM(B) |
|
269. |
|
$BJP:9$NJ?J}OB(B |
=DEVSQ($B?tCM(B1,$B?tCM(B2,...) |
|
270. |
$B$[(B |
$BJl=8CD$NI8=`JP:9(B |
=DSTDEV(Database,$B%U%#!<%k%I(B,Criteria) |
|
271. |
|
$BJl=8CD$NI8=`JP:9(B |
=DSTDEVP(Database,$B%U%#!<%k%I(B,Criteria) |
|
272. |
|
$BJl=8CD$NI8K\$r;H$C$FI8=`JP:9(B |
=STDEV($B?tCM(B1,$B?tCM(B2,...) |
|
273. |
|
$BJl=8CD$NI8K\$r;H$C$FI8=`JP:9!"O@M}CM$r4^$`(B |
=STDEVA($BCM(B1,$BCM(B2,...) |
|
274. |
|
$BJl=8CD$NI8K\$r;H$C$FJ,;6(B |
=VAR($B?tCM(B1,$B?tCM(B2,...) |
|
275. |
|
$BJl=8CD$NI8K\$r;H$C$FJ,;6!"O@M}CM$r4^$`(B |
=VARA($BCM(B1,$BCM(B2,...) |
|
276. |
|
$BJl=8CD$NJ,;6(B |
=DVAR(Database,$B%U%#!<%k%I(B,Criteria) |
|
277. |
|
$BJl=8CD$NJ,;6(B |
=DVARP(Database,$B%U%#!<%k%I(B,Criteria) |
|
278. |
|
$BJl=8CD$NJ?6QCM$KBP$9$k?.Mj6h4V(B |
=CONFIDENCE($B&A(B,$BI8=`JP:9(B,$BI8K\?t(B) |
|
279. |
|
$BJl=8CDA4BN$rBP>]$KI8=`JP:9(B |
=STDEVP($B?tCM(B1,$B?tCM(B2,...) |
|
280. |
|
$BJl=8CDA4BN$rBP>]$KI8=`JP:9!"O@M}CM$r4^$`(B |
=STDEVPA($BCM(B1,$BCM(B2,...) |
|
281. |
|
$BJl=8CDA4BN$rBP>]$KJ,;6(B |
=VARP($B?tCM(B1,$B?tCM(B2,...) |
|
282. |
|
$BJl=8CDA4BN$rBP>]$KJ,;6!"O@M}CM$r4^$`(B |
=VARPA($BCM(B1,$BCM(B2,...) |
|
283. |
$B$^(B |
$BK~4|F|MxB);YJ'3[LL(B $100 $BEv$?$j2A3J(B |
=PRICEMAT($B |
|
284. |
|
$BK~4|F|MxB);YJ'Mx2s$j(B |
=YIELDMAT($B |
|
285. |
|
$BK~4|MxB)L$<}MxB)(Bz |
=ACCRINTM($BH/9TF|(B,$B |
|
286. |
$B$a(B |
$BL>L\G/MxN((B |
=NOMINAL($B |
|
287. |
$B$b(B |
$BJ8;z(BASCII $B$^$?$O(B JIS $B%3!<%IHV9fBP1~(B |
=CHAR($B?tCM(B) |
|
288. |
|
$BJ8;z%9%Z!<%9:o=|(B |
=TRIM($BJ8;zNs(B) |
|
289. |
|
$BJ8;z7+$jJV$7(B |
=REPT($BJ8;zNs(B,$B7+$jJV$72s?t(B) |
|
290. |
|
$BJ8;z8!:w(B |
=SEARCH($B8!:wJ8;zNs(B,$BBP>](B,$B3+;O0LCV(B) |
|
291. |
|
$BJ8;z8!:w!J%P%$%HC10L!K(B |
=SEARCHB($B8!:wJ8;zNs(B,$BBP>](B,$B3+;O0LCV(B) |
|
292. |
|
$BJ8;z?t(B |
=LEN($BJ8;zNs(B) |
|
293. |
|
$BJ8;z?t!J%P%$%HC10L!K(B |
=LENB($BJ8;zNs(B) |
|
294. |
|
$BJ8;zA43QJQ49(B |
=JIS($BJ8;zNs(B) |
|
295. |
|
$BJ8;zCV$-49$((B |
=REPLACE($BJ8;zNs(B,$B3+;O0LCV(B,$BJ8;z?t(B,$BCV49J8;zNs(B) |
|
296. |
|
$BJ8;zCV$-49$((B |
=SUBSTITUTE($BJ8;zNs(B,$B8!:wJ8;zNs(B,$BCV49J8;zNs(B,$BCV49BP>](B) |
|
297. |
|
$BJ8;zCV$-49$(!J%P%$%HC10L!K(B |
=REPLACEB($BJ8;zNs(B,$B3+;O0LCV(B,$B%P%$%H?t(B,$BCV49J8;zNs(B) |
|
298. |
|
$BJ8;zH>3QJQ49(B |
=ASC($BJ8;zNs(B) |
|
299. |
|
$BJ8;zJ8;z?tCMJQ49(B |
=VALUE($BJ8;zNs(B) |
|
300. |
|
$BJ8;zNs$,Ey$7$$$+$I$&$+$r%F%9%H(B |
=EXACT($BJ8;zNs(B1,$BJ8;zNs(B2) |
|
301. |
|
$BJ8;zNs$G$J$$$H$-(B TRUE |
=ISNONTEXT($B%F%9%H$NBP>](B) |
|
302. |
|
$BJ8;zNs$N$H$-(B TRUE |
=ISTEXT($B%F%9%H$NBP>](B) |
|
303. |
|
$BJ8;zNs7k9g(B |
=CONCATENATE($BJ8;zNs(B1,$BJ8;zNs(B2,...) |
|
304. |
|
$BJ8;zNs8!:w(B |
=FIND($B8!:wJ8;zNs(B,$BBP>](B,$B3+;O0LCV(B) |
|
305. |
|
$BJ8;zNs8!:w!J%P%$%HC10L!K(B |
=FINDB($B8!:wJ8;zNs(B,$BBP>](B,$B3+;O0LCV(B) |
|
306. |
|
$BJ8;zNs@hF,(B ($B:8C<(B) $B$+$i$NJ8;z(B |
=LEFT($BJ8;zNs(B,$BJ8;z?t(B) |
|
307. |
|
$BJ8;zNs@hF,(B ($B:8C<(B) $B$+$i$NJ8;z!J%P%$%HC10L!K(B |
=LEFTB($BJ8;zNs(B,$B%P%$%H?t(B) |
|
308. |
|
$BJ8;zNsG$0U0LCV$+$i;XDj$5$l$??t$NJ8;z(B |
=MID($BJ8;zNs(B,$B3+;O0LCV(B,$BJ8;z?t(B) |
|
309. |
|
$BJ8;zNsG$0U0LCV$+$i;XDj$5$l$??t$NJ8;z!J%P%$%HC10L!K(B |
=MIDB($BJ8;zNs(B,$B3+;O0LCV(B,$B%P%$%H?t(B) |
|
310. |
|
$BJ8;zNsJQ49(B |
=T($BCM(B) |
|
311. |
|
$BJ8;zNsJQ49%I%k=q<0;M |
=DOLLAR($B?tCM(B,$B7e?t(B) |
|
312. |
|
$BJ8;zNsJQ49=q<0@_Dj(B |
=TEXT($BCM(B,$BI=<(7A<0(B) |
|
313. |
|
$BJ8;zNsJQ49=q<0@_Dj;M |
=FIXED($B?tCM(B,$B7e?t(B,$B7e6h@Z$j(B) |
|
314. |
|
$BJ8;zNsKvHx(B ($B1&C<(B) $B;XDj?t$NJ8;z(B |
=RIGHT($BJ8;zNs(B,$BJ8;z?t(B) |
|
315. |
|
$BJ8;zNsKvHx(B ($B1&C<(B)$B;XDj?t$NJ8;z!J%P%$%HC10L!K(B |
=RIGHTB($BJ8;zNs(B,$B%P%$%H?t(B) |
|
316. |
$B$i(B |
$BMp?t(B |
= |
|
317. |
|
$BMp?t!"J,I[$9$k@0?t(B |
=RANDBETWEEN($B:G>.CM(B,$B:GBgCM(B) |
|
318. |
$B$j(B |
$BMx2s$j(B(TB) |
=TBILLYIELD($B |
|
319. |
|
$BMx2s$j(B1 $B4|L\F|?tH>C<(B |
=ODDFYIELD($B |
|
320. |
|
$BMx2s$j:G=*4|F|?tH>C<(B |
=ODDLYIELD($B |
|
321. |
|
$BMx2s$jAjEv(B (TB) |
=TBILLEQ($B |
|
322. |
|
$BMx;%4|F|?t(B |
=COUPDAYBS($B |
|
323. |
|
$BMx;%4|F|?t(B |
=COUPDAYS($B |
|
324. |
|
$BMxB);YJ'2s?t(B |
=COUPNUM($B |
|
325. |
|
$BMxB);YJ'F|(B |
=COUPPCD($B |
|
326. |
|
$BMxB);YJ'F|?t(B |
=COUPDAYSNC($B |
|
327. |
|
$BMxB);YJ'F|?tCM(B |
=COUPNCD($B |
|
328. |
|
$BMxB)Dj4|;YJ'Mx2s$j(B |
=YIELD($B |
|
329. |
|
$BNN0h8D?t(B |
=AREAS($BHO0O(B) |
|
330. |
$B$k(B |
$BN_@Q3NN(L)EY4X?t$N5U4X?tCM(B |
=BETAINV($B3NN((B,$B&A(B,$B&B(B,A,B) |
|
331. |
|
$BN_@Q3NN(L)EY4X?tCM(B |
=BETADIST(x,$B&A(B,$B&B(B,A,B) |
|
332. |
|
$BN_@QFs9`J,I[:G>.CM(B |
=CRITBINOM($B;n9T2s?t(B,$B@.8yN((B,$B&A(B) |
|
333. |
$B$l(B |
$BNs8!:w(B |
=VLOOKUP($B8!:wCM(B,$BHO0O(B,$BNsHV9f(B,$B8!:w$N7?(B) |
|
334. |
|
$BNs?t(B |
=COLUMNS($BG[Ns(B) |
|
335. |
|
$BNsHV9f(B |
=COLUMN($BHO0O(B) |
|
336. |
$B$m(B |
$BO@M}<0$N5U(B |
=NOT($BO@M}<0(B) |
|
337. |
|
$BO@M}<07W;;7k2LBP1~<0(B |
=IF($BO@M}<0(B,$B??$N>l9g(B,$B56$N>l9g(B) |
|
338. |
|
$BO@M}CM$N$H$-(B TRUE |
=ISLOGICAL($B%F%9%H$NBP>](B) |
|
339. |
$B$o(B |
$B3d$j;;$NM>$j(B |
=MOD($B?tCM(B,$B=|?t(B) |
|
340. |
|
$B3d0z:D3[LL(B $100$BEv$?$j2A3J(B |
=PRICEDISC($B |
|
341. |
|
$B3d0z:DG/Mx2s$j(B |
=YIELDDISC($B |
|
342. |
|
$B3d0zN((B |
=DISC($B |