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?
- 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.
=AND($G$2<=K2+0.0004,$G$2>=K2-0.0004)
Thus is the code that generates the true/false, its looking at 2 numbers only, factoring in a tolerance when matching their similarity.
- =IFS(K4=TRUE, $J$5)
