# How to Nest Microsoft Excel Worksheet Functions

Nesting Microsoft Excel Worksheet functions in a formula is the key to developing advanced formulas for dashboards, models and data processing tools in Excel.

Microsoft Excel is one the most versatile tools on the market place today for developing advanced business, engineering and scientific tools. Discussed below is how to nest a function inside of another function.

## Excel Worksheet Function Nesting Overview

When sophisticated calculations have to be performed in a worksheet cell, the need will arise to nest Excel functions in a single formula. This saves worksheet space as only one cell is used to do multiple operations. The simple concept behind nesting functions is to place the function syntax that runs the function in the argument list of another function in the same formula. This allows the inside function to calculate first then feed its result value to the function whose argument list it was placed in.

For example, say you are trying to use the VLOOKUP function to lookup a value in a table on a worksheet. In the first column of the worksheet table, there is a list of dates that you will look up. Dates on a worksheet are really stored as numbers like 1/1/2017 = 42736 as discussed in all of our Excel classes. If you tried to plug 1/20/2017 into the first argument of the VLOOKUP function, you would error out. That is because 1/20/2017 is not really a date, it is 1 divided by 20 divided by 2017 because there are no real dates in Excel. So you need a function that can flip the date you are looking for into the number that is really stored on the worksheet in the first column of the table. To do this you could nest DATEVALUE() as the first argument of VLOOKUP and it would flip the date syntax to a number that VLOOKUP could then use. This concept is illustrated in the formula below.

=VLOOKUP( DATEVALUE( "1/20/2017" ) , A1:D100 , 2 , FALSE )

## 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
• 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