-
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.
Nesting Functions
- Thread starter Chenboy2
- Start date
Excel Facts
Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,491
- Office Version
- 365
- Platform
- Windows
Substituting one function into another functions arguments.
That is really all there is to it. If you can understand the simple ones, the longer ones are just that, longer.
Start small, and keep building your way up.
Since the concept is fairly straightforward, I don't know that you will find a book dedicated to complex nested functions, as they are really more specific to the task at hand (so if you got a book on Engineering for Excel, you may find some good nested functions pertaining to that, etc).
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 63,880
- Office Version
- 365
- Platform
- Windows
I am doing it mostly by
- reading the basic Help file on the functions
- reading threads in this forum that use them
- trying to answer questions in this forum using them
- plenty of trial and error
Easy to turn up plenty of examples in the forum using the search facility and some of the function names of interest. For example, here a few where I simply searched for FILTER SEQUENCE (which searches for either or both but the small preview of each makes it pretty quick to find something of interest)
List All Possible Combinations (without Power Query) on a Mac
Need help with making complex formula
Average with large and small function
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,491
- Office Version
- 365
- Platform
- Windows
Absolutely not! Stop twisting our words!
It is ONE of the ways to do it (and what we say about this forum is also true for other Excel forums - I commonly provide links to questions/articles on other Excel forums).
I listed other resources as well, which you conveniently seem to ignore.
You acknowledge your deficiency in this area, and asked us what we do. You have asked us what we do, and we told you.
Then you jump on us for the answers we provide. If you don't like the answers, then stop asking the question.
The point in there is plenty of stuff out there all over the internet. It is just requires a little effort on your part to find it.
What does it take to learn how to nest functions? I've created some advanced nested functions in the past, a few a bit complicated to get what I need to do. I haven't used many of the new 365 functions yet. I watch their videos, use their formula, and change it to how I need to for my spreadsheets but I can create them because I took it from someone else.
What type of skillset allows someone to know how to nest functions in one formula?
What type of skillset allows someone to know how to nest functions in one formula?
