Set up master sheet to calculate derivatives(rate of change)

[Guest]

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

 

[Bernie Deitrick]

fyon,

=New/Old -1

so with the values you give, if they were in row 1

=B1/A1-1

Format for percentages, and copy as far as you need....

HTH,
Bernie
MS Excel MVP

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??