Excel 2007 storing the high and low

[John F]

Here is the logic of what i am trying to do;

IF cell C1 > cell D1 then cell D1 equals cell C1 otherwise cell D1 remains
unchanged
also
IF cell C1 < cell E1 then cell E1 equals cell C1 otherwise cell E1 remains
unchanged

The value of cell A1 is entered manually and will change over time
The value of cell B1 is entered manually and will change over time
The value of cell C1 is calculated as cell B1 / cell A1
Initial value of cell D1 is 0
Initial value of cell E1 is 1,000
In effect cells D1 and E1 will become the historical high or the historical
low

 

[David Biddulph]

Circular references are normally to be avoided, but if that's what you want
to do, "circular reference" is the topic to look up in Excel help.

 

[John F]

I am not sure if circular reference applies or not.
I am not exactly shure if this will work in Excel but this is the logic in
Access.

PerPrice = Price / Quantiy
If PerPrice > HighPrice Then HighPrice = PerPrice
If PerPrice < LowPrice Then LowPrice = PerPrice

Translated to the excel set up

C1 = B1 / A1
If C1 > D1 Then D1 = C1
If C1 < E1 Then E1 = C1

 

[John F]

Thanks

If your formula in D1 is referring to the value in D1, then it IS a circular
reference.
If your formula in E1 is referring to the value in E1, then it IS a circular
reference.

Do so at your own risk. You may wish to read through this newsgroup's
archives and see the warnings against use of circular references.