发布时间:2019-08-01 06:12:11
当E56=n/a时,H57=n/a;当E56=3时,如果C58>E56,E58>E56,F58>E56,G58>E56),H57=OK,否则H57=NG这函数如何在单元格体现
H57公式
=IF(E56="n/a","n/a",IF(AND(E56=3,C58>E56,E58>E56,F58>E56,G58>E56),"OK","NG"))