On Thu, 17 Jul 2008 12:49:29 -0700, Terry Plampin
wrote:

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

You are terribly imprecise in what you write. Your formula cannot possibly
return FALSE, only 1 or 0. Also, you fail to mention what version of Excel you
are using, as that makes a difference as to whether you really mean "worksheet"
or "workbook".

But it may be that you have given us an incorrect formula, or that you meant 0
when your wrote FALSE.

It may be that you are using Excel 2007, or that you are using 2003 or earlier
and meant workbook instead of worksheet.

This is important in telling you how to fix things; but it is likely that you
have Transition Formula Evaluation selected. Exactly where to find this
depends on the version of Excel you are using.

If you indeed mean sheet instead of book, then select the office button in the
upper left hand corner; Excel Options at the bottom and go to the Advanced
option. Then scroll down to the bottom looking for Lotus compatibility
settings for this particular sheet.

It's in a different place if you are using 2003.
--ron