Computing Numerical Derivatives in Excel

Compute numerical derivative of a function

Use DERIVF to compute first and higher order derivatives of a function f(x) at x=p using highly accurate adaptive algorithm.

Compute numerical derivative from discrete data points

Use DERIVXY to compute a numerical derivative at a point within a discrete set of (x,y) data points using cubic splines.

Compute partial derivatives

You can nest DERIVF to compute partial derivatives of any order.

Select your topic for detailed description and examples.

Question or Comment? Email us:
support @
ExceLab: Transforming Excel into a Calculus Power House
ExceLab functions and methods are protected by USA Patents 9286286, 9892108, 10114812 and pending.
© 2015-2019, ExcelWorks LLC
Boston, USA