<p>
[练习题]办公软件考大家的基本功:第四回
<br/></p><p>=if(sum(if(countif(c1:c8,0)>0,1,0),if(countif(c1:c8,1)>0,1,0),if(countif(c1:c8,2)>0,1,0),if(countif(c1:c8,3)>0,1,0),if(countif(c1:c8,4)>0,1,0),if(countif(c1:c8,5)>0,1,0),if(countif(c1:c8,6)>0,1,0),if(countif(c1:c8,7)>0,1,0),if(countif(c1:c8,8)>0,1,0),if(countif(c1:c8,9)>0,1,0))<=3,"提示","")</p><p>我的函数表达式太烦琐,有更简洁的吗???希望大家赐教</p>
[此贴子已经被作者于2008-8-13 14:24:47编辑过] |