问题已解决
=IF(J3=1,31-K3,IF(J3=2,28-K3,IF(J3=3,31-K3,IF(J3=4,30-K3,IF(J3=5,31-K3,IF(J3=6,30-K3,IF(J3=7,31-K3,IF(J3=8,31-K3,IF(J3=9,30-K3,IF(J3=10,31-K3,IF(J3=11,30-K3,IF(J3=12,31-K3))))))))))))这个公式那里有问题,J1-J8单独计算是没问题,J9-J12单独计算是没问题,合在一起就是过不去
![](https://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/012/30/47/97_avatar_middle.jpg?t=1659537177)
同学您好,方便截个图看下如何提示的吗
2022 08/06 07:33
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84784958 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 08/06 08:18
帮看下了
![](https://pic1.acc5.cn/012/30/47/97_avatar_middle.jpg?t=1659537177)
Jane老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 08/06 08:40
亲,逗号是英文状态输入的吗
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84784958 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 08/06 08:42
是在英文状态下
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84784958 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 08/06 08:49
找到原因了就是,的事
![](https://pic1.acc5.cn/012/30/47/97_avatar_middle.jpg?t=1659537177)
Jane老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 08/06 09:10
好哒,同学工作愉快喔~