cell value

[subfun]

I have a cell that is the output from a sensor. The values are constantly changing. I would like to creata neighbouring cell that tells me if the value is increasing or decreasing.
Any ideas please

[royUK]

How often is this changing?

The only way that I can think of would be to use the Change Event, the code would need to check the old value against the new.

[subfun]

the value is constantly changing as it is a live reading of changing pressures

[Jamesr571]

Does it change the cell values all the time or form a list of outputs?

You can use a simple formula;

Say old Output is in A1 and New Output is in B1

type into C1;

Please Login or Register  to view this content.

It will show you the difference

[royUK]

I think that the frequency of the change is going to be a problem