求教！我打算将0-9的数字转换成阴阳金木水火土，在excel中用公式怎么实现？

显示全部楼层 · 2012-12-4 07:42:53

=INDEX({"1为阳木";"2为阴木";"3为阳火";"4为阴火";"5为阳土";"6为阴土";"7为阳金";"8为阴金";"9为阳水";"10为阳水"},MATCH(A1,{1;2;3;4;5;6;7;8;9;0},0))=VLOOKUP(A1,{1,"1为阳木";2,"2为阴木";3,"3为阳火";4,"4为阴火";5,"5为阳土";6,"6为阴土";7,"7为阳金";8,"8为阴金";9,"9为阳水";0,"10为阳水"},2,0)...

千问 · 2012-12-4 07:42:53

假设数字在A1，使用公式：(0是不是应该为“10为阴水”)=LOOKUP(A1,{0,1,2,3,4,5,6,7,8,9},{"10为阴水","1为阳木","2为阴木","3为阳火","4为阴火","5为阳土","6为阴土","7为阳金","8为阴金","9为阳水"})...

千问 · 2012-12-4 07:42:53

在B1输入公式，则根据A1单元格的数据进行转换，=LOOKUP(2,1/(A1={1;2;3;4;5;6;7;8;9;0}),{"1为阳木";"2为阴木";"3为阳火";"4为阴火";"5为阳土";"6为阴土";"7为阳金";"8为阴金";"9为阳水";"10为阳水"})...

千问 · 2012-12-4 07:42:53

=CHOOSE(A1,"阳木","阴木","阳火","阴火","阳土","阴土","阳金","阴金","阳水","阳水")...

千问 · 2012-12-4 07:42:53

=LOOKUP(2,1/(A1={1;2;3;4;5;6;7;8;9;10}),{"阳木";"阴木";"阳火";"阴火";"阳土";"阴土";"阳金";"阴金";"阳水";"阳水"})...