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
|