1 / 2

100% 需掌握的日常工作中使用最频繁的 Excel 函数

100% 需掌握的日常工作中使用最频繁的 Excel 函数. 100% 需掌握的日常工作中使用最频繁的 Excel 函数. Vlookup( 查找值，查找范围，赋值列序号， false). 日期函数 1 、组合新日期： date(2010,10,13)=2010-10-13 2 、 Year （ 2011-07-10 14:30 ） =2011 3 、求工作日： networkdays(“2010-1-1”,”2010-5-1”)=86 4 、求某日期在一年中的周序号： weeknum("2010-10-17")=43. IF 逻辑判断函数

unity
Download Presentation

100% 需掌握的日常工作中使用最频繁的 Excel 函数

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 100%需掌握的日常工作中使用最频繁的Excel函数

  2. 100%需掌握的日常工作中使用最频繁的Excel函数 • Vlookup(查找值，查找范围，赋值列序号，false) • 日期函数 • 1、组合新日期：date(2010,10,13)=2010-10-13 • 2、Year（2011-07-10 14:30）=2011 • 3、求工作日：networkdays(“2010-1-1”,”2010-5-1”)=86 • 4、求某日期在一年中的周序号：weeknum("2010-10-17")=43 IF逻辑判断函数 IF函数的语法结构：IF(条件,结果1,结果2)。 COUNTIF函数只能有一个条件，如大于90，为=COUNTIF(A1:A10,">=90")介于80与90之间需用减，为 =COUNTIF(A1:A10,">80")-COUNTIF(A1:A10,">90") 根据指定条件对若干单元格求和SUMIF(range，criteria，sum_range) MID(text,start_num,num_chars)从字符串中返回指定数目的字符

More Related