Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Using LINEST for non-linear curve fitting
- Filling Blanks with Go To-Special (and local help rant)
- XLDennis, the MSDN Library, and VBA rant
- About Newton Excel Bach
- Cubic Splines
- Writing Arrays to the worksheet - VBA function
- Downloads
- Daily Download 5: Frame Analysis
- Worksheetfunction.Transpose - changed behaviour in Excel 2013 and 2016
Recent Comments
Tag Archives: equation solver
Calling a function as a variable – another example
The recent posts on the Inverse Quadratic Method and Brent’s Method, and on calling a function as a variable, are leading towards a user defined function (UDF) to analyse circular reinforced concrete sections under combined bending and axial load, but since … Continue reading
Posted in Concrete, Excel, Maths, UDFs, VBA
Tagged Brents method, equation solver, Excel, iteration, UDF, VBA
3 Comments
Calling a function as a variable
The functions described in recent posts provide iterative solutions to polynomial equations, but the same method can be used for any equations that can be evaluated numerically and have a single variable. The question then is, how can we call a … Continue reading
Posted in Arrays, Excel, Maths, UDFs, VBA
Tagged application.run, calling a function, equation solver, Excel, iteration, UDF, VBA
6 Comments