where can i find a list of excell formula's?

macart · 02-12-2005, 04:06 PM

**Cutter** · 02-12-2005, 11:06 PM

Click on the = sign at the left end of the formula bar
Now click on the drop down arrow which now appears where the Name Box was
At the bottom of the list that appears click on More Functions
A window with a left and right pane will appear. You can choose a category of functions from the left pane or you can choose to list them all by selecting All in the left pane. The list of functions pertaining to your choice will appear in the right pane.
Click on the one you want and it will show you the syntax and a description for your choice.
Hit OK and it will place that function in whatever cell was active when you first clicked on the = sign
You'll get a new window which gides you through the use of the function you chose

Also, check the downloads at the following site:
http://www.contextures.on.ca/functions.html

Nick B · 02-15-2005, 02:06 AM

You can find most of them in Excel's Help. You can also find them in a
category view by going to Insert->Function in Excel.

What is it that you are trying to do?

"macart" wrote:

> where can i find a list of excell formula's?

David McRitchie · 02-15-2005, 06:45 PM

Peter Noneley has a worksheet with an example for each function
that he includes. The starting sheet is a list of functions.

Excel Function Dictionary -- by Peter Noneley, A reference to definitely download and maintain on your computer, workbook with 157+
sheets, each with an explanation and example of an Excel function. Peter's site is down you can obtain the file at
http://www.rondebruin.nl/files/xlfdic01.zip
courtesy of Ron de Bruin (home page, at the bottom of Ron's page)
http://www.rondebruin.nl/id.htm

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Nick B" <[email protected]> wrote in message news:[email protected]...
> You can find most of them in Excel's Help. You can also find them in a
> category view by going to Insert->Function in Excel.
>
> What is it that you are trying to do?
>
> "macart" wrote:
>
> > where can i find a list of excell formula's?