iF(FIND("校区",REPLACE($$$,"咨询部",""))!=0||FIND("全日制",REPLACE($$$,"咨询部",""))!=0||FIND("华阳",REPLACE($$$,"咨询部",""))!=0||FIND("全日制",REPLACE($$$,"教务部",""))!=0||FIND("华阳",REPLACE($$$,"教务部",""))!=0,REPLACE($$$,"教务部",""),"其他")我是这样写的,但是只能去掉教务部,去不了咨询部,还有一个问题是规划业绩里面统计过一次其他了,学管那就不用统计那个业绩了,我设置过滤条件不包含其他之后,那个公式就不管用了,年度规划业绩.cpt