### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Downloads
- The history of the theory of beam bending - Part 1
- Frame Analysis with Excel 1 - Single beam
- Contour plots with Excel and Matplotlib
- Function roots with the Inverse Quadratic Method
- Frame Analysis with Excel - 4, 2D frame analysis
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Drawing in Excel 7 - Creating drawings from coordinates
- Downloads by category

### Recent Comments

# Tag Archives: Evaluate

## Evaluate integrals to a specified tolerance

A previous post presented a user defined function (UDF) to perform a numerical integration of a function specified as a text string. The UDF allowed the number of subdivisions of the integration range to be specified, but the number of subdivisions required to … Continue reading

Posted in Excel, Maths, Newton, UDFs
Tagged Evaluate, Excel, numerical integration, Simpson's Rule, UDF, VBA
2 Comments

## Evaluate Function – update

Previous post The evaluate function described in the previous post has been used in writing a UDF that will evaluate the integral of any suitable function over a specified range. The revised worksheet can be downloaded from: Eval.zip

## Evaluate Function

It would often be convenient to evaluate a function entered as text; for instance if we have the function for the deflection of a cantilever under point loading at the end: F*L^3/(3*E*I) then it would be convenient to be able … Continue reading