扩展Excel 2010的函数功能
Expanding System Functions in Excel 2010
饶拱维 1何文全 1吴妙珍1
作者信息
- 1. 嘉应学院计算机学院，广东 梅州 514015
- 折叠
摘要
Excel提供了众多的系统函数，这些函数满足了多数用户的需要，但也存在一些问题，有些问题要用多个系统函数的组合或嵌套才能解决，从而使表达式太冗长、可读性差等。解决系统函数的不足，使用自定义函数是个明智之举。使用自定义函数，扩展了Excel的函数功能，也简化用户的工作，可以满足用户个性化的需要。
Abstract
Excel provides many built-in functions that meet the requirements of many users. But there are some inadequacies,some problems to use a combination of several built-in functions or nested can be resolved, resulting in the expression is too lengthy,cumbersome,poor readability. To solve the lack of built-in functions, using a custom function is a wise choice. Use a custom function that extends the functionality of Excel functions, but also simplify the user's work,to meet the needs of individual users.
关键词
Excel/2010/系统函数/自定义函数/Visual/Basic编辑器Key words
Excel 2010/system functions/custom functions/Visual Basic editor引用本文复制引用
出版年
2015
NETL
NSTL
维普
万方数据