Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why not 1*(0.5-0.4-0.1) = 0?
Message
From
07/01/2005 05:39:27
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brazil
 
 
To
06/01/2005 18:19:49
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Database:
MS SQL Server
Miscellaneous
Thread ID:
00974881
Message ID:
00975005
Views:
31
Hi Cetin,

>A friend of mine asked this to me today. I said yes,0 with confidence and he said OK then go and put that in Excel as a formula.
>I thought it was an Excel bug but he turned and said it happens in SQL server with float datatype! I couldn't yet see that myself but trust his experience.
>Any idea and solution?
>TIA
>Cetin

When I put this formula in Excel the result's -2,77556E-17, but if I format the cell to number, the result's 0. When do you format cell to number the same occcur?
Btw, Congrats for Personality!
Erick
Força Sempre!
Strength Always!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform