Hunter的大杂烩 技术学习笔记

February 3, 2012

excle常用函数(不断更新中)

Filed under: 技术话题 — hunter @ 11:16 am

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

No comments yet.

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

Powered by WordPress