Question

excel 表格 F2>=E2同时I2>=G2,C2*100; F2<E2同时I2<G2，C2*50; F2>=E2同时I2<G2或 F2<E2同时I2>=G2，C2*50

Answer 1

公式如下：
=IF(AND(F2>=E2,I2>=G2),C2*100,IF(AND(F2<E2,I2<G2),C2*50,IF(OR(AND(F2>=E2,I2<G2),AND(F2<E2,I2>=G2)),C2*50)))

Answer 2

=IF(F2>=E2,IF(I2>=G2,C2*100,C2*50),C2*50)