### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Cubic Splines
- Section Properties with MeshPY, including torsion and warping
- Using LINEST for non-linear curve fitting
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Drawing in Excel 7 - Creating drawings from coordinates

### Recent Comments

Bett’s Dance |… on Jansch and Renbourn live Massimo Mula on Smart Indenter and Excel … dougaj4 on Multiple Integration with… dougaj4 on Multiple Integration with… dougaj4 on Multiple Integration with… Excel Developer (@ex… on Multiple Integration with… Excel Developer (@ex… on Multiple Integration with… Excel Developer (@ex… on Multiple Integration with… dougaj4 on Another (very slow) way of com… Matt on Another (very slow) way of com… Bouarfa Mahi on Using the AlgLib ODE (Runge-Ku… dougaj4 on Using the AlgLib ODE (Runge-Ku… Bouarfa Mahi on Using the AlgLib ODE (Runge-Ku… Larry on Scarborough Fair g2-9ed9acc685824c666… on Scarborough Fair

# Tag Archives: Evaluate

## Using VBA Evaluate as an Array Function

I recently discovered from a thread at Chandoo’s Excel Forum that the VBA Evaluate function can be used as an array function. As a simple example: Range(“A11:A16”).Value = Evaluate(“= B11:B16 + C11:C16”) will add the values in columns B and C, … Continue reading

Posted in Arrays, Coordinate Geometry, Excel, Maths, UDFs, VBA
Tagged array functions, Evaluate, Excel, UDFs, VBA
2 Comments

## Daily Download 15: Evaluation of formulas in text

VBA has an Evaluate function that returns the numerical value of any text string representing a mathematical formula, but this is not directly available from the spreadsheet. Today’s download is a User Defined Function (UDF) to provide this functionality, together with examples … Continue reading

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Evaluate, evaluation of text strings, Excel, numerical integration, UDF, VBA
1 Comment

## Return of Excel – Evaluating commas

The Newton/Galileo posts here will continue with their Italian theme for some time yet, but since I am now back in Australia it’s time to give Excel a look in again. I recently (well a couple of months ago) had … Continue reading

## More on the Excel Evaluate function

Previous posts have presented the Eval() User Defined Function, using the Evaluate function in VBA to evaluate mathematical functions displayed as text (Evaluate Function, Evaluate Function – Update). It was recently pointed out by Jeff Weir that the Evaluate function has its origins … Continue reading

Posted in Excel, Newton, Numerical integration, UDFs, VBA
Tagged Eval, EvalText, Evaluate, Excel, numerical integration, Substitutea, UDF, VBA
4 Comments

## 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