make a cell do nothing in excel?

Question

In excel, I am trying to make a cell update via live feed but I want it to STOP updating when a certain condition is met - ie, when condition is met, cell should simply stay the same. How do I do this?

I know how to use an if statement - what i don't know is what i will have the return be. in other words, i will have

if(month
livefeed is a value imported that updates every minute. what i want is that when the condition is broken, the cell retains the last value it had before the condition was broken. so where the '?' is i want a function that effectively "does nothing."

Answer 1

Use an IF statement to check for the value and then tell to break link once that value is met:

Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.

PER EXCEL HELP:

IF(logical_test,value_if_true,value_if_false)

Logical_test is any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE. This argument can use any comparison calculation operator.

Value_if_true is the value that is returned if logical_test is TRUE. For example, if this argument is the text string "Within budget" and the logical_test argument evaluates to TRUE, then the IF function displays the text "Within budget". If logical_test is TRUE and value_if_true is blank, this argument returns 0 (zero). To display the word TRUE, use the logical value TRUE for this argument. Value_if_true can be another formula.

Value_if_false is the value that is returned if logical_test is FALSE. For example, if this argument is the text string "Over budget" and the logical_test argument evaluates to FALSE, then the IF function displays the text "Over budget". If logical_test is FALSE and value_if_false is omitted, (that is, after value_if_true, there is no comma), then the logical value FALSE is returned. If logical_test is FALSE and value_if_false is blank (that is, after value_if_true, there is a comma followed by the closing parenthesis), then the value 0 (zero) is returned. Value_if_false can be another formula.

Remarks

Up to seven IF functions can be nested as value_if_true and value_if_false arguments to construct more elaborate tests. See the last of the following examples.
When the value_if_true and value_if_false arguments are evaluated, IF returns the value returned by those statements.
If any of the arguments to IF are arrays, every element of the array is evaluated when the IF statement is carried out.

Answer 2

use an IF statement?