I'll try to be more precise.
I am looking for a text string, for example =IF(A1="K",1,0). I expect, and
have recieved on other worksheets, FALSE, when anything, other than K,
including nothing and 0, is in the cell. The problem is that on this
particular worksheet, I get TRUE for the condition when the cell is empty or
contains a zero. This is messing up more complicated counting formulas I want
to use.
--
Terry Plampin


"Bernard Liengme" wrote:

You have bee sparse on details. Are you comparing numbers? Are you familiar
with round-off errors results from the decimal to binary conversion that all
computer apps must do?
If you want to compare a value in A1 with the number like 2.5 use
=ROUND(A1,12)=2.5, or if you are working with less precision
=ROUND(A1,6)=2.5
To see if two cells have the same value use =ABS(A1-A2)=<1E-12
which test to see if they differ by less than 1 over 1 billion
best wishes
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Terry Plampin" wrote in message
...
I have a worksheet that returns TRUE when comparing a blank or zero entry
to
the criteria. Other worksheets in the same workbook return correctly FALSE
when the contents of the cell do not match the criteria exactly. How can I
fix this problem?
--
Terry Plampin