=IF(AND(F2=1,G2<20),4*1+(G2-1)*1,IF(AND(F2=1,G2>=20),G2*1,IF(AND(F2=2,G2<20),5*1+(G2-1)*2.5,IF(AND(F2=2,G2>=20),G2*2.5,IF(AND(F2=3,G2<20),5*1+(G2-1)*3,IF(AND(F2=3,G2>=20),G2*3,IF(AND(F2=4,G2<20),5*1+(G2-1)*3,IF(AND(F2=4,G2>=20),G2*3,0))))))。这个公式错误,超出允许值,帮忙改下 |