IF(AND(MOD(A1,0.05)=0,MOD(B1,0.05)=0),0,C1*0.1)但是怎么算,都搞不到0,都是C1*0.1,是怎么回事?
MODåªå¯¹æ´æ°è¿ç®ï¼å ¬å¼æ¹ä¸ºï¼
=IF(AND(MOD(A1*100,5)=0,MOD(B1*100,5)=0),0,C1*0.1)
å¦ä¸å¾ï¼