Partial Derivatives

[wildcat2]

I use Excel to model a chemical process.
In order to do optimization search I need to find the (partial
derivatives (first and second) of certain cells with respect to othe
cells.
Without having to take the analytical derivative (which may be ver
time consuming as some of the formulae are very complex) has anyon
developed a function to calculate the numerical derivative

 

[Kevin Stecyk]

I use Excel to model a chemical process.
In order to do optimization search I need to find the (partial)
derivatives (first and second) of certain cells with respect to other
cells.
Without having to take the analytical derivative (which may be very
time consuming as some of the formulae are very complex) has anyone
developed a function to calculate the numerical derivative ?

Wildcat2,

I encourage you to investigate the following post...

From: Tushar Mehta ()
Subject: Re: derivatives and integrals
View: Complete Thread (11 articles)
Original Format
Newsgroups: microsoft.public.excel.programming
Date: 2000/03/22

which can be found at the following URL...

http://tinyurl.com/2tpku

I found this posting by going to the following URL and searching Google's
archives of newsgroup postings...

http://www.google.com/advanced_group_search?q=group:*excel

If Tushar's solution doesn't meet your needs, you might want to circle back
to Google and see other related hits.

I hope this answer is of benefit.

Regards,
Kevin