View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fyon Fyon is offline
external usenet poster
 
Posts: 1
Default calculate the derivative (rate of change) of variables

Hello everyone:
Does anyone know how to calculate the derivative (rate of change) of different variables in Excel?
For example, we have columns A, B, C
A B C
5 4 6

the rate of change between column A&B is -20% ((4-5)/5) and the rate of change between
column B&C is +50% ((6-4)/4).

Can anyone please tell me what I should do to set up a sheet that calculate the rate of change for me, please??
Thanks very much!!

fyon