Excel 公式请教,内有说明

Question

用IF公式太长,运行不了
求助更好的公式,
=IF(T124=1,"蛇猴",IF(T124=2,"龙羊狗",IF(T124=3,"兔马鸡鼠",IF(T124=4,"虎蛇猴猪",IF(T124=5,"牛龙羊狗",IF(T124=6,"鼠兔马鸡",IF(T124=7,"虎蛇猴猪",IF(T124=8,"狗牛龙羊",IF(T124=9,"鸡鼠兔马",IF(T124=10,"猪虎蛇猴",IF(T124=11,"牛龙羊",IF(T124=12,"兔马","蛇"))))))))))))

Answer 1

因为从1-24分别对应不同的字符串所以，你可以把对应表放到另一个工作表中，如下图所示：

我图中用ABCD等代表你的各个属象字符串，然后你就可以这样用了，见公式：

=VLOOKUP(A2,Sheet2!A$1:B$9,2)

示例见图：

Answer 2

公式改为这样：
=IF(T124>12,"蛇",CHOOSE(T124,"蛇猴","龙羊狗","兔马鸡鼠","虎蛇猴猪","牛龙羊狗","鼠兔马鸡","虎蛇猴猪","狗牛龙羊","鸡鼠兔马","猪虎蛇猴","牛龙羊","兔马"))

或用这公式也行：
=IF(T124>12,"蛇",INDEX({"蛇猴";"龙羊狗";"兔马鸡鼠";"虎蛇猴猪";"牛龙羊狗";"鼠兔马鸡";"虎蛇猴猪";"狗牛龙羊";"鸡鼠兔马";"猪虎蛇猴";"牛龙羊";"兔马"},T124))本回答被提问者采纳

Answer 3

=INDEX({"蛇猴","龙羊狗","兔马鸡鼠","虎蛇猴猪","牛龙羊狗","鼠兔马鸡","虎蛇猴猪","狗牛龙羊","鸡鼠兔马","猪虎蛇猴","牛龙羊","兔马","蛇"},T124)