View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
icehot icehot is offline
external usenet poster
 
Posts: 1
Default How do I create a cell whose value can only go up, not down?

Hi

I have a formula in a cell currently, that is based on the value i
another cell. As the value in the other cell increases I want th
formula to be in effect and continue to calculate increasing values

However, if the value in the other cell goes down, I no longer wan
this formula to do anything, ie. the value it last calculated remain
in effect

For your information this is to create a rising stop loss in an exce
portfolio. Hence the price may go up or down, but the stop los
limit must only continue to rise

Thanks