I am trying to find the same answer as Richard, but the point here is that I am not able to put the formula in the same cell because the value of this cell will be randomly changed. And when the one enters a new value, then the previously added formula gots lost. For sure it will work with VBA macro, but the one given above is not exactly the desired solution :-).

Thank you, Stephan