Excel Miscalculates simple formula..Help!!

D

Dave

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

JulieD

Hi Dave

i'm guessing a rounding error .. it is possible that you're only seeing
1.96, when the cell contains another number e.g. 1.95632 ... right mouse
click on the cell in question, choose format cells and then click on GENERAL
on the number tab .. .is the number you're seeing in the cell rounded?

Cheers
JulieD
 

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

Similar Threads

How do I create a formula in excel to multiply two items from two 3
Formulas won't function 3
Automatically copy formula in column when adding new row.... 2
Need help with formula 7
cell display 6
Time formulas 1
Excel sees cell formulas as constants, will not solve 1
Excel - Not calculating formulas 1

Top