Calculations off–what am I doing wrong?
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.
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. Read More