=IF(MID(A1,1,2)="金牌",300,IF(MID(A1,1,2)="银牌",200,IF(MID(A1,1,2)="铜牌",100,0)))+IF(MID(A1,3,2)="店长",1400,IF(MID(A1,3,2)="副店",1100,IF(MID(A1,3,2)="导购",800,0)))
