Working in Excel, I encountered all sorts of issues with floating point numbers. Excel had to deal with NaNs (of which there are many), +/- infinity, negative zeros (1/NegativeInfinity), and denormalized numbers (numbers smaller than 1/double.MaxValue but larger than zero). In addition, there were also a number of rounding issues,

Read more »
Jan 10, 2005, 4:17PM

.NET
,

Math