Hi,

Am Thu, 23 Jan 2014 11:06:32 -0800 (PST) schrieb GW:

Col A Col B Output
Apples Apples Full
Apples Oranges Partial
Oranges Apples None
Oranges Oranges None

try:
=IF(A1&B1="ApplesApples","Full",IF(A1="Apples","Pa rtial","None"))


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2