第6期-WPS表格的公式与函数

《第6期-WPS表格的公式与函数》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、WPS办公效率手册--第六期目录第一章、WPS表格公式基础····························································1第一节、WPS表格公式的组成·················································1一、引用的单元格·······························································1二、数值或者字符······················

2、·········································2三、运算符···········································································2四、括号···············································································2五、WPS表格函数及相关的参数··································

3、····2第二节、WPS表格公式的输入·················································2第二章、WPS表格函数基础····························································3第一节、WPS表格函数的参数·················································3一、常量·············································

4、··································4二、逻辑值···········································································4三、数组···············································································4四、错误值···················································

5、························5五、单元格引用···································································5六、嵌套函数·······································································6七、名称和标志···································································7第二节

6、、WPS表格函数一览···················································10一、财务函数·····································································10二、日期与时间函数·························································14三、数学与三角函数·······································

7、··················22四、统计函数·····································································37五、查找与引用函数·························································61第1页共2页北京金山软件有限公司WPSOffice2007WPS表格六、文本函数···················································

8、··················68七、逻辑函数·····································································78八、信息函数·····································································80九、工程函数····························