You can read John Walkenbach's book on Excel Formulas:
http://www.amazon.com/Excel-2003-For.../dp/0764540734

Bob Umlas has a page on Array Formulas which is excellent reading:
http://www.emailoffice.com/excel/arrays-bobumlas.html
--
Anant


" wrote:

I would like to find books that are advanced with Excel formulas. Do
you have any suggestions. I want to learn all the advanced functions/
formulas such as =Switch, =IIF(And, and all the complicated formulas.