Question

excel函数用法问题 if函数怎么写区间 比如 :

大于等于75 小于等于100
正确返回”是”
否则返回”不是”
可以写个完整的式子吗

Answer 1

假如这个值在A1
=IF(AND(A1>=75,A1<=100),"是","不是")

Answer 2

=IF(AND(A1>=75,A1<=100),"是","不是")
或
=IF((A1>=75)*(A1<=100),"是","不是")
或
=IF(OR(A1<75,A1>100),"不是","是")
或
=IF((A1<75)+(A1>100),"不是","是")