在C1单元格内输入：=IF(B1=CNY,A1*E$1,(IF(B1=GBP,A1*E$2,(IF(B1=JPY,A1*E$3,(IF(B1=ARS,A1*E$4,(IF(B1=HKD,A1*E$5,(IF(B1=AUD,A1*E$5,(IF(B1=BHD,A1*E$6,A1*E$7)))))))))))))然后下拉C1单元格，或者复制C1单元格到C列其它单元格
