IF条件公式合并

当A1=4时 IF(AND(B3>60,B3<=65),10,IF(AND(B3=60),0,IF(AND(B3>65),20,IF(AND(55<=B3,B3<60),-10,IF(AND(B3<55),-20)))))
当A1<4时IF(AND(B4>60,B4<=65),20,IF(AND(B4=60),10,IF(AND(B4>65),40,IF(AND(55<=B4,B4<60),-10,IF(AND(B4<55),-20)))))
460,B5<=65),-10,IF(AND(B5=60),-20,IF(AND(B5>65),20,IF(AND(55<=B5,B5<60),-20,IF(AND(B5<55),-30)))))
当A1>4.5时 IF(AND(B6>=65),-10,IF(AND(B6<65,B6>60),-20,IF(AND(B6<=60),-30,)))

如何将这四组公式合并成一个公式？

=IF(AND(B1=60,A1=4),0,IF(AND(B1>65,A1<4),40,IF(OR(AND(B1>60,B1<=65,A1=4),AND(B1=60,A1<4)),10,IF(OR(AND(B1>65,A1=4),AND(B1>60,B1<=65,A1<4),AND(B1>65,A1>4,A1<4.5)),20,IF(OR(AND(B1<55,A1>4,A1<4.5),AND(B1<=60,A1>4.5)),-30,IF(OR(AND(55<=B1,B1<60,A1=4),AND(55<=B1,B1<60,A1<4),AND(B1>60,B1<=65,A1>4,A1<4.5),AND(B1>=65,A1>4.5)),-10,-20))))))

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息