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

dtxczjzmp

<p></p><p> TzvZIYgQ.zip (32.21 KB, 下载次数: 1)

2010-6-5 19:26 上传

点击文件名下载附件
02017上交作业 <br/></p><p><font color="#ff3300">作业5答案错误，某些公式冗余，参考下其他同学的正确答案</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;&nbsp;&nbsp;&nbsp;&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>

[此贴子已经被tkgg93于2010-6-11 21:00:58编辑过]

flash973

<p>先把必做的交了,再研究研究选做的~</p><p>&nbsp;</p><p> WlgRBg5p.rar (29.31 KB, 下载次数: 1)

2010-6-5 18:15 上传

点击文件名下载附件
【会计四期】第三讲上交作业贴（1-22号） <br/></p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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 color="#ff0000">&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font></p>

[此贴子已经被tkgg93于2010-6-11 21:05:54编辑过]

echolan

<p>1.=IF(COUNTIF(C4:F4,"&gt;60")=4,SUM(C4:F4)+30,IF(COUNTIF(C4:F4,"&gt;60")=3,SUM(C4:F4)+20,SUM(C4:F4)))；</p><p>2.=IF(C14*1=D14*1,"是","否");</p><p>3.=SUM(C22:C27,E22:E27,G22:G27);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font color="#0066ff">结果正确，公式可简化</font></p><p>4.1=SUMPRODUCT(($B$31:$B$44="BB")*($D$31:$D$44&gt;1)*$E$31:$E$44);</p><p>4.2{=SUMPRODUCT(($B$31:$B$44="BB")*($D$31:$D$44)*$E$31:$E$44)+SUMPRODUCT(($B$31:$B$44="CC")*($D$31:$D$44)*$E$31:$E$44)};&nbsp;&nbsp;&nbsp;&nbsp; <font color="#0033ff">不用数组公式</font></p><p>4.3{=SUMPRODUCT(($B$31:$B$44="AA")*($E$31:$E$44&gt;200))};&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font color="#0033ff">不用数组公式</font></p><p>5.=SUMIF(B51:B59,"??R*",C51:C59)+SUMIF(E51:E58,"??R*",F51:F58);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font color="#0066ff">结果正确，公式可简化</font></p><p>6.=COUNTIF(J3:J22,"&lt;-1")+COUNTIF(J3:J22,"&gt;5")-COUNTIF(J3:J22,"=9")</p><p>=SUMPRODUCT(($J$3:$J$22&lt;-1)*($J$3:$J$22))+SUMPRODUCT(($J$3:$J$22&gt;5)*($J$3:$J$22&lt;&gt;9)*$J$3:$J$22)</p><p>7.=COUNTIF(K26:K35,"*中学");</p><p>8.=SUM(VLOOKUP($K$41,$K$43:$L$48,2,0),VLOOKUP($K$41,$K$49:$L$54,2,0),VLOOKUP(K41,$K$56:$L$62,2,0),VLOOKUP($K$41,$K$63:$L$69,2,0));</p><p>选做题:</p><p>1.{=SUM(IF($C$3:$C$12&gt;80000,1000,500))}</p><p>2.=SUMPRODUCT(SUMIF($C$17:$C$31,$G$16:$I$16,D17)*$G$17:$I$17)</p><p>3.</p><p>4.=SUMIF($C$48:$N$48,$C$60,C49:N49)</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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 color="#ff3300">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;已做题目结果正确</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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font>&nbsp;</p><p></p><p>谢谢老师！</p>

[此贴子已经被tkgg93于2010-6-11 21:15:45编辑过]

zzjj1600

<p>第1题.=IF((C4&gt;60)*1+(D4&gt;60)*1+(E4&gt;60)*1+(F4&gt;60)*1=4,SUM(C4:F4)+30,IF((C4&gt;60)*1+(D4&gt;60)*1+(E4&gt;60)*1+(F4&gt;60)*1=3,SUM(C4:F4)+20,SUM(C4:F4)))<br/></p><p>第2题.=IF(C14*1=D14*1,"是","否")</p><p><br/>第3题.=SUM(C22:C27,E22:E27,G22:G27)</p><p>第4题.1.=SUMPRODUCT((B31:B44="BB")*(D31:D44&gt;1)*E31:E44)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.=SUMPRODUCT((B31:B44="BB")*D31:D44*E31:E44)+SUMPRODUCT((B31:B44="CC")*D31:D44*E31:E44)&nbsp;&nbsp;&nbsp;&nbsp; 3.=SUMPRODUCT((B31:B44="AA")*(E31:E44&gt;200))</p><p>第6题 1.=COUNTIF(J3:J22,"&lt;-1")+COUNTIF(J3:J22,"&gt;5")-COUNTIF(J3:J22,"=9")&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.=SUMIF(J3:J22,"&lt;-1",J3:J22)+SUMIF(J3:J22,"&gt;5",J3:J22)-SUMIF(J3:J22,"=9",J3:J22)</p><p>其它几题不会做</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#ff0000">&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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>

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

zhanglijun_1

<p><strong>02020:zhanglijun_1交作业</strong></p><p><span lang="EN-US"><font face="Times New Roman">1.=IF(COUNTIF(C4:F4,"&gt;60")=4,SUM(C4:F4)+30,IF(COUNTIF(C4:F4,"&gt;60")=3,SUM(C4:F4)+20,SUM(C4:F4)))</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 lang="EN-US"><p><span lang="EN-US"><font face="Times New Roman">2.=IF(C14*1=D14*1,"</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><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></span></p><p><span lang="EN-US"><font face="Times New Roman">2.=IF(C14*1=D14*1,"</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><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></p><p><span lang="EN-US"><font face="Times New Roman">2.=IF(C14*1=D14*1,"</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><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"><p><span lang="EN-US"><font face="Times New Roman">3.=SUM(C22:C27,E22:E27,G22:G27);</font></span></p></span></p><p><span lang="EN-US"><font face="Times New Roman">3.=SUM(C22:C27,E22:E27,G22:G27);</font></span></p><p></p><p><span lang="EN-US"><font face="Times New Roman">3.=SUM(C22:C27,E22:E27,G22:G27);</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><span lang="EN-US"><font face="Times New Roman">4.1=SUMPRODUCT(($B$31:$B$44="BB")*($D$31:$D$44&gt;1)*$E$31:$E$44);</font></span></p></span></p><p><span lang="EN-US"><font face="Times New Roman">4.1=SUMPRODUCT(($B$31:$B$44="BB")*($D$31:$D$44&gt;1)*$E$31:$E$44);</font></span></p><p></p><p><span lang="EN-US"><font face="Times New Roman">4.1=SUMPRODUCT(($B$31:$B$44="BB")*($D$31:$D$44&gt;1)*$E$31:$E$44);</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><span lang="EN-US"><font face="Times New Roman">4.2{=SUMPRODUCT(($B$31:$B$44="BB")*($D$31:$D$44)*$E$31:$E$44)+SUMPRODUCT(($B$31:$B$44="CC")*($D$31:$D$44)*$E$31:$E$44)};</font></span></p></span></p><p><span lang="EN-US"><font face="Times New Roman">4.2{=SUMPRODUCT(($B$31:$B$44="BB")*($D$31:$D$44)*$E$31:$E$44)+SUMPRODUCT(($B$31:$B$44="CC")*($D$31:$D$44)*$E$31:$E$44)};</font></span></p><p></p><p><span lang="EN-US"><font face="Times New Roman">4.2{=SUMPRODUCT(($B$31:$B$44="BB")*($D$31:$D$44)*$E$31:$E$44)+SUMPRODUCT(($B$31:$B$44="CC")*($D$31:$D$44)*$E$31:$E$44)};</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><span lang="EN-US"><font face="Times New Roman">4.3{=SUMPRODUCT(($B$31:$B$44="AA")*($E$31:$E$44&gt;200))};</font></span></p></span></p><p><span lang="EN-US"><font face="Times New Roman">4.3{=SUMPRODUCT(($B$31:$B$44="AA")*($E$31:$E$44&gt;200))};</font></span></p><p></p><p><span lang="EN-US"><font face="Times New Roman">4.3{=SUMPRODUCT(($B$31:$B$44="AA")*($E$31:$E$44&gt;200))};</font></span></p><p><span lang="EN-US"></span><span lang="EN-US"><font face="Times New Roman">5.=SUMIF(B51:B59,"??R*",C51:C59)+SUMIF(E51:E58,"??R*",F51:F58);</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><span lang="EN-US"><font face="Times New Roman">6.=COUNTIF(J3:J22,"&lt;-1")+COUNTIF(J3:J22,"&gt;5")-COUNTIF(J3:J22,"=9")</font></span></p></span></p><p><span lang="EN-US"><font face="Times New Roman">6.=COUNTIF(J3:J22,"&lt;-1")+COUNTIF(J3:J22,"&gt;5")-COUNTIF(J3:J22,"=9")</font></span></p><p></p><p><span lang="EN-US"><font face="Times New Roman">6.=COUNTIF(J3:J22,"&lt;-1")+COUNTIF(J3:J22,"&gt;5")-COUNTIF(J3:J22,"=9")</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><font face="Times New Roman">&nbsp;</font><span lang="EN-US"><font face="Times New Roman">=SUMPRODUCT(($J$3:$J$22&lt;-1)*($J$3:$J$22))+SUMPRODUCT(($J$3:$J$22&gt;5)*($J$3:$J$22&lt;&gt;9)*$J$3:$J$22)</font></span></p></span></p><p><font face="Times New Roman">&nbsp;</font><span lang="EN-US"><font face="Times New Roman">=SUMPRODUCT(($J$3:$J$22&lt;-1)*($J$3:$J$22))+SUMPRODUCT(($J$3:$J$22&gt;5)*($J$3:$J$22&lt;&gt;9)*$J$3:$J$22)</font></span></p><p></p><p><font face="Times New Roman">&nbsp;</font><span lang="EN-US"><font face="Times New Roman">=SUMPRODUCT(($J$3:$J$22&lt;-1)*($J$3:$J$22))+SUMPRODUCT(($J$3:$J$22&gt;5)*($J$3:$J$22&lt;&gt;9)*$J$3:$J$22)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><span lang="EN-US"><font face="Times New Roman">7.=COUNTIF(K26:K35,"*</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></span></p><p><span lang="EN-US"><font face="Times New Roman">7.=COUNTIF(K26:K35,"*</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></p><p><span lang="EN-US"><font face="Times New Roman">7.=COUNTIF(K26:K35,"*</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"><p><span lang="EN-US"><font face="Times New Roman">8.=SUM(VLOOKUP($K$41,$K$43:$L$48,2,0),VLOOKUP($K$41,$K$49:$L$54,2,0),VLOOKUP(K41,$K$56:$L$62,2,0),VLOOKUP($K$41,$K$63:$L$69,2,0));</font></span></p></span></p><p><span lang="EN-US"><font face="Times New Roman">8.=SUM(VLOOKUP($K$41,$K$43:$L$48,2,0),VLOOKUP($K$41,$K$49:$L$54,2,0),VLOOKUP(K41,$K$56:$L$62,2,0),VLOOKUP($K$41,$K$63:$L$69,2,0));</font></span></p><p></p><p><span lang="EN-US"><font face="Times New Roman">8.=SUM(VLOOKUP($K$41,$K$43:$L$48,2,0),VLOOKUP($K$41,$K$49:$L$54,2,0),VLOOKUP(K41,$K$56:$L$62,2,0),VLOOKUP($K$41,$K$63:$L$69,2,0));</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><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></span></p><p><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></p><p><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"><p><span lang="EN-US"><font face="Times New Roman">1.{=SUM(IF($C$3:$C$12&gt;80000,1000,500))}</font></span></p></span></p><p><span lang="EN-US"><font face="Times New Roman">1.{=SUM(IF($C$3:$C$12&gt;80000,1000,500))}</font></span></p><p></p><p><span lang="EN-US"><font face="Times New Roman">1.{=SUM(IF($C$3:$C$12&gt;80000,1000,500))}</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><span lang="EN-US"><font face="Times New Roman">2.=SUMPRODUCT(SUMIF($C$17:$C$31,$G$16:$I$16,D17)*$G$17:$I$17)</font></span></p></span></p><p><span lang="EN-US"><font face="Times New Roman">2.=SUMPRODUCT(SUMIF($C$17:$C$31,$G$16:$I$16,D17)*$G$17:$I$17)</font></span></p><p></p><p><span lang="EN-US"><font face="Times New Roman">2.=SUMPRODUCT(SUMIF($C$17:$C$31,$G$16:$I$16,D17)*$G$17:$I$17)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><span lang="EN-US"><font face="Times New Roman">3.</font></span></p></span></p><p><span lang="EN-US"><font face="Times New Roman">3.</font></span></p><p></p><p><span lang="EN-US"><font face="Times New Roman">3.</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><span lang="EN-US"><font face="Times New Roman">4.=SUMIF($C$48:$N$48,$C$60,C49:N49)</font></span></p></span></p><p><span lang="EN-US"><font face="Times New Roman">4.=SUMIF($C$48:$N$48,$C$60,C49:N49)</font></span></p><p></p><p><span lang="EN-US"><font face="Times New Roman">4.=SUMIF($C$48:$N$48,$C$60,C49:N49)</font></span></p><p><span lang="EN-US"><font face="Times New Roman" 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;&nbsp; 已阅</font></span></p><p><span lang="EN-US"><font face="Times New Roman" 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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font></span></p>

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

hnnyfcykl

01001交作业<p>必做题:<br/>1、=IF(COUNTIF(C4:F4,"&gt;60")=4,SUM(C4:F4)+30,IF(COUNTIF(C4:F4,"&gt;60")=3,SUM(C4:F4)+20,SUM(C4:F4))) <br/>2、=IF(C14*1=D14*1,"是","否")<br/>3、=SUM(C22:C27,E22:E27,G22:G27)<br/>4.1、=SUMPRODUCT(($B$31:$B$44="BB")*($D$31:$D$44&gt;1)*$E$31:$E$44)</p><p>&nbsp;4.2、={=SUMPRODUCT(($B$31:$B$44="BB")*($D$31:$D$44)*$E$31:$E$44)+SUMPRODUCT(($B$31:$B$44="CC")*($D$31:$D$44)*$E$31:$E$44)} <br/>4.3、={=SUMPRODUCT(($B$31:$B$44="AA")*($E$31:$E$44&gt;200))} <br/>5、=SUMIF(B51:B59,"??R*",C51:C59)+SUMIF(E51:E58,"??R*",F51:F58)<br/>6、=COUNTIF(J3:J22,"&lt;-1")+COUNTIF(J3:J22,"&gt;5")-COUNTIF(J3:J22,"=9")<br/>=SUMPRODUCT(($J$3:$J$22&lt;-1)*($J$3:$J$22))+SUMPRODUCT(($J$3:$J$22&gt;5)*($J$3:$J$22&lt;&gt;9)*$J$3:$J$22)<br/>7、=COUNTIF(K26:K35,"*中学");<br/>8、=SUM(VLOOKUP($K$41,$K$43:$L$48,2,0),VLOOKUP($K$41,$K$49:$L$54,2,0),VLOOKUP(K41,$K$56:$L$62,2,0),VLOOKUP($K$41,$K$63:$L$69,2,0));<br/>选做题:<br/>1、={=SUM(IF($C$3:$C$12&gt;80000,1000,500))}<br/>2、=SUMPRODUCT(SUMIF($C$17:$C$31,$G$16:$I$16,D17)*$G$17:$I$17)</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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 color="#ff3300">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 使用sumproduct函数时，可不使用数组公式</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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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>

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

missli2009

<p> 1GP2Y4qo.rar (29.49 KB, 下载次数: 1)

2010-6-6 16:13 上传

点击文件名下载附件
【会计四期】第三讲上交作业贴（1-22号） </p><p><font color="#ff0000">作业3公式复杂，作业8结果不对,有的公式太复杂</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;tkgg93</font><br/></p>

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

呐记忆

<p> 0wDkfb3F.rar (29.47 KB, 下载次数: 1)

2010-6-6 16:20 上传

点击文件名下载附件
【会计四期】第三讲上交作业贴（1-22号） </p><p><font color="#ff0000">&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font><br/></p>

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

wangxiangru

aaaaaa

wangxiangru

aaaaaa