Prevent recalculation of NOW() function in Col B that depends on values entered in Col A.
Posted on 2011-04-30
Values are scanned into cells in Col A and the adjacent cell in Col B has the following calculation.
CELL B2: =If(A2="","",NOW())
CELL B3 =If(A3="","",NOW())
CELL B4 =If(A4="","",NOW())
The intial calc works OK for each entry in Col A, but the previous calc in Col B recalculates to the
current NOW() value.
I need to keep the original value calulated, for example, in Cell B2 that was calculated when a
value was entered into Cell A2.
Currently, the value in Cell B2 is recalculting when (ie, all previious calculated values in Col B
are recalulating) when subsequent values are scanned into sunsequent cells in Col A such as
Cell A3, Cell A$, etc.