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.
--
David Biddulph


"John F" wrote in message
...
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