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 IF function places it there, and particularly, after the sheet auto-refreshes and the IF function turns the value in question 'off'. Is there a way to do this? Or, is there another function i can use which would help? TIA
13 Replies
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?
- Formula lies in K5, L5, M5 etc
Thank you! Will the user enter TRUE or FALSE in K4, L4 etc., or do those cells contain formulas too?
I'm trying to find out which cells, when edited directly by the user, will determine the result of the formulas in K5, L5 etc.
- =IFS(K4=TRUE, $J$5)
