Excel Formula Learning

[debbiep]

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.

 

[Gord Dibben]

There is no SWITCH function that I know of.

IIF is a VBA Function, not a worksheet function.

Debra Dalgleish has a good list of books.

http://www.contextures.on.ca/xlbooks.html

John Walkenbach's books are always a good choice.

If you want a workbook that lists all the Excel worksheet functions, download
this one from Peter Noneley.

http://www.xlfdic.com/

Very good examples and usage of all the Excel Functions.

Or just look in help for functions and examples.


Gord Dibben MS Excel MVP

 

[Guest]

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

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

 

[debbiep]

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

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





- Show quoted text -

Thank you. Does anyone know of ACCESS programming titles that have
formula/functions?