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

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


Regards
Claus B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top