Calculations off--what am I doing wrong?

Copper Contributor

The calculations on my excel spreadsheet are off.  It is a simple calculation.  I am simply multiplying 2 columns.  


The value of column e30 is $3.48 is being multiplied by column f30 1198.  In column g30 it give me a sum of $4,174.95.  The formula reads =SUM(E30*F30).  However the correct answer is $4169.04.  Other calculations on spread sheet check out.  What am I doing wrong.



2 Replies


Are values in E30 and F30 were entered manually or they are returned by formulae?


Do you have more than 2 decimals in Column E and Column F?
Multiply doesn't require the SUM.