Simple nested if and statement

G

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.
 
C

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
Click to expand...

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


Regards
Claus B.
 
Top