View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default How do I correct an incorrect total from a simple formula?

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

DC wrote:

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?

"Bob I" wrote:


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.

DC wrote:

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