假设数据在A列,在A1输入公式
=VLOOKUP(A1,1,"A";2,"A";3,"A";4,"A";5,"A";6,"B";7,"B";8,"B";9,"B";0,"B"},2,0)
往下拉
或者
=IF(AND(A1>0,A1