From the course: Excel for Engineering Professionals
Join today to access over 23,200 courses taught by industry experts.
Understanding LAMBDA functions - Microsoft Excel Tutorial
From the course: Excel for Engineering Professionals
Understanding LAMBDA functions
- [Instructor] Have you ever needed to do simulations on your process involving the thermodynamic properties of water? In that case, you know that these properties can be quite difficult to calculate using built-in Excel formulas. Many engineers refer to writing their own custom functions in a programming language such as VBA or JavaScript. But that isn't for just anyone. Nowadays, Excel does have a way to write your own custom functions without the use of any of the real programming languages. Excel allows you to use its own built-in functions to create a new named function. The function that you need to create a named function is called the LAMBDA function. If you've used the LET function already, LAMBDA may look familiar to you. Here's an example of a LAMBDA function in a formula in its simplest form, =LAMBDA(x,x^2). What does this mean? It tells Excel that the function in question expects one argument, it's going…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.