Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- ULS Design Functions 2.13
- About Newton Excel Bach
- Intersections, interpolations, and rotations
- Buckling of columns with varying cross section
- Fitting high order polynomials
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
Recent Comments
Tag Archives: Switch function
Daily Download 33: Miscellaneous
This is the last of the month and a bit of Daily Downloads, and consists of a bumper bundle of 20 spreadsheets with miscellaneous functions that didn’t fit in elsewhere: Repeating a set of data: for instance making three copies of … Continue reading
The Switch Function (VBA and UDF)
Switch is a VBA function that operates in a similar way to the Select Case statement. The function arguments are a series of pairs of values, the first of each pair being an expression that can be evaluated as TRUE … Continue reading
Posted in Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged Excel, PY curves, Switch function, UDF, VBA
9 Comments