The problem you have is that the numbers have more than 2 decimals, so when
they are displayed they show an already "rounded" value, however, the round
formula picks all of the decimals and then the rounding occurs. So you could
display more than two decimals or ask the round to be 3 decimals and then
format the cell to show only two decimals.

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Mary Beth" wrote:

My column of numbers is not giving the correct total. My formula for the
total is: =ROUND(SUM(A4:A15),2) The numbers I added are 6.30+1.74+1.24 and
got an answer of 9.27 (should be 9.28). The numbers I am adding are
formulated from another macro not just a number I inserted (it is a formula
to calculate the gst out of a number from another column) and this is why I
think I am getting a wrong answer but I don't know how to correct it.
Help please!