View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GW GW is offline
external usenet poster
 
Posts: 1
Default Simple nested if and statement


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.