谁有办法帮我简化这个公式=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
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/06 17:41:56
![谁有办法帮我简化这个公式=IF(AND(RIGHT(B4,1)=](/uploads/image/z/1991028-12-8.jpg?t=%E8%B0%81%E6%9C%89%E5%8A%9E%E6%B3%95%E5%B8%AE%E6%88%91%E7%AE%80%E5%8C%96%E8%BF%99%E4%B8%AA%E5%85%AC%E5%BC%8F%3DIF%28AND%28RIGHT%28B4%2C1%29%3D%221%22%2C%28%24AB%242%2B%24AD%242%2B%24AE%242%2B%24AC%242-%28AB4%2BAD4%2BAE4%2BAC4%2BAI4%2A0.6%29%29%3E%3D64%29%2CS4%2A%28AB4%2BAD4%2BAE4%2BAC4%2BAI4%2A0.6%29%2F%28%24AB%242%2B%24AD%242%2B%24AE%242%2B%24AC%242%29%2CIF%28AND%28RIGHT%28B4%2C1%29%3D%220%22%2C%28%24AB%241%2B%24AD%241%2B%24AE%241%2B%24AC%241-%28AB4%2BAD4%2BAE4%2BAC4%2BAI4%2A0.6%29%29%3E%3D64)
谁有办法帮我简化这个公式=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)))