J
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
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