A few examples from
http://office.microsoft.com/en-us/ex...042111033.aspx that I couldn't
find at http://www.xlfdic.com/ (but there are many more, and of course Peter
doesn't claim that it's complete):
ACOS ACOSH ASIN ASINH ATAN ATANH ADDRESS BAHTTEXT BIN2HEX BINOMDIST CHIDIST
COLUMN COLUMNS COMPLEX CONFIDENCE COS COSH DEC2OCT DEGREES DOLLAR EXP
EXPONDIST FDIST FISHER FV GAMMADIST GEOMEAN HARMEAN HEX2BIN HYPERLINK
IMAGINARY INTERCEPT IRR LINEST LN LOG LOG10 LOGEST LOGINV NORMDIST NORMINV
NORMSDIST NORMSINV NPV OCT2DEC OFFSET PEARSON PMT POISSON PROB PV RADIANS
RATE ROW ROWS SEARCH SIN SINH SKEW SLOPE SQRT SUMSQ TAN TANH WEEKNUM XIRR
YIELD
--
David Biddulph

"Peo Sjoblom" wrote in message
...
Which ones are missing?

Regards,

Peo Sjoblom

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Not *all* Excel functions, I think, but a useful collection.
Your advice to use Excel help is wise; it's often a temptation to give
an "RTFM" answer to many of the questions on this and other Excel
newsgroups. The help data (and list of functions, with the one usual
exception) are available at
http://office.microsoft.com/en-us/ex...042111033.aspx
--
David Biddulph

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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.

In help you can also find about the order of operations, which was the
cause of
your error in the first place.

Gord Dibben MS Excel MVP

On Tue, 11 Sep 2007 23:00:02 -0700, USRA KHAN <USRA
wrote:

Hi Caroline,

I need a file which should be consist of all excel formula's, can i have
it?

Usra Khan

"Caroline" wrote:

You need to add (): Excel divides and multiplies before it adds and
substracts.
(A1+A2)/10 -- Excel will 1st add then divide the result of the
addition.

"TDF" wrote:

when i add 2 numbers then divide by a number it's answer is wrong,
why

example: when i add 500 = A1
100 = A2
=A1 + A2/10 answer comes
back as 150