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
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
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa[at]dotnetfunda.com http://www.Dotnetfunda.com
-
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
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa[at]dotnetfunda.com http://www.Dotnetfunda.com
Hi Vuyiswa Maseko, Excel by default remove zero number from decimal value, if you want to display decimal value with 2 numbers with separator then right click on cell and Format Cells.. option then select Number category, there you can see option decimal places, where you can set 2 or another decimal places.
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
-
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
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa[at]dotnetfunda.com http://www.Dotnetfunda.com
Maybe your 0.05 is really 0.0466666666 ?
-
Maybe your 0.05 is really 0.0466666666 ?
yes that is correct
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa[at]dotnetfunda.com http://www.Dotnetfunda.com