= =求教各位老师 第二天了= =

胖子用表格

例如 pd值有一下5种在 B5显示 分别为N/A 0.01-0.02 0.04-0.08 0.12-0.25 0.35-0.55 我做了下拉条
B6为Pd值得允许误差 分别对应N/A，±0.002，±0.005，±0.02，±0.05 所以
B6 应该怎么写？
我用的是B6=if(countif(b5,"*N/A*"),"N/A",if(0.01<=b5<=0.02,"±0.002",if(0.04<=b5<=0.08,"±0.005",if(0.12<=b5<=0.25,"±0.02",if(0.35<=b5<=0.55,"±0.05")))))
若是按这样写b6的公式 那么出现 当 b5为0.01-0.02，0.04-0.08,0.12-0.25,0.35-0.55时 b6均出现false
求教各位老师该怎么改

zhzyy

=IF(COUNTIF(B5,"*N/A*"),"N/A",IF(AND(B5>=0.01,B5<=0.02),"±0.002",IF(AND(B5>=0.04,B5<=0.08),"±0.005",IF(AND(B5>=0.12,B5<=0.25),"±0.02",IF(AND(B5>=0.35,B5<=0.55),"±0.05")))))

胖子用表格

zhzyy 发表于 2017-3-9 16:53
=IF(COUNTIF(B5,"*N/A*"),"N/A",IF(AND(B5>=0.01,B5=0.04,B5=0.12,B5=0.35,B5

3q 最近一直在忙 查看晚了 可是当b5=0.01-0.02，0.04-0.08时还是false啊 这个应该怎么解决呢