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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
fyon said:
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
Click to expand...
calculate the rate of change for me, please??
 
Back
Top