【谁有办法帮我简化这个公式=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)))

　　公式太长无法定义名称,哪位高手帮我简化一下或者怎么样能定义成功