professor-excel.com
Wrong Calculations – Why Does Excel Show a Wrong Result?
Type this formula into an empty Excel cell: =1*(0.5-0.4-0.1). With this article we'll explore the reasons and the solution for wrong calculations in Excel.