Forum Discussion
Locking a cell value after successful IF function.
Hello, i have a result (number) in a cell as a result of a successful IF function, which is controlled on the sheet under an auto-refresh. I want to 'lock' or leave, the value in the cell after the I...
That probably requires VBA code, but we'd need to have more detailed information.
- What is the formula?
- Which cell or cells have the formula?
=IFS(K4=TRUE, $J$5)