Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Override a Formula
Is there a way to freeze or override a formula in a cell when the correct
information is in the cell. The formula I have in the cell is to find a correct date, when the right day comes along. I down load new information everyday to this spreedsheet. I would like the Date to freeze when the formula picks it up. Thanks -- J.K. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Override a Formula
Hi John:
What is the right date? How is it determined? Who decides that the date is the correct one? A few options: Use an onchange event macro. Use a button to set the value when the user confirms. Use an if statement: =if(today()date(2007,1,1),"after","not yet) or =if(today()a1,"after","not yet) or if (b1a1,"after","not yet) -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "John K." wrote: Is there a way to freeze or override a formula in a cell when the correct information is in the cell. The formula I have in the cell is to find a correct date, when the right day comes along. I down load new information everyday to this spreedsheet. I would like the Date to freeze when the formula picks it up. Thanks -- J.K. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Override a Formula
I am unfimiliar with macros, can you explain how I would need to setup an
onchange event macro or a button to set the value when the right date meets the criteria? -- J.K. "Martin Fishlock" wrote: Hi John: What is the right date? How is it determined? Who decides that the date is the correct one? A few options: Use an onchange event macro. Use a button to set the value when the user confirms. Use an if statement: =if(today()date(2007,1,1),"after","not yet) or =if(today()a1,"after","not yet) or if (b1a1,"after","not yet) -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "John K." wrote: Is there a way to freeze or override a formula in a cell when the correct information is in the cell. The formula I have in the cell is to find a correct date, when the right day comes along. I down load new information everyday to this spreedsheet. I would like the Date to freeze when the formula picks it up. Thanks -- J.K. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Override a Formula
Please can you explain how the date becomes correct and then I may be able to
help but at present I am unsure how the date becomes correct. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "John K." wrote: I am unfimiliar with macros, can you explain how I would need to setup an onchange event macro or a button to set the value when the right date meets the criteria? -- J.K. "Martin Fishlock" wrote: Hi John: What is the right date? How is it determined? Who decides that the date is the correct one? A few options: Use an onchange event macro. Use a button to set the value when the user confirms. Use an if statement: =if(today()date(2007,1,1),"after","not yet) or =if(today()a1,"after","not yet) or if (b1a1,"after","not yet) -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "John K." wrote: Is there a way to freeze or override a formula in a cell when the correct information is in the cell. The formula I have in the cell is to find a correct date, when the right day comes along. I down load new information everyday to this spreedsheet. I would like the Date to freeze when the formula picks it up. Thanks -- J.K. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Override a Formula
Page 1
A B C E F G symbol high close date Profit Profit Date abc 50.55 50.34 29/12/06 $50.86 hij 61.94 61.4 29/12/06 $62.03 let 54.44 53.66 29/12/06 $54.22 This is the formula that is in column "G" =IF(LOOKUP($A6,Page2!$A$2:page2!$A$38,page2!$B$2:p age2!$B$38)F6,LOOKUP($A6,page2!$A$1:page2!$A$40,p age2!$D$1:page2!$D$40),"") Page2 A B C D symbol high close date abc 46.85 46.78 09/02/07 let 42.89 41.7 09/02/07 hij 62 60.62 09/02/07 Page 2 critera I update everyday. So when the two symbols match in column A on page 1 and 2 and the the close price on page 2 (column "c") is greater the the profit price on page 1 (column "f") the date on page 2 (column "d") is enterd into column "f" on page 1. So my question is when column "f" on page one has a date enterd into it, is there a way to override the formula so it won't pick up a new date the next time I update the information in page 2? I hope this helps to explain it a little better. Thanks again -- J.K. "Martin Fishlock" wrote: Please can you explain how the date becomes correct and then I may be able to help but at present I am unsure how the date becomes correct. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "John K." wrote: I am unfimiliar with macros, can you explain how I would need to setup an onchange event macro or a button to set the value when the right date meets the criteria? -- J.K. "Martin Fishlock" wrote: Hi John: What is the right date? How is it determined? Who decides that the date is the correct one? A few options: Use an onchange event macro. Use a button to set the value when the user confirms. Use an if statement: =if(today()date(2007,1,1),"after","not yet) or =if(today()a1,"after","not yet) or if (b1a1,"after","not yet) -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "John K." wrote: Is there a way to freeze or override a formula in a cell when the correct information is in the cell. The formula I have in the cell is to find a correct date, when the right day comes along. I down load new information everyday to this spreedsheet. I would like the Date to freeze when the formula picks it up. Thanks -- J.K. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
use excel formula to suggest cell value, but be able to override | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |