Aug 16 2022 03:06 AM
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
Aug 16 2022 03:13 AM
That probably requires VBA code, but we'd need to have more detailed information.
Aug 16 2022 03:45 AM
Aug 16 2022 04:00 AM
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.
Aug 17 2022 08:16 PM
=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.
Aug 18 2022 12:12 AM
And are G2 and K2 entered by the user, or do they contain formulas too?
Aug 18 2022 03:13 AM
Aug 18 2022 03:24 AM
What are the formulas in G2 and K2?
Aug 18 2022 12:27 PM
Aug 18 2022 01:08 PM
Thanks. Are G1 and K1 entered by the user, or do they contain formulas too?
(I hope that you see where this is going)
Aug 18 2022 01:41 PM
Aug 18 2022 02:02 PM
We're not getting any closer, and I fear it's too complicated, sorry.
Aug 18 2022 03:23 PM