How do I correct an incorrect total from a simple formula?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DC - 21 May 2008 15:57 GMT

I have a simple formula multiplying two cells and the ouput is incorrect. Why
is this happening?

Reply to this Message

Bob I - 21 May 2008 16:03 GMT

You are likely not looking at or considering the "whole" content of the
2 cells being multiplied. Look at the complete values, not the rounded
or truncated displayed values.

> I have a simple formula multiplying two cells and the ouput is incorrect. Why
> is this happening?

Reply to this Message

DC - 21 May 2008 16:21 GMT

Thanks for the reply. The output I am receiving is "1,558,523" while the
correct answer is "1,560,117" to the formula "4251*367". Am I missing
something?

> You are likely not looking at or considering the "whole" content of the
> 2 cells being multiplied. Look at the complete values, not the rounded
> or truncated displayed values.
>
> > I have a simple formula multiplying two cells and the ouput is incorrect. Why
> > is this happening?

Reply to this Message

uturnabout - 21 May 2008 16:59 GMT

I agree with bob.
excel can truncate values in a display, but use the actual number for a
calculation.
For example:

we all know 4*3=12
but 4.4*3.4=14.96
If excel is not displaying the decimal points this would look like
4*3=15

for your numbers,
4251.290235*366.6=1558523
but excel might display
4251*367=1558523

> Thanks for the reply. The output I am receiving is "1,558,523" while the
> correct answer is "1,560,117" to the formula "4251*367". Am I missing
[quoted text clipped - 6 lines]
> > > I have a simple formula multiplying two cells and the ouput is incorrect. Why
> > > is this happening?

Reply to this Message

Bob I - 21 May 2008 18:17 GMT

You said you are multiplying TWO cells. The "formula" is not "4251*367"
but a cell address times a cell address. What are the true contents of
those cells? Look in each cell by selecting them and seeing what it
really in them by looking at the formula bar. There will be the "why".

> Thanks for the reply. The output I am receiving is "1,558,523" while the
> correct answer is "1,560,117" to the formula "4251*367". Am I missing
[quoted text clipped - 6 lines]
>>>I have a simple formula multiplying two cells and the ouput is incorrect. Why
>>>is this happening?

Reply to this Message

DC - 21 May 2008 21:06 GMT

Thank you.

> You said you are multiplying TWO cells. The "formula" is not "4251*367"
> but a cell address times a cell address. What are the true contents of
[quoted text clipped - 11 lines]
> >>>I have a simple formula multiplying two cells and the ouput is incorrect. Why
> >>>is this happening?

Reply to this Message

Bob I - 21 May 2008 22:48 GMT

You're welcome, have a great day.

> Thank you.
>
[quoted text clipped - 13 lines]
>>>>>I have a simple formula multiplying two cells and the ouput is incorrect. Why
>>>>>is this happening?

Reply to this Message