There don't seem to be a lot of online tutorials for Excel's IF function, and those I've looked at do not seem to have found a way of explaining it different from our workbook. However, you might look at these:
- tinyurl.com/i0th - video demo on our website
- Microsoft - with 4 examples, including nested IF fucntions the IF function
- MakeTips - =IF Function for Value or Calculation Based on Criteria
NESTED IF FUNCTIONS
- About.com
- Techon theNet
- The Spreadsheet Page - nested IF functions and VLOOKUP
- Online Investing Hacks, "Make Nested Functions Work in Excel" - interesting if you have some background in computer programming
- Pearson Software Consulting - interesting if you have some background in computer programming
