【会计四期】第六讲上交作业贴（1-22号）

missli2009

[Power=1]<p> X2eVLTJd.rar (4.37 KB, 下载次数: 2)

2010-6-27 16:53 上传

点击文件名下载附件
【会计四期】第六讲上交作业贴（1-22号） <br/><font color="#ff3300">作业1正确</font></p><p><font color="#ff3300">作业2-1正确</font></p><p><font color="#ff3300">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font></p>[/Power]

[此贴子已经被tkgg93于2010-6-27 18:53:30编辑过]

missli2009

先交了再说，急死了[em03]

zzjj1600

[Power=1]<p> RG4A2lFT.rar (3.74 KB, 下载次数: 2)

2010-6-27 17:02 上传

点击文件名下载附件
【会计四期】第六讲上交作业贴（1-22号） </p><p><font color="#ff3300">作业1正确</font></p><p><font color="#ff3300">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93<br/></font></p>[/Power]

[此贴子已经被tkgg93于2010-6-27 17:29:21编辑过]

zhanglijun_1

[Power=1]<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p></p></span></p><p></p><p></p><p></p><p></p><span lang="EN-US"><font face="Times New Roman"><font face="Arial">1、</font>{=SUM(IF(ISNONTEXT(B5:B18),0,1))} <p></p></font></span><p></p><span lang="EN-US"><p></p></span><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman">{=SUM(IF(ISNONTEXT(B5:B18),0,1)*(C5:C18))/SUM(IF(ISNONTEXT(B5:B18),0,1))} <p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman">2</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">、</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';"></span><span lang="EN-US"><font face="Times New Roman">1){=SUM((DATEDIF(D26:D52,TODAY(),"y")&gt;=5)*(DATEDIF(D26:D52,TODAY(),"y")&lt;=10))} <p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman">2)=VLOOKUP(MAX(D26:D52),IF({1,0},D26:D52,C26:C52),2,) <p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman">3)=MODE(YEAR(D26:D52)) <p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman">4)=DATEDIF(VLOOKUP("</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">欧阳</span><span lang="EN-US"><font face="Times New Roman">",C26:D52,2,),TODAY(),"d")&amp;"</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">天</span><span lang="EN-US"><font face="Times New Roman">"</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman"></font></span>&nbsp;</p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman" color="#ff0000">已做题目正确</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman" color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font></span></p>[/Power]

[此贴子已经被tkgg93于2010-6-27 19:00:19编辑过]