机构地区: 嘉应学院计算机学院
出 处: 《电脑开发与应用》 2012年第1期37-39,共3页
摘 要: Excel提供了众多的内置函数,这些函数满足了众多用户的要求,使用方便,深受欢迎。但也存在一些不足,有些问题要用多个内置函数的组合或嵌套才能解决,从而导致表达式太冗长、繁琐、可读性差等。解决内置函数的不足,使用自定义函数是个明智的选择。使用自定义函数,扩展了Excel的函数功能,也简化用户的工作,可以满足用户个性化的需要。 Excel provides many built-in functions that meet the requirements of many users,easy to use and very popular.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.
领 域: [自动化与计算机技术] [自动化与计算机技术]