如果是OR [英] IF with OR
本文介绍了如果是OR的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我可以使用OR中的几个不同的术语来应用IF函数相同的等式。
解决方案
是,例如:
= IF(或(A1< 5,A1> 10),"this","that")
或
= IF(OR(B1 = "white",B1 ="green",B1 ="blue","yes","no",
后者也可以写成
= IF(OR(B1 = {"白色","绿色","蓝色"}),"是","否")
Can I apply IF function with OR using several different terms in the same equation.
解决方案
Yes, for example:
=IF(OR(A1<5,A1>10),"this","that")
or
=IF(OR(B1="white",B1="green",B1="blue"),"yes","no")
The latter can also be written as
=IF(OR(B1={"white","green","blue"}),"yes","no")
这篇关于如果是OR的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文