Incorrect logic evaluation

  • Thread starter Thread starter Terry Plampin
  • Start date Start date
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?
 
Can you post your equations and what they refer to? A couple examples will
help us better facilitate answers. Thanks!
 
Back
Top