Excel Miscalculates simple formula..Help!!
Ok I have a situation where I do all my invoices in Excel.
I've noticed a difference in calculation between excel and quickbooks over
time but can't figure it out. A simple calculation like 1.96 x 1040 =
2031something instead of 2038.40. It is consistent throughout the worksheet
in other formulas.
I have checked tools<options<calculation and everything seems cool. Even
reinstalled Office, it worked fine once then went back doing the old
miscalulations. Any suggestions?
|