Help about an automation i want to create

[damav78]

Hi, I would like your help in an issue that i cannot find a way to solve.
I have 2 cells.
The first one has a dropdown list with one option only available.
The second one is a formula cell that collects multiple data from other cells and its dynamic. It means that when i change values to other cells this cell is affected.
So what i would like to do is:
When the first cell is blank the values on second cell to change as normally do (dynamically).
If from the first cell i choose the predefined value from my dropdown list then the second cell to actually "lock" the current value that has at that moment and dosen't be affected anymore from any changes.
Thank you in advance

 

[damav78]

I have no way of testing it with a comma because in Canada the default is the dot.

Ok I could format all the cells in the column as numbers and use it like this. Can you just add the € sign at the end of the formula or this could affect any other formula I use with that cell like the one at the right of that cell?

 

[mumps]

Doing that could affect the formatting of the number in column T and the formula in the cell to the right. You could include the euro symbol in the header in T1 to indicate that the column contains euros: Κόστος Συσπόρου Σε Τιμή Εκκοκκισμένου (€)