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
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