circular reference

[Thomas Knapp]

This formalu is in cell E18. Every time I change the
time in this formula, I loose the original data which was
sourced from F18 before. When I change the time, the
sell goes to back to zero. Is there any way to change
the time "21:30" without loosing the base data in the
cell?

=IF(TIMEVALUE(TEXT(MAX(D218),"hh:mm"))=TIMEVALUE
("21:30"),F18,E18)

 

[Vasant Nanavati]

You can't have two values in a single cell. The value in the cell will equal
either F18 or E18, but it can't assume one value and remember the other.

 

[Guest]

I'm only changing the time which will affect how it gets
now data in the future, but for the time being I'm not
expecting it to assume new data, only to keep its
original value?

Thomas

 

[Vasant Nanavati]

You can't do that. Once you change the formula, the value will be determined
by the new formula.

If you explain exactly what you want to accomplish, there is probably a
macro solution to the problem.