If cell (A) = a predetermined value then cell (B) = x. A simple if
statement,but, I want cell (B) to act as a latch. Once cell (A) has
switched cell (B) to X I want cell (B) to stay in that condition even if the
value of cell (A) changes from the predetermined value. i.e. I want cell
(B) to behave like a latch, once it has been switched on it stays on
regardless. Can you help. Kind regards
--
KenH