<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>reciprocal</i>在2009-10-23 11:59:00的发言:</b><br/>昨天函入第二讲老师给的课件,if实例2工作表中的,我不用“+”也能得到同样的结果呀,而“&”根本就用不了,一用就出错呢。</div><p>没错,不用也能得到结果,</p><p>只是提供这么一种方式</p><p>&连接要用也是可以的.看你怎么运用了</p><p>以下就是使用&将结果运算出来的公式,可供揣摩!</p><p>=VALUE(IF(B3<10000,1%,"")&IF(AND(B3<20000,B3>=10000),2%,"")&IF(AND(B3<30000,B3>=20000),3%,"")&IF(AND(B3<40000,B3>=30000),4%,"")&IF(AND(B3<50000,B3>=40000),5%,"")&IF(AND(B3<60000,B3>=50000),6%,"")&IF(AND(B3<70000,B3>=60000),7%,"")&IF(AND(B3<80000,B3>=70000),8%,"")&IF(B3>80000,9%,""))*B3</p>
[此贴子已经被作者于2009-10-23 12:29:02编辑过] |