# Help with Calculations [Resolved]

Posted by Vuyiswamb under Sql Server on 3/22/2012 | Points: 10 | Views : 886 | Status : [Member] [MVP] [Administrator] | Replies : 7
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
<pre lang="java"></pre>

Thank you for posting at Dotnetfunda

#### Responses

Posted by: Sksamantaray on: 3/22/2012 [Member] Silver | Points: 50
 0 Hi Vuyiswamb To get the value to 0.60 , you need to write the formula as: `=ROUND(F2,2)*D2` Thanks, SanjayVuyiswamb, if this helps please login to Mark As Answer. | Alert Moderator
Posted by: Sksamantaray on: 3/22/2012 [Member] Silver | Points: 25