首页|扩展Excel 2010的函数功能

扩展Excel 2010的函数功能

扫码查看
Excel提供了众多的系统函数,这些函数满足了多数用户的需要,但也存在一些问题,有些问题要用多个系统函数的组合或嵌套才能解决,从而使表达式太冗长、可读性差等。解决系统函数的不足,使用自定义函数是个明智之举。使用自定义函数,扩展了Excel的函数功能,也简化用户的工作,可以满足用户个性化的需要。
Expanding System Functions in Excel 2010
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 2010system functionscustom functionsVisual Basic editor

饶拱维、何文全、吴妙珍

展开 >

嘉应学院计算机学院,广东 梅州 514015

Excel 2010 系统函数 自定义函数 Visual Basic编辑器

2015

电脑开发与应用
中国北方自动控制技术研究所

电脑开发与应用

影响因子:0.265
ISSN:1003-5850
年,卷(期):2015.(3)
  • 2
  • 2