Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |