Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Latex Maths Text in Excel
- Deflections and Moments in Rectangular Plates
- Downloads by category
- Fitting high order polynomials
- Retrieving unique values from a range or array ...
- Using conditional formatting with array formulas
- P-Y Curve function
Recent Comments
Tag Archives: floating point comparison
Comparing floating point numbers
Some of the issues raised in this post: https://newtonexcelbach.wordpress.com/2011/12/20/when-does-35-not-equal-35/ arose when writing the functions for the previous post on combining arrays. In particular, when values from the two arrays are “equal” the function should create one entry in the combined … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged Combinearray, EqualT, Excel, floating point comparison, UDF, VBA
4 Comments