Hi, Which section in excel 2010 course deals with if nested functions. I am having difficulty to comprehend how to insert a v lookup in an if function. Is there an easy way to understand the intricacies of the nested functions with all the parentheses to insert

---

Reply from Richard Rost:

Well, I talk about nesting functions in a couple of different classes. Basically it's just one function inside of another, like nesting two IF functions. If you wanted to nest a VLOOKUP inside of an IF, you could say something like:

=IF(A1="NY",VLOOKUP(A1,CountyTable,2),"Out of State")

This would be handy to look up a County tax code, for example. If the state (A1) is in NY, then look up the tax rate from the CountyTable (bring back column 2) otherwise put "Out of State" there.

Is this what you have in mind?