Formula total wrong

  • Thread starter Thread starter CamiLin
  • Start date Start date
C

CamiLin

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?
 
Impossible to say without your formulas, the values of the input cells and the results

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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?
 
=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
 
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.
 
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?
Click to expand...

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
 
why not use =a8*c8?

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



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



"CamiLin" escreveu:
 
Back
Top