Formula total wrong

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?
 
N

Niek Otten

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?
 
C

CamiLin

=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
 
D

David Biddulph

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.
 
R

Ron Rosenfeld

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
 
M

Marcelo

why not use =a8*c8?

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



"CamiLin" escreveu:
 
M

Marcelo

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



"CamiLin" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top