1. 用于处理类似(http://data.caixin.com/macro/industry_data_more.html?id=I0034#top)累积额的方法,判断下一行是否为12月,如果是则不减
=IF(ISERROR(FIND(“12月”,TEXT(A200,”yyyy年mm月”))),B199-B200,B199)
1. 用于处理类似(http://data.caixin.com/macro/industry_data_more.html?id=I0034#top)累积额的方法,判断下一行是否为12月,如果是则不减
=IF(ISERROR(FIND(“12月”,TEXT(A200,”yyyy年mm月”))),B199-B200,B199)
No comments yet.
RSS feed for comments on this post.
Sorry, the comment form is closed at this time.
Powered by WordPress