Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- Cubic Splines
- Solving non-linear equations with two or more unknowns – 3
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Beam actions and deflections by Macaulay's Method
- Taming Symbols in Excel
- Downloads
- Downloads by category
- Buckling of columns with varying cross section
Recent Comments
Tag Archives: maximum absolute value
Two MaxAbs functions
Excel does not have a built-in function to find the maximum absolute value of a range, perhaps because the Max() and Abs() functions can be combined in an array function: =Max(Abs(datarange)) This solution has a number of drawbacks however: The … Continue reading
Posted in Arrays, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, MaxAbs function, maximum absolute value, UDF, VBA
9 Comments