*,+可以是算术运算符,也可以是逻辑运算符。*相当与AND,+相当于OR。使用方法是:逻辑量*逻辑量,逻辑量+逻辑量比如:=IF((A1>10)*(A1<100),"OK","NO")=IF((A1>10)+(A1<>50),"OK","NO")AND,OR是逻辑函数。使用方法是:AND(逻辑量,逻辑量,逻辑量,……),OR(逻辑量,逻辑量,逻辑量,……)比如:=IF(AND(A1>10,A1<100),"OK","NO")=IF(OR(A1>10,A1<>50),"OK","NO")
*,+可以是算术运算符,也可以是逻辑运算符。*相当与AND,+相当于OR。使用方法是:逻辑量*逻辑量,逻辑量+逻辑量比如:=IF((A1>10)*(A1<100),"OK","NO")=IF((A1>10)+(A1<>50),"OK","NO")AND,OR是逻辑函数。使用方法是:AND(逻辑量,逻辑量,逻辑量,……),OR(逻辑量,逻辑量,逻辑量,……)比如:=IF(AND(A1>10,A1<100),"OK","NO")=IF(OR(A1>10,A1<>50),"OK","NO")