Excel Formula Learning

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

debbiep@ywcaofjamestown.com - 30 Sep 2007 04:25 GMT

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.

Reply to this Message

Gord Dibben - 30 Sep 2007 04:44 GMT

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

>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.

Reply to this Message

Anant Basant - 30 Sep 2007 05:29 GMT

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

Signature

Anant

> 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.

Reply to this Message

debbiep@ywcaofjamestown.com - 30 Sep 2007 16:38 GMT

On Sep 30, 12:29 am, Anant Basant
<AnantBas...@discussions.microsoft.com> wrote:

> You can read John Walkenbach's book on Excel Formulas:http://www.amazon.com/Excel-2003-Formulas-John-Walkenbach/dp/0764540734
>
[quoted text clipped - 8 lines]
>
> - Show quoted text -

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

Reply to this Message