Calculations off--what am I doing wrong?

Question

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.

sergeibaklan · Answer

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

tejas_shah · Answer

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

Forum Discussion

Calculations off--what am I doing wrong?

Share

Resources