谁有办法帮我简化这个公式=IF(AND(RIGHT(B4,1)="1",($AB$2+$AD$2+$AE$2+$AC$2-(AB4+AD4+AE4+AC4+AI4*0.6))>=64),S4*(AB4+AD4+AE4+AC4+AI4*0.6)/($AB$2+$AD$2+$AE$2+$AC$2),IF(AND(RIGHT(B4,1)="0",($AB$1+$AD$1+$AE$1+$AC$1-(AB4+AD4+AE4+AC4+AI4*0.6))>=64

谁有办法帮我简化这个公式=IF(AND(RIGHT(B4,1)="1",($AB$2+$AD$2+$AE$2+$AC$2-(AB4+AD4+AE4+AC4+AI4*0.6))>=64),S4*(AB4+AD4+AE4+AC4+AI4*0.6)/($AB$2+$AD$2+$AE$2+$AC$2),IF(AND(RIGHT(B4,1)="0",($AB$1+$AD$1+$AE$1+$AC$1-(AB4+AD4+AE4+AC4+AI4*0.6))>=64
谁有办法帮我简化这个公式
=IF(AND(RIGHT(B4,1)="1",($AB$2+$AD$2+$AE$2+$AC$2-(AB4+AD4+AE4+AC4+AI4*0.6))>=64),S4*(AB4+AD4+AE4+AC4+AI4*0.6)/($AB$2+$AD$2+$AE$2+$AC$2),
IF(AND(RIGHT(B4,1)="0",($AB$1+$AD$1+$AE$1+$AC$1-(AB4+AD4+AE4+AC4+AI4*0.6))>=64),S4*(AB4+AD4+AE4+AC4+AI4*0.6)/($AB$1+$AD$1+$AE$1+$AC$1),
IF(RIGHT(B4,1)="2",0,S4)))
公式太长无法定义名称,哪位高手帮我简化一下或者怎么样能定义成功

谁有办法帮我简化这个公式=IF(AND(RIGHT(B4,1)="1",($AB$2+$AD$2+$AE$2+$AC$2-(AB4+AD4+AE4+AC4+AI4*0.6))>=64),S4*(AB4+AD4+AE4+AC4+AI4*0.6)/($AB$2+$AD$2+$AE$2+$AC$2),IF(AND(RIGHT(B4,1)="0",($AB$1+$AD$1+$AE$1+$AC$1-(AB4+AD4+AE4+AC4+AI4*0.6))>=64
=IF(AND(RIGHT(B4,1)="1",(sum($AB$2:$AE$2)-(sum(AB4:AE4)+AI4*0.6))>=64),S4*(sum(AB4:AE4)+AI4*0.6)/(sum($AB$2:$AE$2)),
IF(AND(RIGHT(B4,1)="0",(sum($AB$1:$AE$1)-(sum(AB4:AE4)+AI4*0.6))>=64),S4*(sum(AB4:AE4)+AI4*0.6)/(sum($AB$1:$AE$1),
IF(RIGHT(B4,1)="2",0,S4)))