excel中结果栏要求F6>D6,H6>J6结果才评定为合格,公式怎么编

2024-12-24 12:10:40
推荐回答(2个)
回答1:

=IF((F6>D6)*(H6>J6),"合格","不合格")

回答2:

=if((F6>D6)*(H6>J6),"合格","不合格")