=if(A1="甲",50,if(A1="乙",45,if(A1="丙",40,"")))
=vlookup(A1,{"文本甲",50;"文本乙",45;"文本丙",40},2,0)
=35+5*MOD(CODE(A1)-4000,6)A1=甲或乙或丙
