>Hi 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,
>>Real concern was not excel or display format, it was only the simpliest way I thought to show the problem. .Net, C, SQL server also have the same problem.
>>Cetin
>>Ok. I'm sorry. 8-D
>PS: (SQL Server 2000) I put, in Query Analyser,
Select 1*(0.5-0.4-0.1) Result and the Result's
.0.
Yes but it's an analyzer bug which I think VB based. It doesn't always show you the correct values from tables.
Cetin