How about posting exactly what *is* in J6 & J7 & J8,
And what *might* be in each of them.

Keyed in data - What kind - text, or numbers, give examples -

Formulas - do they return text, or numbers, or nulls ( "" - zero length
strings), or logicals (True, False), or error values (#N/A!) - post the
formulas -

Imported data - possibly containing invisible characters -

The more information you give concerning the contents of the cells in
question will enable you to receive more viable suggested solutions.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jon" wrote in message
...
SteveG,

I copied and pasted it still it showing a Yes when it should not.

I really appreciate the help with all this from all three of you!

Any more suggestion?

Jon

"SteveG" wrote:


Does this work?


=IF(AND(ISBLANK(J7),J8J6),"Yes",IF(J8J7,"Yes","" ))


Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=495474