Help with Calculations

I need your help . i have a spreadsheet In the Spread Sheet in the First line there is a field “Unit Type Total PQ”.

That field is calculated from =F2*D2 and the value of F2 = 0.05 and D2 = 12 so Excel reports that the Field “Unit Type Total PQ” results into 0.56.

If I take a CALCULATOR and multiply 0.05 * 12 I get 0.6

And if I go to SQL I get with this

Code:

---

SELECT  CONVERT(DECIMAL(10,2),0.05) * 12

---

I get 0.60

Why is Excell giving me Incorrect values or how can i fix my SQL

I suspect that is being caused in Excel due to formatting and rounding of decimal places. The 0.05 you see could be a result of rounding. You need to see that cell upto 4 or 6 decimal places to determine if that value is 0.05 or is it something else.