special function

  • Thread starter Thread starter Peter
  • Start date Start date
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
 
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
 
Back
Top