Formula total wrong
 

I have a simple multiplication formula in two work sheets and they both come
up with differrent answeres which are both wrong. Whats going on?

Formula total wrong
 

Impossible to say without your formulas, the values of the input cells and the results

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"CamiLin" wrote in message ...
|I have a simple multiplication formula in two work sheets and they both come
| up with differrent answeres which are both wrong. Whats going on?

Formula total wrong
 

=Sum(A8*C8)
12 x $197.58 Should be $2,370.96
One workbook comes out to $2,370.93 the other $2,370.98


"Niek Otten" wrote:

Impossible to say without your formulas, the values of the input cells and the results

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"CamiLin" wrote in message ...
|I have a simple multiplication formula in two work sheets and they both come
| up with differrent answeres which are both wrong. Whats going on?

Formula total wrong
 

Well to start with you don't need the SUM() function. All you need is
=A8*C8. The SUM function is for *adding*, not for multiplying.
Secondly, I guess that what you have in the cells isn't exactly what you've
seen.
If the 12 is exact, 2370.93/12 is 197.5775 and 2370.98/12 is 197.58166667.
If you are only displaying the content of your cells to 2 decimal places,
either of those would look like 197.58. If you want to see what's really
there, extend the number of decimal places in your cell formatting. If you
want to round the number before multiplying it, you can use the ROUND
function, or you could use Tools/ Options/ Calculation/ Precision as
Displayed, but the latter gives scope for confusion elsewhere.
--
David Biddulph

"CamiLin" wrote in message
...
=Sum(A8*C8)
12 x $197.58 Should be $2,370.96
One workbook comes out to $2,370.93 the other $2,370.98


"Niek Otten" wrote:

Impossible to say without your formulas, the values of the input cells
and the results

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"CamiLin" wrote in message
...
|I have a simple multiplication formula in two work sheets and they both
come
| up with differrent answeres which are both wrong. Whats going on?

Formula total wrong
 

On Wed, 20 Feb 2008 08:57:03 -0800, CamiLin
wrote:

I have a simple multiplication formula in two work sheets and they both come
up with differrent answeres which are both wrong. Whats going on?

Most likely, what you think is in the cell is not really what is in the cell.

Excel does operations on the cell contents. Depending on the formatting, this
may not be the same as what is displayed in the cell. This can be especially
the case if the cells contain formulas.
--ron

Formula total wrong
 

why not use =a8*c8?

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"CamiLin" escreveu:

=Sum(A8*C8)
12 x $197.58 Should be $2,370.96
One workbook comes out to $2,370.93 the other $2,370.98


"Niek Otten" wrote:

Impossible to say without your formulas, the values of the input cells and the results

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"CamiLin" wrote in message ...
|I have a simple multiplication formula in two work sheets and they both come
| up with differrent answeres which are both wrong. Whats going on?

Formula total wrong
 

or =product(a8,c8)
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"CamiLin" escreveu:

I have a simple multiplication formula in two work sheets and they both come
up with differrent answeres which are both wrong. Whats going on?