|
|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
受益!谢谢各位大虾!!!
使我解决了我的一个图表中的公式:
(我的图表中:
当公历尾数=1或6;农历尾数=1或6,返回=1
当公历尾数=1或6;农历尾数=2或7返回=1
当公历尾数=1或6;农历尾数=3或8,返回=1
当公历尾数=2或7,农历尾数=1或6,返回=1
当公历尾数=3或8,农历尾数=1或6,返回=1
当公历尾数=2或7农历尾数=2或7,返回=2
当公历尾数=2或7;农历尾数=4或9返回=2
当公历尾数=2或7,农历尾数=5或0返回=2
当公历尾数=4或9,农历尾数=2或7返回=2
当公历尾数=5或0,农历尾数=2或7返回=2
......
当公历尾数=5或0,农历尾数=5或0返回=5
......
公式:
=IF(AND((AR5=1)+(AR5=6),(AS5=1)+(AS5=6)),1,"")&IF(AND((AR5=1)+(AR5=6),(AS5=2)+(AS5=7)),1,"")&IF(AND((AR5=1)+(AR5=6),(AS5=3)+(AS5=8)),1,"")&IF(AND((AR5=2)+(AR5=7),(AS5=1)+(AS5=6)),1,"")&IF(AND((AR5=3)+(AR5=8),(AS5=1)+(AS5=6)),1,"")&IF(AND((AR5=2)+(AR5=7),(AS5=2)+(AS5=7)),2,"")&IF(AND((AR5=2)+(AR5=7),(AS5=4)+(AS5=9)),2,"")&IF(AND((AR5=2)+(AR5=7),(AS5=5)+(AS5=0)),2,"")&IF(AND((AR5=4)+(AR5=9),(AS5=2)+(AS5=7)),2,"")&IF(AND((AR5=5)+(AR5=0),(AS5=2)+(AS5=7)),2,"")&IF(AND((AR5=3)+(AR5=8),(AS5=3)+(AS5=8)),3,"")&IF(AND((AR5=3)+(AR5=8),(AS5=5)+(AS5=0)),3,"")&IF(AND((AR5=3)+(AR5=8),(AS5=2)+(AS5=7)),3,"")&IF(AND((AR5=5)+(AR5=0),(AS5=3)+(AS5=8)),3,"")&IF(AND((AR5=2)+(AR5=7),(AS5=3)+(AS5=8)),3,"")&IF(AND((AR5=4)+(AR5=9),(AS5=4)+(AS5=9)),4,"")&IF(AND((AR5=4)+(AR5=9),(AS5=3)+(AS5=8)),4,"")&IF(AND((AR5=4)+(AR5=9),(AS5=1)+(AS5=6)),4,"")&IF(AND((AR5=3)+(AR5=8),(AS5=4)+(AS5=9)),4,"")&IF(AND((AR5=1)+(AR5=6),(AS5=4)+(AS5=9)),4,"")&IF(AND((AR5=5)+(AR5=0),(AS5=5)+(AS5=0)),5,"")&IF(AND((AR5=5)+(AR5=0),(AS5=1)+(AS5=6)),5,"")&IF(AND((AR5=5)+(AR5=0),(AS5=4)+(AS5=9)),5,"")&IF(AND((AR5=1)+(AR5=6),(AS5=5)+(AS5=0)),5,"")&IF(AND((AR5=4)+(AR5=9),(AS5=5)+(AS5=0)),5,"")
再次谢谢!!! |
|
楼主: 谷洪
沪公网安备 31011702000001号 沪ICP备11019229号-2
发表于 2010-2-10 21:02
