eg.1 同时符合两个条件【并】

=if(and(A1>0,A1<1),"true","false")


eg.2 符合两个条件其一【或】

=if(or(A1>1,A1<0),"true","false")


eg.3 符合多个条件值其一【抽一】

=if(or(A1={"1","2","3"}),"true","false")