在excel表里如何实现：①当70%<=A1<80%时,B1=a，②当80%<=A1<90%时,B1=b，

Question

在excel表里如何实现：①当70%<=A1<80%时,B1=a，②当80%<=A1<90%时,B1=b，③当90%<=A1<1000%时,B1=c 以此类推

Answer 1

是你表格输入的不对还是你打的不对？当70%<=A1<80%时,B1=a，那小于70%的也等于a，还是等于其它什么？另外，“当90%<=A1<1000%时,B1=c 以此类推”，这是不是100%啊，不是1000%？

是不是应该这样：

如果是这样的话，那就用下面的公式：

=LOOKUP($A1,{0,0.7,0.8,0.9,1,1.1,1.2},{"a","a","b","c","d","e","f"})

Answer 2

公式：
=LOOKUP(A1,{0,0.7,0.8,0.9,1},{"","a","b","c",""})