special function

[Peter]

I am looking for a function similar to

"if(condition; calculate something; retain current value)".

This means, the value in the cell shall only be recalculated, if the
condition is met, else the current value is kept.

Thanx for any hint.

Peter

 

[Frank Kabel]

Hi Peter

IMO this can't be done by a worksheet function. You have to use VBA
(e.g., process the worksheet_change event).
Frank