How to Run a Microsoft Excel Worksheet Function from a Formula

Microsoft Excel worksheet functions are computer programs that you run from a worksheet formula that add capabilities that normal formulas cannot perform.

Microsoft Excel is one the most versatile tools on the market place today for developing advanced business, engineering and scientific tools. One very important thing to learn is how to run worksheet functions from formulas. Discussed below is how to run a worksheet function from a formula on a worksheet.

What is a Worksheet Function

Microsoft Excel worksheet functions are computer programs that you run from a formula on your worksheet. They perform many tasks that ordinary formulas like =A1+A2 just cannot do like:

• Table look ups
• Merging information
• Summing 10,000 cell values at once
• Using a certain formula based on logic
• Figuring out where information is located on your worksheet

the list is really endless.

A Quick Way to Run a Function's Help

The complete list of Microsoft Excel functions and their help on how to run them can be quickly found by clicking the little fx button at the top of the Excel screen next to the formula bar (white box). Before clicking this button, make sure you are clicked on an empty cell so you do not overwrite anything when this screen is activated. When the Insert Function screen appears look through the drop downs, select a function name then click the Help on this Function blue hyperlink in the bottom left hand corner of the screen. This is a very quick way to access a function's help screen. The help screen will describe how to type the function in a formula, called its syntax and will also describe the uses of the function. A picture of these screens is illustrated below. Once the help screen is displayed, you can click the Cancel button on the Insert Function screen that was pulled up with the fx button to cancel the operation but the help screen will remain. As a note, it is highly recommended that you do not use the Insert Function tool to build the function syntax in your formula but rather learn how to type it yourself.

How to Run a Function

To run a function from a formula, type an equal sign, the function name and its argument list, for example =SUM(A1:A10,B1:B10). To be absolutely correct this is called a Call statement in programming and it is what you are typing except nobody will actually say that. The argument list is what information the function needs in order to operate. The argument list is contained between the two ( )'s and they are separated by commas. Function arguments come in many flavors but the basics are these:

• Numbers: 100
• Text: "Text"
• Cell References: A1
• Range References: A1:A10
• Booleans: TRUE or FALSE
• Other Functions (called nesting)
• Other Formulas (A1+A2)

What you do is you replace the argument names from help with these values. For example to run the VLOOKUP function, the syntax for it from help is VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])  and a possible formula would look like: =VLOOKUP("John Smith", A1:G200, 2, FALSE) where you have a mixture of text, numbers, Booleans and range references replacing the argument syntax from help. After typing the formula and Enter is pressed, the function will run behind the scenes and generate an answer returning it to the worksheet formula. One important thing, the argument list in a function is typed in a specific order, violate that order and the function will not operate correctly. One other thing, the tool we used to look up function help is called the Insert Function tool and is used to help build the call statement in a formula. Do not use it in that capacity, learn how to type and run a function from a cell manually. You will stumble at first just like everybody else has but it takes very little time to get the hang of. It is the only way later on to build the complex formulas that you have seen in worksheet formulas.

Quick Worksheet Function Example

On a worksheet type the values 1-10 in cells A1 through A10. Next in cell A11, type =SUM(A1:A10) and then press Enter. You have just run your first worksheet function and a popular one at that called the SUM function which performs addition. One last thing, right from the beginning all of Excel's functions run in the same manner as we just performed. So do not buy into the concept that their are functions for beginners and so on. If you want to run a function, just learn how to type it and do not worry about people trying categorize what you should learn.

For more help on the common functions that people use, please visit our Excel help page.

Next Excel Training Dates - Public Training and Live Online Courses

Our next public Excel training workshops and live online Excel courses are listed below. For all of the dates and times, please visit our Training Schedule page using the link above in the main menu.

 Beginning Excel Training for Business Professionals Intermediate Excel Training for Business Professionals Advanced Excel Training for Business Professionals Beginning Excel VBA Training for Business Professionals Intermediate Excel VBA Training for Business Professionals Advanced Excel VBA Training for Business Professionals Advanced Excel Training for Engineers / Scientists Beginning Excel VBA Training for Engineers / Scientists Intermediate Excel VBA Training for Engineers / Scientists Advanced Excel VBA Training for Engineers / Scientists Microsoft Excel Dashboards Training for Combined Audience Next Date:See Schedule Next Date:See Schedule Next Date:See Schedule Next Date:See Schedule Next Date:See Schedule Next Date:See Schedule Next Date:See Schedule Next Date:See Schedule Next Date:See Schedule Next Date:See Schedule Next Date:See Schedule

Public Training Location

• Our Excel public training workshops are held in Thousand Oaks, CA which is in Ventura County which is in the vicinity of Los Angeles County (LA County), Orange County, San Diego County, Kern County, Riverside County and Santa Barbara County
• We get people from all over the US, Canada, Mexico and the Caribbean, even as far away as Saudi Arabia and Nigeria
• We routinely get individuals from all over Northern and Southern California, Oregon, Texas, Washington and Virginia including San Jose, CA ; Mountain View, CA ; San Diego, CA ; Palmdale, CA ; Lancaster , CA ; Mojave, CA ; Portland, OR ; Dallas, TX ; Houston, TX ; Austin, TX ; Fort Worth , TX ; Alexandria, VA and Seattle, WA
• We also broadcast our Excel public training as live hands-on online courses so even though you cannot travel to us, you can still take the course as if sitting in the room with us
• EMAGENIT routinely gets individuals from the following Southern California cities attending our public training:
• Santa Barbara, CA
• Los Angeles, CA
• Reseda, CA
• Chatsworth, CA
• Topanga, CA
• Santa Clarita, CA
• Newbury Park, CA
• Camarillo, CA
• Calabasas, CA
• Valencia, CA
• West Hollywood, CA
• Goleta, CA
• Palmdale, CA
• San Fernando, CA
• Burbank, CA
• La Canada, CA
• Culver City, CA
• Anaheim, CA
• El Segundo, CA
• Fillmore, CA
• Gardena, CA
• Encino, CA
• Oxnard, CA
• Mojave, CA
• La Crescenta, CA
• Glendale, CA
• Flintridge, CA
• Beverly Hills
• Inglewood, CA
• Hawthorne, CA
• Manhattan Beach, CA
• Santa Paula, CA
• Century City, CA
• Sherman Oaks, CA
• Reseda, CA
• Woodland Hills, CA
• Hollywood, CA
• Studio City, CA
• Fillmore, CA
• Ventura, CA
• Moorpark, CA
• Simi Valley, CA
• Santa Monica, CA
• Encino, CA

EMAGENIT performs Excel onsite company training in the cities listed above as well as the entire Northern and Southern California areas, United States and Canada.

Need Help? Please call us at 1.866.924.6244