Excel如何跳过空值计算IF函数?

2025-04-05 22:41:41
推荐回答(1个)
回答1:

=IF(AND(OR(D16+E16>=G16,G16=""),OR(D16+F16<=G16,G16=""),OR(D16+E16>=H16,H16=""),OR(D16+F16<=H16,H16=""),OR(D16+E16>=I16,I16=""),OR(D16+F16<=I16,I16=""),OR(D16+E16>=J16,J16=""),OR(D16+F16<=J16,J16=""),OR(D16+E16>=K16,K16=""),OR(D16+F16<=K16,K16="")),"OK","NG")