其实就是多条件判断，如1：A>0，B=if(and(A>0,B<0,A=if(and(A>0,b<=ABS(C)-D),"OK",if(and(A<0,B=0),"OK","NO")你把ABCD替换为对应单元格编号即可，谢谢！
