[已解决]帮忙把公式简化一下谢谢

hanjia · 发表于 2016-6-23 18:58

本帖最后由 hanjia 于 2016-6-23 19:58 编辑

公式太长简化一下谢谢

=LOOKUP(A1,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60},{"猴","羊","马","蛇","龙","兔","虎","牛","鼠","猪","狗","鸡","猴","羊","马","蛇","龙","兔","虎","牛","鼠","猪","狗","鸡","猴","羊","马","蛇","龙","兔","虎","牛","鼠","猪","狗","鸡","猴","羊","马","蛇","龙","兔","虎","牛","鼠","猪","狗","鸡","猴","羊","马","蛇","龙","兔","虎","牛","鼠","猪","狗","鸡"})

工作表.zip (7.69 KB, 下载次数: 2)

ws278106483 · 发表于 2016-6-23 19:38

=CHOOSE(MOD(A1,12)+1,"鸡","猴","羊","马","蛇","龙","兔","虎","牛","鼠","猪","狗")

复制代码

baksy · 发表于 2016-6-23 19:44

=MID("猴羊马蛇龙兔虎牛鼠猪狗鸡",MOD(A1-1,12)+1,1)

广陵王 · 发表于 2016-6-25 22:50

xiaqijin188 · 发表于 2016-6-27 20:29

谢谢分享

		自动登录	找回密码
密码			注册

[已解决]帮忙把公式简化一下谢谢

评分

评分

[已解决]帮忙把公式简化一下 谢谢

评分

评分

[已解决]帮忙把公式简化一下谢谢