Tag Archives: Evaluate

Using VBA Evaluate as an Array Function

Posted on August 24, 2018 by

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 , , , , | 2 Comments

Daily Download 15: Evaluation of formulas in text

Posted on October 1, 2012 by

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 , , , , , | 1 Comment

Return of Excel – Evaluating commas

Posted on June 14, 2012 by

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 →

Posted in Excel, UDFs, VBA | Tagged , , , , , | 4 Comments

More on the Excel Evaluate function

Posted on December 14, 2010 by

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 , , , , , , , | 4 Comments

Evaluate integrals to a specified tolerance

Posted on March 10, 2009 by

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 , , , , , | 2 Comments

Evaluate Function – update

Posted on July 5, 2008 by

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

Posted in Excel, Maths, UDFs | Tagged , , , , | 5 Comments

Evaluate Function

Posted on April 22, 2008 by

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 →

Posted in Excel, Maths, UDFs | Tagged , , | 9 Comments