已将标准写入公式,在D1单元格输入公式=IF(AND(A1="啤酒",SUBSTITUTE(C1,"元","")*1>=3,SUBSTITUTE(C1,"元","")*1<5),50%,IF(AND(A1="啤酒",SUBSTITUTE(C1,"元","")*1>=5,SUBSTITUTE(C1,"元","")*1<=7),45%,IF(AND(A1="红酒",SUBSTITUTE(C1,"元","")*1>=100,SUBSTITUTE(C1,"元","")*1<200),40%,IF(AND(A1="白酒",SUBSTITUTE(C1,"元","")*1>=200,SUBSTITUTE(C1,"元","")*1<500),25%,IF(AND(A1="白酒",SUBSTITUTE(C1,"元","")*1>=500,SUBSTITUTE(C1,"元","")*1<=1000),20%,"")))))
下拉公式。 (结果出来后是小数,按工具栏是的百分号%即可转换成百分数) 如图: