如果A1=1,2,3,那么c1=b1*0.3(且值大于等于30,要四舍五入后的整数),如果a1=4,5,6,那么c1=b1*0.2(值大于等于50,且为四舍五入的整数)
是不是这样? C1=IF(OR(A1={1,2,3}),MAX(ROUNDUP(B1*0.3,),30),IF(OR(A1={4,5,6}),MAX(ROUNDUP(B1*0.2,),50),""))
C1公式应为“=IF(AND(OR(A1={1,2,3}),ROUNDUP(B1*0.3,0)>=30),ROUNDUP(B1*0.3,0),IF(AND(OR(A1={4,5,6}),ROUNDUP(B1*0.2,0)>=50),ROUNDUP(B1*0.2,0),""))”。
C1 =IF(AND(OR(A1=1,A1=2,A1=3),ROUND(B1*0.3,0)>=30),ROUND(B1*0.3,0),IF(AND(OR(A1=4,A1=5,A1=6),ROUND(B1*0.2,0)>=50),ROUND(B1*0.2,0),"不符合条件"))