1、如果a1是壹佰元,那么a2是张数,那么a3出现结果,a3的公式就是:
=(if(a1="壹佰元",100,0)+if(a1="五十元",50,0)+.........)*a2
2、其中省略号的内容就另外11种币值判断,
把if(a1="中文币值",阿拉伯数字币值,0)再加11次。
3、刚才有空试了一下,应该写“壹佰圆”才对。公式如下:
=(IF(A1="壹佰圆",100,0)+IF(A1="伍拾圆",50,0)+IF(A1="贰拾圆",20,0)+IF(A1="拾圆",10,0)+IF(A1="伍圆",5,0)+IF(A1="贰圆",2,0)+IF(A1="壹圆",1,0)+IF(A1="伍角",0.5,0)+IF(A1="贰角",0.2,0)+IF(A1="壹角",0.1,0)+IF(A1="伍分",0.05,0)+IF(A1="贰分",0.02,0)+IF(A1="壹分",0.01,0))*A2