EXCEL中当一个单元格输入某文字或数字时,另一个单元格会自动输入对应的...答:B1=INDEX({输出1,输出2,输出3},MATCH(A1,{条件1,条件2,条件3},0))如 A1=1,B1=a; A1=2,B1=b; A1=3,B1=c:B1=INDEX({"a","b","c"},MATCH(A1,{1,2,3},0))增加一个条件:B1=INDEX({"a","b","c","d"},MATCH(A1,{1,2,3,4},0))...
怎么在excel里输入数字后自动出来对应英文或中文表达答:A1如果是 200 B1输入 =IF(ISNUMBER(A1),IF(INT(A1),TEXT(INT(A1),"[dbnum2]")&"元",)&IF(INT(A1*10)-INT(A1)*10,TEXT(INT(A1*10)-INT(A1)*10,"[dbnum2]")&"角",IF(INT(A1)=A1,,IF(A1<0.1,,"零")))&IF(ROUND((A1)*100-INT(A1*10)*10,),TEXT(ROUND(A1*100-...