Its usually because of Excel showing only two decimal places instead of the
complete value in a cell. The result of a formula may be for example
453.558944512 but the cell will display 453.56. In calculations though the
full number will be used giving unexpected differences. You can get round
this (no pun intended) by using the ROUND function, try
=ROUND((your_formula),2) eg =ROUND((VLOOKUP,A1,B1:B500,2,FALSE),2)
This will eliminate decimal places over two the calculations shoul then be
correct,
Regards,
Alan.
"kandyr" wrote in message
...
I get a different answer to a column of numbers (only 6) when I manually
add
them together as compared to doing a formula (=C6+C7+C8).
Why?