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

[fyon]

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

 

[Roger Govier]

Hi Fyon

With your data in columns A, B and C as you say, enter in Cell D1
=(B1-A1)/B1
Format the cell as Percentage
Copy the formula down column D for the range of data in columns a to C

--
Regards
Roger Govier

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