Calculate Rate of change in Excel

[meatkutter]

I have got a problem and I just cannot work out how to solve it.

I have spreadsheet in Microsoft Excel, which controls
various outputs depending on the various inputs to the system.

I need to calculate the rate of change (change per min) increase or decrease of a cell that constantly updates, and stores the rate of change in a third cell.

In my case I would required the calculation to be made when a third cell is "TRUE" based on a simple excel calculation rather than an input from an external device.

I am sure that it must be possible to calculate using standard excel functions - but I just cant solve it!

Does anyone have any ideas?

 

[lespaul]

You would probably have better luck asking this in the VBA forum. when the value of the third cell changes run a macro that checks the new value and then calculates the variance in the other two cells.

HTH Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!