IF函数,多个条件,返回值只有两种,该怎样设置?

2025-03-23 23:13:49
推荐回答(1个)
回答1:

IF嵌套使用或者使用OR,例如:
IF(OR (H3="普票",H3="机打票",H3="手工票",H3="收据",H3="送货单",H3="快丝库",H3="慢丝库",H3="天业库"),G3,IF(H3="专票",H3="领料单",G3/(1+I3),"H3内容错误!"))