T
Terry Plampin
I have a worksheet which returns a TRUE result when evaluating whether the
contents of a cell matches the given criteria when the cell is empty or
contains a zero. Any entry into the cell is evaluated correctly, giving as
FALSE an entry that does not match the criteria exactly. Other worksheets in
the same workbook evaluate the empty cell correctly, supplying TRUE only when
the contents of the cell exactly match the criteria. How do I fix this
problem?
contents of a cell matches the given criteria when the cell is empty or
contains a zero. Any entry into the cell is evaluated correctly, giving as
FALSE an entry that does not match the criteria exactly. Other worksheets in
the same workbook evaluate the empty cell correctly, supplying TRUE only when
the contents of the cell exactly match the criteria. How do I fix this
problem?