I'm running Excel 2007 on a Vista machine. When I try to Autosum just two figures (which were the answers of multiplications) it is incorrect. Viz:
9.29
11.45
Autosum says 20.75!
I know the original figure of
62.38 had been rounded up and then multiplied by 7 and divided by 47 to get 9.29
I suspect it might have something to do with the rounding up but can't find how to correct this error!
HELP please!