excel公式如一个值在特定范围内，则显示特定字母，该怎么设置公式呢？

Question

如一个值x≤2%,则显示为A，2%≤x＜5%，则为B，x＞5%，则显示为C，该怎么设置公式呢，请大家帮帮忙

Answer 1

使用自定义格式, 既不影响以后数据在其他公式中的使用, 还可以显示出需要的内容,具体见下图

Answer 2

可用以下公式：
1、=if(a1>0.05,"C",if(a1>0.02,"B","A"))
2、=lookup(a1,{0,0.02,0.05},{"A","B","C"})本回答被提问者采纳

Answer 3

假设数据X在A1，在B1中输入
=LOOKUP(A1,{0,"A"；0.02,"B"；0.05,"C"})

Answer 4

=LOOKUP(A1,{0，0.019,0.05},{"A","B","C"})

Answer 5

=IF(A1<=0.02,"A",IF(A1<0.05,"B","C"))