用if（）条件函数进行嵌套判断，直接给结果=IF(A1="A",0,IF(A1="B",0.02,IF(A1="C",0.04,IF(A1="D",0.05,))))
B列输入公式：=LOOKUP(A:A,{"A","B","C","D"},{0,0.02,0.04,0.05})
LoopUpIndex+Match之类的查找函数都可以
