用If函数表达或是否有更简便的方法?比如A1我作了个下拉菜单,有SV/DSM(ManageDistributor)SV/DSM(NotManageDistributor)SR(KCity)SR(Non-KCity,ManageDistributor)SR(Non-KCity,NotManageDistributor)这5个选项,然后我

Question

用If函数表达或是否有更简便的方法?
比如A1我作了个下拉菜单,有
SV/DSM(Manage Distributor)
SV/DSM(Not Manage Distributor)
SR(K City)
SR(Non-K City,Manage Distributor)
SR(Non-K City,Not Manage Distributor)
这5个选项,然后我要在B1中实现如果A1等于第一行的时候是20%,如果等于第二行的时候是10%,如果等于第三行的时候又等于某个百分比,这样用If的话怎么来实现,我做的公式不是都等于20%,就是都等于10%...另外如果不用If的话是否还有其他更加简便的方法?

Answer 1

=(A1="SV/DSM(Manage Distributor)")*0.2+(A1="SV/DSM(Not Manage Distributor)")*0.1+(A1="SR(K City)")*0.35+(A1="SR(Non-K City, Manage Distributor)")*0.6+(A1="SR(Non-K City, Not Manage Distributor)")*0.5

或
=SUM((A1={"SV/DSM(Manage Distributor)","SV/DSM(Not Manage Distributor)","SR(K City)","SR(Non-K City, Manage Distributor)","SR(Non-K City, Not Manage Distributor)"})*{0.2,0.1,0.5,0.3,0.6})