如何使用excel函数将符合多个条件的客户筛选出来,标上星级?具体见附件...答:在D2中输入如下公式 =if(and(c2>=30%,c2<90%,b2>=60000),"一星客户",if(or(and(c2>=50%,c2<90%,b2>=100000,b2<200000),and(c2>=90%,b2>=80000,b2<100000)),"二星客户",if(or(and(c2>=50%,c2<90%,b2>=200000),and(c2>=90%,b2>=100000)),"三星客户","")))下拉填充...