LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I calculate instantaneous rate of change in excel? nexxusvp Excel Discussion (Misc queries) 4 May 2nd 23 07:46 PM
how to calculate billable rate using base rate and percentage Felicia Pickett Excel Worksheet Functions 3 February 28th 10 12:26 PM
How to Calculate the Interest rate Hardeep_kanwar[_2_] Excel Discussion (Misc queries) 2 March 23rd 09 05:43 PM
How to calculate the rate of sale? Grd Excel Worksheet Functions 1 March 22nd 07 07:12 PM
Calculate Rate of Change Formula Zee New Users to Excel 6 September 29th 06 06:03 PM


All times are GMT +1. The time now is 11:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"