View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mary Beth Mary Beth is offline
external usenet poster
 
Posts: 2
Default sum of digits in column not giving correct sum

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!