数组兴趣小组练习题-006期

杨副官

<p>首先我向大家道谦，近段时间工作比较忙，好久没有上论坛，竟忘了上传讨论题目了，还望大家原谅。我出的这期题比较简单，实际工中也经常用到。</p><p><br/></p>

[此贴子已经被作者于2007-6-7 19:39:27编辑过]

时间

先占个位.再做做.

飞雨飘

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>xhsdham</i>在2007-6-7 22:40:00的发言：</b><br/>=FREQUENCY((YEAR(NOW())*10+MONTH(NOW()))-(YEAR(B2:B12)*10+MONTH(B2:B12)),{300,180})</div><p></p><p>可否用这个？</p><p>=FREQUENCY(DATEDIF(B2:B12,NOW(),"y")+DATEDIF(B2:B12,NOW(),"ym")/10,{30,18})</p>

laoyebin

<p>和流星学的</p><p>=FREQUENCY(DATEDIF(B2:B12,NOW(),"Y"),{30,18})</p>

aaa4461

=SUMPRODUCT((DATEDIF($B$2:$B$12,TODAY(),"y")&gt;=18)*(DATEDIF($B$2:$B$12,TODAY(),"y")&lt;=30))

时间

52个金币了,好象我是最少的.

xhsdham

<p>=SUM(IF((YEAR(NOW())*10+MONTH(NOW()))-(YEAR(B2:B12)*10+MONTH(B2:B12))&gt;180,1,0)*IF((YEAR(NOW())*10+MONTH(NOW()))-(YEAR(B2:B12)*10+MONTH(B2:B12))&lt;=300,1,0))</p><p>偶写的太长了 好难看</p>

[此贴子已经被作者于2007-6-7 22:58:47编辑过]

xhsdham

=FREQUENCY((YEAR(NOW())*10+MONTH(NOW()))-(YEAR(B2:B12)*10+MONTH(B2:B12)),{300,180})

jqx

请问这新手要从哪先学起?

xhsdham

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>xhsdham</i>在2007-6-7 22:40:00的发言：</b><br/>=FREQUENCY((YEAR(NOW())*10+MONTH(NOW()))-(YEAR(B2:B12)*10+MONTH(B2:B12)),{300,180})</div>{300,180} 不用 + 或 - &nbsp;0.001了吧 这种情况应该是正好吧