F4 =(((B4-2)⼀C4)⼀D4)⼀E4 B4为固定的数值,如果在C4输入2时运算=(((B4-2)⼀C4)⼀D4)⼀E4

2024-12-14 20:47:53
推荐回答(2个)
回答1:

F4 =(B4-sum(c4:e4))/(IF(C4=0,1,C4)*IF(D4=0,1,D4)*IF(E4=0,1,E4))

回答2:

=$B$4/SUM(C4:E4)-1