EXCEL函数问题?

来源：百度知道编辑：UC知道时间：2024/05/15 01:19:21

=IF(OR(AND(B33>15,B34>15,B35>15,B36>15,B37>15,B38>15),AND(B33<9,B34<9,B35<9,B36<9,B37<9,B38<9)),"NG","OK").如果数据越多,那我的这个公式其不是更长,有没有简便点的方法啊

=IF(OR(MIN(B33:B38)>15,MAX(B33:B38)<9),"NG","OK")

=IF(OR(AND(B33:B38>15),AND(B33:B38<19)),"NG","OK")
之后按ctrl＋shfit＋回车

条件越多，公式自然越长，没得办法！

=IF(OR(AND(B1:B5>15),AND(B1:B5<9)),"NG","OK")
按ctrl＋shfit＋回车

可以使用条件格式的