Simple nested if and statement

[GW]

Is anyone able to help with the following?

I have data with relationships represented in columns A and B and want to create a function to give the output in the final column.

I think I need a nested if / and statement but not sure exactly how to configure it.

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

Many thanks.

 

[Claus Busch]

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","Partial","None"))


Regards
Claus B.

 

[gareth.wretham]

That does the trick! Thanks very much indeed.