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.