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

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?