数组兴趣小组练习题-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>
<p>和流星学的</p><p>=FREQUENCY(DATEDIF(B2:B12,NOW(),"Y"),{30,18})</p>
=SUMPRODUCT((DATEDIF($B$2:$B$12,TODAY(),"y")>=18)*(DATEDIF($B$2:$B$12,TODAY(),"y")<=30))
52个金币了,好象我是最少的.
<p>=SUM(IF((YEAR(NOW())*10+MONTH(NOW()))-(YEAR(B2:B12)*10+MONTH(B2:B12))>180,1,0)*IF((YEAR(NOW())*10+MONTH(NOW()))-(YEAR(B2:B12)*10+MONTH(B2:B12))<=300,1,0))</p><p>偶写的太长了 好难看</p>
[此贴子已经被作者于2007-6-7 22:58:47编辑过]
=FREQUENCY((YEAR(NOW())*10+MONTH(NOW()))-(YEAR(B2:B12)*10+MONTH(B2:B12)),{300,180})
请问这新手要从哪先学起?
<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} 不用 + 或 - 0.001了吧 这种情况应该是正好吧
页:
[1]
2