</p><p>1.=SUMIF($B$3:$B$10,"A*",$C$3:$C$10)</p><p>2.=SUM(COUNTIF(B3:B10,{"A*","B*"}))<strong><font color="#ff0000">.未理解题意</font></strong></p><p>3.=IF(B1>A2,B1,A2),FALSE)<strong><font color="#ff0000">.再看一下.</font></strong></p><p>4.=IF(B13=2500,B13*0.10,IF(B13=4000,B13*0.15,IFB13=7000,B13*0.2,IF(B13=22000,B13*0.25,IF(B13=42000,B13*0.30,IF(B13=62000,B13*0.35,IF(B13=82000,B13*0.40,IF(B13=102000,B13*0.45)<strong><font color="#ff0000">.未理解个调税的算法</font></strong></p><p>[/hide]</p><p><strong><font color="#ff0000">.未用回复贴,违规</font></strong></p>
[此贴子已经被pureshadow于2008-4-24 14:41:53编辑过] |