How do I retrieve a value from cell 2 to cell 1 if cell 2 contains a value and cell 1 is empty, but prioritize to let a value be input in cell 2 while the formula in cell 2 is protected in the background?
I have this formula in cell 1 (although it needs to be changed according to my requirement I state in this question):
In cell 2, I only enter a number like 79 or 79.5 for example.
So first priority is that I can enter a value (for example 89 or 89.5) in cell 1 while the formula is protected in the background.
Second priority is that if cell 1 is empty (the formula still there, so it's really not 'empty') the value from cell 2 should be retrieved to cell 1 while the formula is protected in the background.
Third priority is that if cell 2 is also empty no error message or anything should be written in cell 2 ("iferror").