大于等于75 小于等于100
正确返回”是”
否则返回”不是”
可以写个完整的式子吗
第1个回答 2020-02-27
假如这个值在A1
=IF(AND(A1>=75,A1<=100),"是","不是")
=IF(AND(A1>=75,A1<=100),"是","不是")
第2个回答 2020-02-27
=IF(AND(A1>=75,A1<=100),"是","不是")
或
=IF((A1>=75)*(A1<=100),"是","不是")
或
=IF(OR(A1<75,A1>100),"不是","是")
或
=IF((A1<75)+(A1>100),"不是","是")本回答被网友采纳
或
=IF((A1>=75)*(A1<=100),"是","不是")
或
=IF(OR(A1<75,A1>100),"不是","是")
或
=IF((A1<75)+(A1>100),"不是","是")本回答被网友采纳