The cells to be added need not only be formatted to 2 decimal places, they
also have to be rounded (see for ROUND function), so that that Excel
calculates values exactly as they are being displayed.

Joerg


"Nenagh" wrote in message
...
Hi,

I have a spreadsheet invoice were most of the line charges are formulas
looking up other spreadsheets.

There is a sum function for the total of the column, however when it adds:

$326.08 and $32.61 the total given is $358.61. It should be $385.69.

All the cells that are being added have been formated to 2 decinal places.

How do i get the correct answer?
--
Nenagh