View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default How can I calculate instantaneous rate of change in excel?

Hi,

Not exactly sure what your looking for but maybe:

=IF(A2<0,B2/A2,"")
copied down

you need to check for a value in A2 because if A2 is empty then you get a
#DIV/0! error.

HTH
Jean-Guy

"nexxusvp" wrote:

I have a two columns of data in excel (x) and (y). I want to
calculate instantaneous rate of change for values in (y) with respect
(x). How can I do this?

X Y dy/dx
1 10
2 100 ?
3 1000 ?
4 10000 ?
5 100000 ?