If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel 2007 storing the high and low
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 |
#2
|
|||
|
|||
Excel 2007 storing the high and low
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 |
#3
|
|||
|
|||
Excel 2007 storing the high and low
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 "David Biddulph" wrote: 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 |
#4
|
|||
|
|||
Excel 2007 storing the high and low
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. -- David Biddulph John F wrote: 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 "David Biddulph" wrote: 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 |
#5
|
|||
|
|||
Excel 2007 storing the high and low
Thanks
"David Biddulph" wrote: 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. -- David Biddulph John F wrote: 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 "David Biddulph" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|