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

無心

<p><font size="5">请大家使用威望帖交作业，不要用回复可见，如果没交正确，可以重复编辑，不要重复发贴。</font></p><p><font color="#000000" size="5"><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=129699" target="_blank">威望帖的发帖方法</a></font></p><p>&nbsp;<font size="3"><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: tahoma;">
                                <p><strong></strong></p></span></font></p><p><strong></strong></p><p></p><p><strong></strong></p><p></p><p><strong></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p><strong><font color="#3300ff"></font></strong></p><p style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><span><strong><font color="#3300ff">1、<font color="#ff0066">非本班成员严禁回复</font>，一经发现按抄袭论处，删贴扣币币；</font></strong></span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: tahoma;"><strong><font color="#3300ff">
                                        </font></strong><p><strong><font color="#3300ff"></font></strong></p></span></font></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p><strong><font color="#3300ff"></font></strong></p><p style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><span><strong><font color="#3300ff">2、作业上交截止时间为<font color="#ff0066">本周日下午17点</font>；</font></strong></span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: tahoma;"><strong><font color="#3300ff">
                                        </font></strong><p><strong><font color="#3300ff"></font></strong></p></span></font></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p><strong><font color="#3300ff"></font></strong></p><p style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><span><strong><font color="#3300ff">3、<font color="#ff0066">交白卷的视为未交作业</font>；</font></strong></span><span lang="EN-US" style="COLOR: #ff6600; FONT-FAMILY: tahoma;"><strong><font color="#3300ff">
                                        </font></strong><p><strong><font color="#3300ff"></font></strong></p></span></font></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p><strong><font color="#3300ff"></font></strong></p><p style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><strong><font color="#3300ff"><font size="3"><span>4、上交好<font color="#ff0066">作业后再投票</font>(非本组成员严禁投票)。</span></font><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: tahoma;">
                                </span></font></strong></p><p><strong></strong></p>

林玲玲

[Power=1]<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">一：</span><span lang="EN-US"><font face="Calibri">=</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">｛</span><span lang="EN-US"><font face="Calibri">SUM(--ISTEXT(B5:B18))</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">｝；</span><span lang="EN-US"><font face="Calibri">=SUM(ISTEXT(B5:B18)*C5:C18)/D20&nbsp;&nbsp; </font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">二：</span><span lang="EN-US"><font face="Calibri">1</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">、｛</span><span lang="EN-US"><font face="Calibri">=SUM(--(DATEDIF(D26:D52,TODAY(),"Y")&gt;=5)*--(DATEDIF(D26:D52,TODAY(),"Y")&lt;=10))</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">｝</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 20.25pt;"><span lang="EN-US"><font face="Calibri">2</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">、</span><span lang="EN-US"><font face="Calibri">=VLOOKUP(MAX(D26:D52),IF({1,0},D26:D52,C26:C52),2,)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 20.25pt;"><span lang="EN-US"><font face="Calibri">3</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">、</span><span lang="EN-US"><font face="Calibri">=MODE(YEAR(D26:D52))</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 20.25pt;"><span lang="EN-US"><font face="Calibri">4</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">、</span><span lang="EN-US"><font face="Calibri">=DATEDIF(VLOOKUP("</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">欧阳</span><span lang="EN-US"><font face="Calibri">",C26:D52,2,),TODAY(),"Y")</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 20.25pt;"><span lang="EN-US"><font face="Calibri">5</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">、</span><span lang="EN-US"><font face="Calibri">=IF(DATEDIF(D26,TODAY(),"Y")=0,"</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">今年未到</span><span lang="EN-US"><font face="Calibri">",IF(DATEDIF(D26,TODAY(),"Y")&lt;5,3,6))&nbsp;&nbsp;&nbsp; <font color="#0033ff">与题目要求不符</font></font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6、{=SUM(--(DATE(2010,MONTH(D26:D52),DAY(D26:D52))&lt;TODAY())*(--(DATEDIF(D26:D52,TODAY(),"Y")&gt;0)))}&nbsp;&nbsp;&nbsp; </font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri" color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 基本正确</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri" color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font></span></p><p></p><p>&nbsp;&nbsp;&nbsp;&nbsp; 5、=IF(AND((DATE(2010,MONTH(D26),DAY(D26))&gt;TODAY()),DATEDIF(D26,TODAY(),"Y")&gt;0),"今年未到",IF(DATEDIF(D26,TODAY(),"Y")=0,"没有年假",IF(DATEDIF(D26,TODAY(),"Y")&lt;5,3,6)))是这样吗</p>[/Power]

[此贴子已经被無心于2010-6-23 22:51:28编辑过]

lgfcl1

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

2010-6-22 21:39 上传

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

[此贴子已经被tkgg93于2010-6-23 11:35:16编辑过]

yuang68

[Power=1]<p>第一　=SUMPRODUCT(ISTEXT(B5:B18)*(C5:C18))/SUMPRODUCT(ISTEXT(B5:B18)*1)</p><p>第二　1　　=SUM((DATEDIF(D26:D52,TODAY(),"y")&gt;=5)*(DATEDIF(D26:D52,TODAY(),"y")&lt;10))数组公式</p><p>　　　2=OFFSET(C25,MATCH(MAX(D26:D52),D26:D52,0),0)</p><p>　　　3=MODE(YEAR(D26:D52))</p><p>　　　4=DATEDIF(VLOOKUP("欧阳",C26:D52,2,0),TODAY(),"Y")&amp;"年"&amp;DATEDIF(VLOOKUP("欧阳",C26:D52,2,0),TODAY(),"YM")&amp;"月又"&amp;DATEDIF(VLOOKUP("欧阳",C26:D52,2,0),TODAY(),"Md")&amp;"天"</p><p>　　　5=IF(DATEDIF(D26,TODAY(),"y")&lt;1,"无",IF(DATEDIF(D26,TODAY(),"yd")&gt;TODAY()-DATE(YEAR(TODAY()),1,1),"今年未到",IF(DATEDIF(D26,TODAY(),"y")&lt;5,3,6)))</p><p>　　　6=SUMPRODUCT((DATEDIF(D26:D52,TODAY(),"yd")&lt;TODAY()-DATE(YEAR(TODAY()),1,1))*(DATEDIF(D26:D52,TODAY(),"y")&gt;=1))&nbsp;&nbsp;&nbsp; </p><p><font color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 少做了第1题的第1小题,其它正确</font></p><p><font color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;tkgg93</font></p>[/Power]

[此贴子已经被tkgg93于2010-6-24 7:49:45编辑过]

穿拖鞋乱舞

[Power=2]<p>&nbsp; swMV9y5K.rar (49.66 KB, 下载次数: 1)

2010-6-24 16:50 上传

点击文件名下载附件
【会计四期】第六讲上交作业贴（1-22号） 第五题折腾好半天&nbsp;<!--Element not supported - Type: 8 Name: #comment--><br/><font color="#ff0000">作业1-2，不得借助辅助区域，可使用求平均值的函数</font></p><p><font color="#ff0000">作业2-6，不得借助辅助区域，结果不对，其它题目正确</font></p><p><font color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font></p>[/Power]

[此贴子已经被tkgg93于2010-6-25 8:17:08编辑过]

jiangming

[Power=1]<p>02019</p><p> vkvsPLP3.rar (4.24 KB, 下载次数: 2)

2010-6-24 23:46 上传

点击文件名下载附件
【会计四期】第六讲上交作业贴（1-22号） </p><p><font color="#ff0000">第2题</font></p><p><font color="#ff0000">2小题未使用平均值公式，借助了辅助单元格</font></p><p><font color="#ff0000">5-6小题与参考答案不相符</font></p><p><font color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font></p>[/Power]

[此贴子已经被tkgg93于2010-6-25 8:09:53编辑过]

flash973

[Power=1]<p> Fy7XjI7U.zip (4.59 KB, 下载次数: 2)

2010-6-25 19:01 上传

点击文件名下载附件
【会计四期】第六讲上交作业贴（1-22号） <br/></p><p></p><p>还有些没弄懂,回头再看视频把不会做的作业补上~</p><p><font color="#ff0000">作业1是两问，B列数据中多少文本数据这问没答</font></p><p><font color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 第2问未要求使用辅助列公式</font></p><p><font color="#ff0000">作业2 -1 好像没有要求使用辅助列</font></p><p><font color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2-4 好像问参加工作多长时间，没有答多少天的</font></p><p><font color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2-5 与参考答案不相符</font></p><p><font color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 再努力</font></p><p><font color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font></p><p>&nbsp;</p>[/Power]

[此贴子已经被tkgg93于2010-6-26 9:01:16编辑过]

echolan

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

2010-6-26 13:50 上传

点击文件名下载附件
【会计四期】第六讲上交作业贴（1-22号） <br/></p><p>谢谢老师！</p><p><font color="#ff0000">作业1-2 B列文本数据所对应C列数值的平均值公式错误</font></p><p><font color="#ff0000">作业2-5，2-6与图示不符</font></p><p><font color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font></p>[/Power]

[此贴子已经被tkgg93于2010-6-26 17:19:41编辑过]

dtxczjzmp

[Power=1]<p> tz36UiGG.zip (5.29 KB, 下载次数: 1)

2010-6-27 01:15 上传

点击文件名下载附件
【会计四期】第六讲上交作业贴（1-22号） </p><p><font color="#ff0000">作业1-2 结果正确，公式复杂</font></p><p><font color="#ff0000">作业2-1 结果错误</font></p><p><font color="#ff0000">作业2-2 使用普通公式就可以</font></p><p><font color="#ff0000">作业2-4 结果正确，公式错误</font></p><p><font color="#ff0000">作业2-5&nbsp; 与参考答案不相符</font></p><p><font color="#ff0000">作业2-6 与参考答案不相符</font></p><p><font color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font><br/></p>[/Power]

[此贴子已经被tkgg93于2010-6-27 8:02:41编辑过]

hnnyfcykl

[Power=1]<p>01001 hnnyfcykl mkUeb6uI.rar (4 KB, 下载次数: 1)

2010-6-27 16:11 上传

点击文件名下载附件
【会计四期】第六讲上交作业贴（1-22号） <br/>1、<br/>B列数据中的文本数据、<br/>{=SUM(IF(ISNONTEXT(B5:B18),0,1))}<br/>C列数值的平均值是、<br/>{=SUM(IF(ISNONTEXT(B5:B18),0,1)*(C5:C18))/SUM(IF(ISNONTEXT(B5:B18),0,1))}<br/>2、<br/>年假=IF(AND(DATEDIF(D26,TODAY(),"y")&lt;1,YEAR(D26)=YEAR(TODAY())),"今年未到",IF(AND(DATEDIF(D26,TODAY(),"y")&gt;=1,DATEDIF(D26,TODAY(),"y")&lt;5),3,IF(DATEDIF(D26,TODAY(),"y")&gt;=5,6,0)))下拉<br/>1)、{=SUM((DATEDIF(D26:D52,TODAY(),"y")&gt;=5)*(DATEDIF(D26:D52,TODAY(),"y")&lt;=10))}<br/>2)、=VLOOKUP(MAX(D26:D52),IF({1,0},D26:D52,C26:C52),2,)<br/>3)、=MODE(YEAR(D26:D52))<br/>4)、=DATEDIF(VLOOKUP("欧阳",C26:D52,2,),TODAY(),"d")&amp;"天"<br/>6)、{=SUM(--(MONTH(D26:D52)=12))}</p><p><font color="#ff3300">作业2-5，2-6与参考答案不相符</font></p><p><font color="#ff3300">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font><br/></p>[/Power]

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