cell to cell multiplications wrong in Excel (28.22 x 27=761.90)

R

rob

using type accounting to 2 decimal places, gives me the above 761.90... but
when i type it in a single cell (=28.22 x 27) i get the correct answer 761.94
when still using accounting type to 2 decimal places...........why is this
 
G

Gord Dibben

rob

Depends upon the underlying value of the cells that contain the formatted
28.22 and 27.

If I have a cell with 28.2188 formatted as Accounting it shows 28.22

Another cell with 26.998123 formatted as Accounting it shows 27.00

Sum of the two cells is 761.85

Read the info here at John McGimpsey's site.

http://www.mcgimpsey.com/excel/pennyoff.html


Gord Dibben Excel MVP
 
Top