Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Multiplication Question
If I use a calculator to multiply $2,136,974 x 1.1201 x 0.9440, I get an
answer of $2,259,582 (This should be the correct answer -- the last two numbers in the formula are supposed to be loads and decrements to the original number) If I multiply these same numbers in Excel using the same order and a formula of E10*E17*E18, I get an answer of $23,386 If I multiply these same numbers in Excel using the same order and a formula of E10*1+E17*1+E18, I get an answer of $2,136,976 What am I doing wrong in setting up the Excel formula? I'm using Excel 2003 Professional, but I don't think that makes any difference. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Multiplication Question
I get an answer of $23,386
I get a result of 2259581.6010656 and, depending on how wide the column is, Excel will display 2259582. -- Biff Microsoft Excel MVP "Stumped In Indy" <Stumped In wrote in message ... If I use a calculator to multiply $2,136,974 x 1.1201 x 0.9440, I get an answer of $2,259,582 (This should be the correct answer -- the last two numbers in the formula are supposed to be loads and decrements to the original number) If I multiply these same numbers in Excel using the same order and a formula of E10*E17*E18, I get an answer of $23,386 If I multiply these same numbers in Excel using the same order and a formula of E10*1+E17*1+E18, I get an answer of $2,136,976 What am I doing wrong in setting up the Excel formula? I'm using Excel 2003 Professional, but I don't think that makes any difference. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Multiplication Question
This is an annual cost number which I am applying 12% inflation number and
then taking that adjusted number and doing a value adjustment that drops that number by 5.6%. Maybe you have a better way of formulating the cell to get the correct answer. "T. Valko" wrote: I get an answer of $23,386 I get a result of 2259581.6010656 and, depending on how wide the column is, Excel will display 2259582. -- Biff Microsoft Excel MVP "Stumped In Indy" <Stumped In wrote in message ... If I use a calculator to multiply $2,136,974 x 1.1201 x 0.9440, I get an answer of $2,259,582 (This should be the correct answer -- the last two numbers in the formula are supposed to be loads and decrements to the original number) If I multiply these same numbers in Excel using the same order and a formula of E10*E17*E18, I get an answer of $23,386 If I multiply these same numbers in Excel using the same order and a formula of E10*1+E17*1+E18, I get an answer of $2,136,976 What am I doing wrong in setting up the Excel formula? I'm using Excel 2003 Professional, but I don't think that makes any difference. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Multiplication Question
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Multiplication Question
Well, there's nothing wrong with the formula, as stated it should work fine.
You want to make sure your decimal places are correct, that you are doing multiplication not exponentiation (using ^ instead of * since they are right next to each other). Try this: in the formula =E10*E17*E18 select E10 and press F9 note the results, is it correct, press Esc not Enter and do the same thing for E17 and E18. These should match the numbers you quoted us. -- Thanks, Shane Devenshire "Stumped In Indy" wrote: If I use a calculator to multiply $2,136,974 x 1.1201 x 0.9440, I get an answer of $2,259,582 (This should be the correct answer -- the last two numbers in the formula are supposed to be loads and decrements to the original number) If I multiply these same numbers in Excel using the same order and a formula of E10*E17*E18, I get an answer of $23,386 If I multiply these same numbers in Excel using the same order and a formula of E10*1+E17*1+E18, I get an answer of $2,136,976 What am I doing wrong in setting up the Excel formula? I'm using Excel 2003 Professional, but I don't think that makes any difference. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Multiplication Question
Check this. Go to Tools - Options - Calculation. Do you have Precision
as displayed selected? -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Stumped In Indy" wrote: If I use a calculator to multiply $2,136,974 x 1.1201 x 0.9440, I get an answer of $2,259,582 (This should be the correct answer -- the last two numbers in the formula are supposed to be loads and decrements to the original number) If I multiply these same numbers in Excel using the same order and a formula of E10*E17*E18, I get an answer of $23,386 If I multiply these same numbers in Excel using the same order and a formula of E10*1+E17*1+E18, I get an answer of $2,136,976 What am I doing wrong in setting up the Excel formula? I'm using Excel 2003 Professional, but I don't think that makes any difference. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Multiplication Question
As I noted in my other reply, I get the apparently correct answer that
you're expecting. If you get $23,386 which is way off then something is terribly wrong. It's probably something simple that you're overlooking. If those figures you posted are generated by formulas then double and triple check them and make sure they are returning the correct results. -- Biff Microsoft Excel MVP "Stumped In Indy" wrote in message ... This is an annual cost number which I am applying 12% inflation number and then taking that adjusted number and doing a value adjustment that drops that number by 5.6%. Maybe you have a better way of formulating the cell to get the correct answer. "T. Valko" wrote: I get an answer of $23,386 I get a result of 2259581.6010656 and, depending on how wide the column is, Excel will display 2259582. -- Biff Microsoft Excel MVP "Stumped In Indy" <Stumped In wrote in message ... If I use a calculator to multiply $2,136,974 x 1.1201 x 0.9440, I get an answer of $2,259,582 (This should be the correct answer -- the last two numbers in the formula are supposed to be loads and decrements to the original number) If I multiply these same numbers in Excel using the same order and a formula of E10*E17*E18, I get an answer of $23,386 If I multiply these same numbers in Excel using the same order and a formula of E10*1+E17*1+E18, I get an answer of $2,136,976 What am I doing wrong in setting up the Excel formula? I'm using Excel 2003 Professional, but I don't think that makes any difference. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question for MVP - install Excel 2003 on MS Server 2003 | Setting up and Configuration of Excel | |||
Excel 2007 multiplication bug - and more... | Excel Discussion (Misc queries) | |||
My question is about Excel how to create tables by multiplication | Excel Discussion (Misc queries) | |||
Excel vs. calculator multiplication product discrepancy... | Excel Worksheet Functions | |||
Question about Excel 2003 | Excel Discussion (Misc queries) |