EXCEL2013里判断多个单元格同时符合不同条件返回yes或者no,忽略空值!

2024-11-01 00:24:25
有2个网友回答
网友(1):

多加一个条件:IF(M6=N6="",IF(AND(H6>=84,H6<=86,I6>=84,I6<=86,J6>=84,J6<=86,K6<=83,K6>=81,L6<=83,L6>=81,M6<=83,M6>=81,N6>=81,N6<=83,O6>=90,O6<=92),"OK","NO"),"")

网友(2):

把M6>0 N6>6
添加到AND里