I want to ask that many times we have to use multiple formulas within a single cell to find the correct result, for example, Vlookup, Xlookup ,Mid, left, Right ISNA,ISNumber, Find ,Search, and many more formulas. How can we understand that multiple formulas will work?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How multiple formulas work.
- Thread starter ExcelUS
- Start date
Eric W
MrExcel MVP
- Joined
- Aug 18, 2015
- Messages
- 13,484
- Office Version
- 2024
- 2021
Welcome to the MrExcel forum!
If you're trying to say that longer formulas are harder to understand and maintain, you have a valid point. When someone here suggests a formula, they try to make it as short and simple as possible. Often someone will come along and suggest something shorter. But some formulas of necessity are just longer. Newer functions such as LET and LAMBDA make it even easier to have very long formulas. Your idea of having helper cells or columns is one way to simplify the formulas. But some people do not like helper cells on a worksheet. They often clutter up the worksheet with intermediate results that aren't necessary to see. These can be hidden, or moved to another sheet even, but that also increases the difficulty of maintaining them. In the end, it's always a trade-off between accuracy, maintainability, efficiency, and appearance. Some people will choose one way or another. If they are the only person using the spreadsheet, there's no issue. If it's a shared workbook, then some cooperation should come into play.
It's also true that a well-constructed LET formula, with proper variable names, is easier to understand than multiple helper cells.
If you are asking for help here, you may want to emphasize that helper cells are acceptable because most suggestions will be of the single cell variety.
If you're trying to say that longer formulas are harder to understand and maintain, you have a valid point. When someone here suggests a formula, they try to make it as short and simple as possible. Often someone will come along and suggest something shorter. But some formulas of necessity are just longer. Newer functions such as LET and LAMBDA make it even easier to have very long formulas. Your idea of having helper cells or columns is one way to simplify the formulas. But some people do not like helper cells on a worksheet. They often clutter up the worksheet with intermediate results that aren't necessary to see. These can be hidden, or moved to another sheet even, but that also increases the difficulty of maintaining them. In the end, it's always a trade-off between accuracy, maintainability, efficiency, and appearance. Some people will choose one way or another. If they are the only person using the spreadsheet, there's no issue. If it's a shared workbook, then some cooperation should come into play.
It's also true that a well-constructed LET formula, with proper variable names, is easier to understand than multiple helper cells.
If you are asking for help here, you may want to emphasize that helper cells are acceptable because most suggestions will be of the single cell variety.
Upvote
0
Solution
Can you explain the LET formula to me with an example of how we can manage large formulas through the LET function?
Upvote
0
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,864
- Office Version
- 365
- Platform
- Windows
Microsoft has detailed explanations and example on all their functions that can be found with a simple Google search (i.e. Google "Excel Let function").
Here is their documentation on that function: LET function - Microsoft Support
Here is their documentation on that function: LET function - Microsoft Support
Upvote
1
Similar threads
- Solved
- Solved
