Best approach to nesting formulas for a beginner?

colgor

New Member
Joined
Sep 16, 2015
Messages
41
I am understanding many new functions and can get them to work on an individual basis. I feel able to follow to some degree the nested formulas but always struggle, to repeat them myself, even using the function button with limited guidance built in. Is this just something that comes easy with practice? There are a plethora of resources on YouTube, can anyone recommend some good ones in this respect? Many thanks for any assistance?
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Chrisdontm

Well-known Member
Joined
May 4, 2015
Messages
810
Build your formulas from the inside out...
& I learned a lot from a guy on YouTube.com with the user name: ExcelIsFun
He has 100's of videos and is truly a good teacher...
Of course the more you practice, you do get better...
Also on this message board, try to figure out the answer for people, and if you can't, then wait to see what someone else tells them...
Have fun !!!
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,585
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
As well as the comments from Chrisdontm...
Have a look At the Datapig Technologies site for some great lessons
AND
here for Nested IF examples.


The more you play with Excel, the more you'll learn.....and will get better at it as well !!
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,388
Office Version
  1. 365
Platform
  1. Windows
Well, there probably isn't a whole lot out there because different functions have different rules, so nesting is dependent upon those rules.
Nesting is actually easier than you think, if you apply some simple logic to it.

For example, an IF statement, is structured like this:
=IF(a,b,c)
usually you would replace a, b, and c with values or conditions. But you can replace them with entire other formulas.
So couple this with the advice that Chrisdontm gave about building from the inside out, and it becomes a lot easier.
Just try to build it one piece at a time.
 

colgor

New Member
Joined
Sep 16, 2015
Messages
41
Sorry I failed to reply before. I will take a look at excelisfun and datapig and go from there. Thanks again.
 

Forum statistics

Threads
1,137,154
Messages
5,679,911
Members
419,862
Latest member
Bluewings666

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top