special function

P

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
 
F

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
 
Top