Research work · 2023

User-defined Functions

David E. Clough, Steven C. Chapra

CRC Press eBooks

Abstract

Scientists and engineers find great benefit in the hundreds of built-in functions provided by Excel. On repeated occasions, they have a need and search those functions to find what will resolve it. An add-in can be installed so the functions are always available and can be moved to multiple computers and shared with colleagues. Engineering formulas can get lengthy and having to recreate them for use in different cells, worksheets, or even other workbooks can be tedious and raise the likelihood of making errors. A common statistic used to characterize small sets of data is the range, that is, the algebraic difference between the maximum and minimum values. Frequently, add-ins are created as a collection of user-defined functions with a common theme. At a higher level of development, it is possible to add groups and commands to the Ribbon in Excel that incorporate the use of add-ins.

DOI: 10.1201/9781003361053-10