来自韩曾晋的问题
【谁有办法帮我简化这个公式=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)))
公式太长无法定义名称,哪位高手帮我简化一下或者怎么样能定义成功
1回答
2020-09-24 22:01