求助老师，能否简化为365版本的函数公式

双子座

05 19 28 37 46


=IF(OR(C4=0,C4=5),"014569",IF(OR(C4=1,C4=9),"012589",IF(OR(C4=2,C4=8),"123789",IF(OR(C4=3,C4=7),"234678",IF(OR(C4=4,C4=6),"034567","")))))
=IF(OR(C4=0,C4=5),"034567",IF(OR(C4=1,C4=9),"014569",IF(OR(C4=2,C4=8),"012589",IF(OR(C4=3,C4=7),"123789",IF(OR(C4=4,C4=6),"234678","")))))
=IF(OR(C4=0,C4=5),"234678",IF(OR(C4=1,C4=9),"034567",IF(OR(C4=2,C4=8),"014569",IF(OR(C4=3,C4=7),"012589",IF(OR(C4=4,C4=6),"123789","")))))
=IF(OR(C4=0,C4=5),"123789",IF(OR(C4=1,C4=9),"234678",IF(OR(C4=2,C4=8),"034567",IF(OR(C4=3,C4=7),"014569",IF(OR(C4=4,C4=6),"012589","")))))
=IF(OR(C4=0,C4=5),"012589",IF(OR(C4=1,C4=9),"123789",IF(OR(C4=2,C4=8),"234678",IF(OR(C4=3,C4=7),"034567",IF(OR(C4=4,C4=6),"014569","")))))
=IF(OR(C4=0,C4=5),"023578",IF(OR(C4=1,C4=9),"134679",IF(OR(C4=2,C4=8),"024568",IF(OR(C4=3,C4=7),"013579",IF(OR(C4=4,C4=6),"124689","")))))
=IF(OR(C4=0,C4=5),"124689",IF(OR(C4=1,C4=9),"023578",IF(OR(C4=2,C4=8),"134679",IF(OR(C4=3,C4=7),"024568",IF(OR(C4=4,C4=6),"013579","")))))
=IF(OR(C4=0,C4=5),"013579",IF(OR(C4=1,C4=9),"124689",IF(OR(C4=2,C4=8),"023578",IF(OR(C4=3,C4=7),"134679",IF(OR(C4=4,C4=6),"024568","")))))
=IF(OR(C4=0,C4=5),"024568",IF(OR(C4=1,C4=9),"013579",IF(OR(C4=2,C4=8),"124689",IF(OR(C4=3,C4=7),"023578",IF(OR(C4=4,C4=6),"134679","")))))
=IF(OR(C4=0,C4=5),"134679",IF(OR(C4=1,C4=9),"024568",IF(OR(C4=2,C4=8),"013579",IF(OR(C4=3,C4=7),"124689",IF(OR(C4=4,C4=6),"023578","")))))

双子座

老师们看看有没有更加简化的公式

鑫尼达

纯体力活      

ryujehong

看错了，俺也不会

xiangzi728

楼主上个附件，光看公式也看不出个所以然，这个公式应该可以用Vlookup等函数匹配

xiangzi728

=CHOOSE(C4,"012589","123789","234678","034567","014569","034567","234678","123789","012589")
上面众多公式中的第一个，可以简写成这样

双子座

xiangzi728 发表于 2021-8-8 12:15
=CHOOSE(C4,"012589","123789","234678","034567","014569","034567","234678","123789","012589")
上面众 ...

谢谢老师了，附件已经上传麻烦老师看看。谢谢谢谢！！！！