Question

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

1转换成：1为阳木
2转换成：2为阴木
3转换成：3为阳火
4转换成：4为阴火
5转换成：5为阳土
6转换成：6为阴土
7转换成：7为阳金
8转换成：8为阴金
9转换成：9为阳水
0转换成：10为阳水

Answer 1

=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)

Answer 2

假设数字在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为阳水"})

Answer 3

在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为阳水"})

Answer 4

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

Answer 5

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