在Excel中创建与使用自定义函数

Excel提供了众多的内置函数,这些函数满足了众多用户的要求,使用方便,深受欢迎。但也存在一些不足,有些问题要用多个内置函数的组合或嵌套才能解决,从而导致表达式太冗长、繁琐、可读性差等。解决内置函数的不足,使用自定义函数是个明智的选择。使用自定义函数,扩展了Excel的函数功能,也简化用户的工作,可以满足用户个性化的需要。

Creating and Using Custom Functions in 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.