Question

excel if函数里包含2个条件，且条件是范围内该如何设置？

我需要得到这样的效果。X在±5%之内，显示否，在±5%之外，显示是。

Answer 1

假如是 A1 单元格，则B1输入
=IF(AND(A1>=-5%,A1<=5%),"否","是"

Answer 2

假设X在A1单元格，则在B1中输入公式：
=IF(ABS(A1)<=5,"否","是")

Answer 3

=IF(-0.05<x<0.05,"否",IF(OR(x<-0.05,x>0.05),"是",""))

Answer 4

引用shgtg的回答：
假如是 A1 单元格，则B1输入
=IF(AND(A1>=-5%,A1<=5%),"否","是"

=IF(AND(A1>=-5%,A1<=5%),"否","是")

Answer 5

没有一个标准怎么确定？