customizing functions in Excel

Source: Internet
Author: User

Excel functions, although rich, do not meet all of our needs. We can customize a function to perform some specific operations. Below, we will come from the definition of a function to compute the trapezoidal area:

1. Execute the tools → macros →visual basic Editor menu command (or press the "ALT+F11" shortcut key) to open the Visual Basic editing window.

2. In the window, execute the Insert → module menu command and insert a new module-Module 1.

3. In the Right code window, enter the following code:

Function V (a,b,h) v = h* (a+b)/2end function

4. Close the window and complete the custom function.

You can use custom functions in the future just as you would with built-in functions.

Tip: Functions that are customized with the above method are usually available only in the appropriate workbook.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

11.11 Big Sale for Cloud

Get Unbeatable Offers with up to 90% Off,Oct.24-Nov.13 (UTC+8)

Get It Now >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.