扩展Excel 2010的函数功能  

Expanding System Functions in Excel 2010

作　　者：饶拱维[1] 何文全[1] 吴妙珍 

机构地区：[1]嘉应学院计算机学院,广东梅州514015

出　　处：《电脑开发与应用》2015年第3期39-41,44,共4页Computer Development & Applications

摘　　要：Excel提供了众多的系统函数,这些函数满足了多数用户的需要,但也存在一些问题,有些问题要用多个系统函数的组合或嵌套才能解决,从而使表达式太冗长、可读性差等。解决系统函数的不足,使用自定义函数是个明智之举。使用自定义函数,扩展了Excel的函数功能,也简化用户的工作,可以满足用户个性化的需要。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＆#39;s work,to meet the needs of individual users.

关 键 词：EXCEL 2010 系统函数 自定义函数 VISUAL Basic编辑器 

分 类 号：TP391.13[自动化与计算机技术—计算机应用技术]