Videos | Books | What's New | FAQ | Testimonials | Buy Credits | Support | Login | My Account

Nested IF statements Added to Library on 09 Apr 2007 Length: 4 mins View Tutorial Movie Download File Used This tutorial illustrates how IF statements in Excel an be placed inside other IF statements to make complex statements. If uses a very simply example of an end of year financial statement for 10 products to show how you can create if statements to return not just a value for the true case and the false case but other cases as well. Related Tutorials: Filtering Lists and the Status Bar Introduction to the IF statement Vlookup Feedback for this tutorial: "Clayton, I just love your tutorials they are straight to the point and easy to understand. Kay Lenort p.s. Nice update to your website." "Hi Clayton Again another good tutorial, kept simple. I have used nested IF statements recently but the exercise ultimately required more than 8 so your tutorial on VLOOKUP made the job easier all round. Your guidelines of only using up to 4 nested IF statements before changing to VLOOKUP is a good guideline to be aware of. kind regards Rob Kearnes "