View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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.