Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula's
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula's
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula's
I don't undertstand why you get 150 I assume it's a type for 510 but to get
the correct answer you must force precedence with brackets:- =(A1+A2)/10 returns 60 for the values you give whereas =A1+A2/10 returns 510 bevcause the division is done first. Mike "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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula's
What answer do you expect?
=A1+A2/10 gives me 510 =(A1+A2)/10 returns 60 I have no idea why you would ever get 150 out of your formula unless that is a typo and you meant 510 Gord Dibben MS Excel MVP On Tue, 11 Sep 2007 10:02:03 -0700, 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula's
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula's
=A2+A1/10 would give you 150.
On Sep 11, 1:16 pm, Gord Dibben <gorddibbATshawDOTca wrote: What answer do you expect? =A1+A2/10 gives me 510 =(A1+A2)/10 returns 60 I have no idea why you would ever get 150 out of your formula unless that is a typo and you meant 510 Gord Dibben MS Excel MVP On Tue, 11 Sep 2007 10:02:03 -0700, 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- Hide quoted text - - Show quoted text - |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula's
This isn't all of them, but a lot of common ones:
http://www.xlfdic.com/ On Sep 12, 2:00 am, 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- Hide quoted text - - Show quoted text - |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula's
That is not what OP posted as the formula used.
=A1 + A2/10 answer comes back as 150 I guess the typo was in the formula, not the result. Gord On Wed, 12 Sep 2007 07:24:15 -0700, ilia wrote: =A2+A1/10 would give you 150. On Sep 11, 1:16 pm, Gord Dibben <gorddibbATshawDOTca wrote: What answer do you expect? =A1+A2/10 gives me 510 =(A1+A2)/10 returns 60 I have no idea why you would ever get 150 out of your formula unless that is a typo and you meant 510 Gord Dibben MS Excel MVP On Tue, 11 Sep 2007 10:02:03 -0700, 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- Hide quoted text - - Show quoted text - |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula's
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 |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula's
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 |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula's
=datedif()
??? <vbg Peo Sjoblom wrote: 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 -- Dave Peterson |
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula's
Good one but it is included <g
-- Regards, Peo Sjoblom "Dave Peterson" wrote in message ... =datedif() ??? <vbg Peo Sjoblom wrote: 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 -- Dave Peterson |
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula's
Your eyes are better than mine. I couldn't find it (still).
Peo Sjoblom wrote: Good one but it is included <g -- Regards, Peo Sjoblom "Dave Peterson" wrote in message ... =datedif() ??? <vbg Peo Sjoblom wrote: 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 -- Dave Peterson -- Dave Peterson |
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula's
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Formula's | Excel Worksheet Functions | |||
Help in Excel creating Formula's | Excel Worksheet Functions | |||
Comparing formula's of 2 excel workbooks | Excel Discussion (Misc queries) | |||
Excel Formula's | Excel Worksheet Functions | |||
Excel Formula's | Excel Worksheet Functions |