Thread
:
excel formula's
View Single Post
#
8
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
Posts: 22,906
excel formula's
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
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben